Loading

String Fields In Database Having More Than 255 Characters Are Truncated When Connecting To Hortonworks Hadoop Hive In Tableau Desktop

Julkaisupäivä: Mar 11, 2025
Kuvaus

When connecting to Hortonworks Hadoop Hive in Tableau Desktop, if the string fields has more than 255 characters, they will be truncated to 255 characters. 

Cause

The truncation of the 'string' field to 255 characters is caused by a default String Column Length within Hortonworks Hadoop Hive ODBC driver.
Ratkaisu
1. Use TDC file to increase the String Column Length:

<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='hortonworkshadoophive' enabled='true' version='10.5'>
<vendor name='hortonworkshadoophive'/>
<driver name='hortonworkshadoophive'/>
<customizations>
            <customization name='odbc-connect-string-extras' value='DEFAULTSTRINGCOLUMNLENGTH=999' />
</customizations>
</connection-customization>

You may further change the string length if 999 is not enough for your column's length:

2. If using "Other Database (ODBC)" connector to connect to Hortonworks Hadoop Hive, you may change the default value from the ODBC DSN.
Open the DSN with ODBC Data Source Administrator (64-bit). Click on "Advanced Option" and set "Default string column length" to 999 or higher.
 
Knowledge-artikkelin numero

001534759

 
Ladataan
Salesforce Help | Article