SUPPORT / SAMPLES & SAS NOTES
Problem Note 54924: Performance might be slow when you are using Hadoop views with SAS/ACCESS® Interface to Hadoop
 |  |  |  |  |
As part of the compilation phase, SAS/ACCESS Interface to Hadoop issues a SELECT * FROM [TABNAME|VIEWNAME] statement early in the SAS/ACCESS compilation phase. The statement, visible when you enable SASTRACE, is issued in order to convey to the rest of the system the metadata column of the table that is being accessed. While this operation is essentially a free run against a Hive table (that is, it runs instantaneously with very little processing overhead), it causes a MapReduce to be run when a query is issued against a View. This causes a significant performance degradation.
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 | Solaris for x64 | 9.4 TS1M2 | |
| Linux for x64 | 9.4 TS1M2 | |||
| HP-UX IPF | 9.4 TS1M2 | |||
| 64-bit Enabled Solaris | 9.4 TS1M2 | |||
| 64-bit Enabled AIX | 9.4 TS1M2 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M2 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M2 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M2 | |||