Usage Note 53568: Hadoop table names might be prepended to all column names in the table when you are using a distribution of Hadoop that contains Hive .13
 |  |  |  |  |
Beginning with Hive .13, a new Hive property called hive.resultset.use.unique.column.names was created. The default value of this property is TRUE.
If the default value is used, the Hadoop table name is prepended to all column names. This is a change in behavior from previous versions of Hive.
This change might cause errors when you access the tables from SAS, because the column names do not match the names that SAS expects.
To prevent the Hadoop table names from being prepended to the column names, use this property setting in the Hive-site.xml file.
<property>
<name>hive.resultset.use.unique.column.names</name>
<value>false</value>
</property> Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Hadoop | Windows 7 Enterprise x64 | 9.4_M1 | 9.4 TS1M1 | ||
| Windows 7 Home Premium x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft® Windows® for x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Pro | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Solaris for x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Linux for x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| HP-UX IPF | 9.4_M1 | 9.4 TS1M1 | ||||
| 64-bit Enabled Solaris | 9.4_M1 | 9.4 TS1M1 | ||||
| 64-bit Enabled AIX | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Ultimate x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Professional x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Professional 32 bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 Std | 9.4_M1 | 9.4 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Pro x64 | 9.4_M1 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M1 | 9.4 TS1M1 | ||||
A fix for this issue for SAS/ACCESS Interface to Hadoop 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R21.html#53568| Type: | Usage Note |
| Priority: |
| Date Modified: | 2014-10-28 16:42:07 |
| Date Created: | 2014-07-15 13:53:12 |