Performance might be slow when a DS2 threaded program contains PROC FedSQL code embedded in the SET statement, and the threaded program is run in SAS In-Database Code Accelerator for Hadoop. A single query is prepared multiple times instead of once during compilation.

Also, when merging data sets stored in Hadoop using the SAS In-Database Code Accelerator for Hadoop, you might see the following errors:

ERROR: Compilation error.   
ERROR: Line 55: Unable to prepare merge statement (rc=0x80fff802U).

To circumvent both problems, do not use SAS In-Database Code Accelerator for Hadoop. Please note that all processing will take place on the client rather than in Hadoop.

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

Operating System and Release Information

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