Usage Note 53835: Character strings default to 32,767 in length with the SAS/ACCESS® Interface to Impala and the SAS/ACCESS® Interface to ODBC
Current Impala releases do not support either the VARCHAR column type or SAS table properties for extending table metadata. For these reasons, character values are stored as a STRING type, and SAS defaults the length to 32,767 in order to avoid truncation. This can result in poor performance, and the tables that are created are much larger than expected.
To limit string length under Windows, set the drivers option String Column Length in the Advanced Options of the ODBC data source.
On a UNIX system, set the DSN (data source name) property StringColumnLength.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Impala | Linux for x64 | | | 9.4 TS1M2 | |
64-bit Enabled AIX | | | 9.4 TS1M2 | |
Microsoft® Windows® for x64 | | | 9.4 TS1M2 | |
SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8 Pro x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8.1 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows Server 2008 for x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Home Premium x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Professional x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Ultimate x64 | 9.4_M2 | | 9.4 TS1M2 | |
SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8 Pro x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows 8.1 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Microsoft Windows Server 2008 for x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Enterprise x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Home Premium x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Professional x64 | 9.4_M2 | | 9.4 TS1M2 | |
Windows 7 Ultimate x64 | 9.4_M2 | | 9.4 TS1M2 | |
64-bit Enabled AIX | 9.4_M2 | | 9.4 TS1M2 | |
64-bit Enabled Solaris | 9.4_M2 | | 9.4 TS1M2 | |
HP-UX IPF | 9.4_M2 | | 9.4 TS1M2 | |
Linux for x64 | 9.4_M2 | | 9.4 TS1M2 | |
Solaris for x64 | 9.4_M2 | | 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.
Date Modified: | 2014-09-02 11:30:57 |
Date Created: | 2014-08-04 17:13:24 |