Loading

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

Date de publication: Mar 11, 2025
Description

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.
Résolution
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.
 
Numéro d’article de la base de connaissances

001534759

 
Chargement
Salesforce Help | Article