Problem Note 57814: Hadoop tables cannot be displayed with the SAS® Studio table viewer
The SAS Studio table viewer cannot open tables from a library that uses the Hadoop LIBNAME engine. One of the following error messages might be generated:
ERROR: Libref libref is not assigned
Error trying to establish connection.
A temporary circumvention is to set the SAS_HADOOP_ENABLE_INTERRUPT environment variable to NO before issuing the LIBNAME statement.
You can set the environment variable in a Sasv9_usermods.cfg configuration file that is specific to the application server being used by SAS Studio. Add a command like the following:
-set SAS_HADOOP_ENABLE_INTERRUPT "no"
You can also set the variable in your program in an OPTIONS statement before the LIBNAME statement. For example:
options set=SAS_HADOOP_ENABLE_INTERRUPT=NO;
This is a temporary circumvention that should be removed when this issue is resolved.
Operating System and Release Information
SAS System | SAS Studio | Windows 7 Ultimate x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Ultimate 32 bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Professional x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Professional 32 bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Home Premium x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Home Premium 32 bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Enterprise x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Windows 7 Enterprise 32 bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2012 Std | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2012 R2 Std | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2012 R2 Datacenter | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2012 Datacenter | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2008 for x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2008 R2 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows Server 2008 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 10 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8.1 Pro x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8.1 Pro 32-bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8.1 Enterprise x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8.1 Enterprise 32-bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8 Pro x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8 Pro 32-bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8 Enterprise x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft Windows 8 Enterprise 32-bit | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Microsoft® Windows® for x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
64-bit Enabled AIX | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
64-bit Enabled Solaris | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
HP-UX IPF | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Linux for x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
Solaris for x64 | 3.4 | 3.4 | 9.4 TS1M3 | 9.4 TS1M4 |
*
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 |
Topic: | SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2016-03-18 13:13:20 |
Date Created: | 2016-03-08 15:29:48 |