The SAS^® In-Database Code Accelerator enables you to publish a DS2 threaded program to the database and execute that threaded program in parallel inside the database. The available databases are Hadoop, Teradata, and Greenplum. Errors like the following can occur when the PROC DS2 code includes a MERGE statement with a RENAME clause that renames one or more of the BY variables:

Click the Full Code tab to see an example of the syntax that generates the errors.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Before you run the sample code below, you need to issue a LIBNAME statement to your database with the appropriate options. The threaded PROC DS2 program can run inside Hadoop, Teradata, and Greenplum databases.

The errors occur when the RENAME= option is used in the MERGE statement for a BY variable.

libname hive1 HADOOP port=10000 schema=dev_123 host=abc user=test123;

proc ds2 ds2accel=yes bypartition=yes;

   thread t_pgm / overwrite=yes; 
      method run();

         merge hive1.ms2_tbl1(in=inTable1)
               hive1.ms2_tbl2(rename = (pid3 AS pid2) IN = inTable2);
         by pid1 pid2; 
         output;
      end; 

   endthread;


data hive1.ms2_merged (overwrite=yes);
   declare thread t_pgm t;
   method run();
      set from t;      
   end;
enddata;

run;
quit;

A fix for this issue for SAS Threaded Kernel DS2 and FedSQL Language Processors 9.41_M1 is available at: