SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 63820: Expanding Hadoop tables in SAS® Studio Enterprise 3.7 causes multiple DESCRIBE and SELECT queries on the database

DetailsHotfixAboutRate It

When expanding Hive tables and views in SAS Studio 3.7 and displaying the list of columns in the tree view, multiple queries might be sent to the database. The multiple queries negatively affect your environment performance.

To understand how many calls are sent to the database, you can execute the following options:

options sastrace=",,,d" sastraceloc=saslog nostsuffix;

To reduce the number of calls sent to the database, you can set the webdms.workspaceServer.allowGetRecordCount option to false.

This option is set to true by default.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS StudioMicrosoft® Windows® for x643.79.4 TS1M5
Microsoft Windows 8 Enterprise 32-bit3.79.4 TS1M5
Microsoft Windows 8 Enterprise x643.79.4 TS1M5
Microsoft Windows 8 Pro 32-bit3.79.4 TS1M5
Microsoft Windows 8 Pro x643.79.4 TS1M5
Microsoft Windows 8.1 Enterprise 32-bit3.79.4 TS1M5
Microsoft Windows 8.1 Enterprise x643.79.4 TS1M5
Microsoft Windows 8.1 Pro 32-bit3.79.4 TS1M5
Microsoft Windows 8.1 Pro x643.79.4 TS1M5
Microsoft Windows 103.79.4 TS1M5
Microsoft Windows Server 20083.79.4 TS1M5
Microsoft Windows Server 2008 R23.79.4 TS1M5
Microsoft Windows Server 2008 for x643.79.4 TS1M5
Microsoft Windows Server 2012 Datacenter3.79.4 TS1M5
Microsoft Windows Server 2012 R2 Datacenter3.79.4 TS1M5
Microsoft Windows Server 2012 R2 Std3.79.4 TS1M5
Microsoft Windows Server 2012 Std3.79.4 TS1M5
Microsoft Windows Server 20163.79.4 TS1M5
Windows 7 Enterprise 32 bit3.79.4 TS1M5
Windows 7 Enterprise x643.79.4 TS1M5
Windows 7 Home Premium 32 bit3.79.4 TS1M5
Windows 7 Home Premium x643.79.4 TS1M5
Windows 7 Professional 32 bit3.79.4 TS1M5
Windows 7 Professional x643.79.4 TS1M5
Windows 7 Ultimate 32 bit3.79.4 TS1M5
Windows 7 Ultimate x643.79.4 TS1M5
64-bit Enabled AIX3.79.4 TS1M5
64-bit Enabled Solaris3.79.4 TS1M5
HP-UX IPF3.79.4 TS1M5
Linux for x643.79.4 TS1M5
Solaris for x643.79.4 TS1M5
* 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.