Problem Note 68575: Multiple "select version()" calls are sent to the Hive database, causing slow performance for the SAS® 9.4M7 (TS1M7) release
 |  |  |  |  |
You might experience degradation in performance when you query an Apache Hive table. This degradation occurs because multiple "select version()" calls are sent to the Hive database.
To determine how many "select version()" calls are sent to the Hive database, you can execute the following options:
options sastrace=",,,d" sastraceloc=saslog nostsuffix;
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 8.1 Enterprise x64 | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 |
| Microsoft® Windows® for x64 | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Linux for x64 | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.47 | 9.48 | 9.4 TS1M7 | 9.4 TS1M8 | ||
A fix for this issue for SAS/ACCESS Interface to Hadoop 9.47 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J8A.html#68575| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-11-16 09:10:22 |
| Date Created: | 2021-11-04 09:59:59 |