SUPPORT / SAMPLES & SAS NOTES
Problem Note 60491: When you use SQL pass-through with SAS® Scalable Performance Data Server 5.1, the HADOOP table and macro options are ignored
 |  |  |  |  |
If you include the table options ACCELWHERE and PARALLELREAD or the macro options SPDSACWH and SPDSHPRD SQL in your SQL code, the options are ignored. These options are not currently supported with SQL pass-through in SAS Scalable Performance Data Server 5.1.
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | SAS Scalable Peformance Data Server | 64-bit Enabled Solaris | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 |
| 64-bit Enabled AIX | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 10 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| HP-UX IPF | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Linux for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||
| Solaris for x64 | 5.1 | 5.1 HF3 | 9.4 TS1M0 | 9.4 TS1M3 | ||