All Forums Aster
mm185159 21 posts Joined 03/11
27 Jun 2016
using Teradata Stored Procedures to pull data into Aster

I am unable to get a stored procedure call that returns a dynamic data set to execute from Aster via the TDConnector. Is this becasue the QueryGrid function load_from_teradata only supposts a SQL Select statement, period? If so, is there any other method or function that can call a TD SP to return data to aster and load into an Aster table?
 

M.Saeed Khurram 544 posts Joined 09/12
28 Jun 2016

Hi,
load_from_Teradata is an MR function that can only be called inside a SELECT statement. But you can call this select query inside Procedure and use the resultset in your procedure.
Please let me know what actually you want to achieve?
 
Br,
Khurram

Khurram

mm185159 21 posts Joined 03/11
28 Jun 2016

So, I am trying to call a teradata stored procedure due to complex processing that works best on teradata (push-down). The stored procedure then returns a result set (dynamic data set) which needs to be loaded into an Aster table. Basically, I need an SQL-MR function that allows one to execeute a stored procedure native to teradata.
 

M.Saeed Khurram 544 posts Joined 09/12
28 Jun 2016

One possible option is to execute the procedure on Teradata and store the results in a table, then use that table as source in load_from_teradata MR function.
 

Khurram

You must sign in to leave a comment.