Loading

Text/String Data Truncated When Connecting to Hive (Hadoop) via Native Connector in Tableau Desktop/Server

Udgivelsesdato: Sep 23, 2026
Beskrivelse
Symptoms:
  • Text fields display truncated data in Tableau Server/Desktop after extracting from a Hive/Hadoop data lake as .hyper files.
  • Full string values are visible in the source system but cut off (commonly at 255 characters) in Tableau.


Root Cause:
The native hadoophive connector does not honor a standalone DefaultStringColumnLength customization in a .tdc (Tableau Datasource Customization) file. It must instead be passed as part of the ODBC connection string via the odbc-connect-string-extras parameter.
Løsning
esolution / Workaround:
  1. Create a .tdc file named exactly hadoophive.tdc with the following content:
<connection-customization class='hadoophive' enabled='true' version='10.0'>
<vendor name='hadoophive' />
<driver name='hadoophive' />
<customizations>
<customization name='odbc-connect-string-extras' value='DefaultStringColumnLength=9999' />
</customizations>
</connection-customization>
  1. Tableau Desktop: Place the file in Documents\My Tableau Repository\Datasources\. Ensure there is only one TDC file for this connector (duplicate/renamed copies, e.g. hadoophive 1.tdc, will prevent the customization from being picked up).
  2. Restart Tableau Desktop and confirm the string length increase is applied (verify via Desktop debug logs — look for odbc-connect-string-extras populated, not empty, in the construct-protocol-group log entry).
  3. Tableau Server: Once confirmed working on Desktop, place the same hadoophive.tdc file on each server node at:
    • Workbooks/Datasources: /var/opt/tableau/tableau_server/data/tabsvc/vizqlserver/Datasources
    • Flows: /var/opt/tableau/tableau_server/data/tabsvc/flowprocessor/Datasources/ and /var/opt/tableau/tableau_server/data/tabsvc/flowminerva/Datasources/
  4. Restart Tableau Server for the change to take effect.
Yderligere ressourcer
Troubleshooting tips:
  • If the customization isn't applied, check Desktop logs (log.txt, hyperd.log) for the :protocol-customizations and odbc-connect-string-extras attributes — both should be populated, not empty, when the TDC is correctly detected.
  • Confirm only one TDC file exists per connector class in the Datasources folder — duplicates can cause the customization to silently fail.
  • Reference: How to collect Tableau Desktop debug logs
Vidensartikelnummer

005460517

 
Indlæser
Salesforce Help | Article