SUPPORT / SAMPLES & SAS NOTES
Problem Note 64225: Results are returned more slowly than expected when you access Hadoop views with SAS/ACCESS® Interface to Hadoop
 |  |  |  |  |
Performance might be slow when you use SAS/ACCESS Interface to Hadoop to query Apache Hadoop views. As part of the query compilation phase, SAS/ACCESS Interface to Hadoop generates the following statements: describe formatted table-name|view-name followed by select * from table-name|view-name.
These two statements are also visible in the SAS® log when you enable the SASTRACE= option, as shown in the following example:
options sastrace=',,,ds' sastraceloc=saslog nostsuffix;
...more data...
...more data...
HADOOP_4: Prepared: on connection 0
DESCRIBE FORMATTED `default`.`CLASS_VIEW`
HADOOP_5: Prepared: on connection 0
SELECT * FROM `default`.`CLASS_VIEW` LIMIT 0 -- /* initial prepare */
DESCRIBE FORMATTED `default`.`CLASS_VIEW`
HADOOP_5: Prepared: on connection 0
SELECT * FROM `default`.`CLASS_VIEW` LIMIT 0 -- /* initial prepare */
The SELECT statement might run slowly when the query is for a Hadoop view.
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* | |||
| SAS System | SAS/ACCESS Interface to Hadoop | Microsoft® Windows® for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 |
| 64-bit Enabled AIX | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Linux for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Solaris for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||