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
| 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 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-01-14 15:32:57 |
| Date Created: | 2014-12-29 13:27:31 |
