SUPPORT / SAMPLES & SAS NOTES
Problem Note 58673: Performance might be slow or errors can occur when a DS2 thread program is run in SAS® In-Database Code Accelerator for Hadoop
 |  |  |  |  |
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
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Hadoop | Microsoft® Windows® for x64 | 9.4 TS1M3 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 9.4 TS1M3 | 9.4 TS1M4 | ||
| 64-bit Enabled Solaris | 9.4 TS1M3 | 9.4 TS1M4 | ||
| HP-UX IPF | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Linux for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||
| Solaris for x64 | 9.4 TS1M3 | 9.4 TS1M4 | ||