Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ODBC error in SSIS hortonworks driver

ODBC error in SSIS hortonworks driver

New Contributor


I am looking for help as I am getting the following error:


[Source - souce_name [40]] Error: Open Database Connectivity (ODBC) error occurred. state: '07006'. Native Error Code: 10470. [Hortonworks][ODBC] (10470) Data conversion not supported.


The problem is with while selecting a field that in hive is type TIMESTAMP. If I do not retrieve this value, everything works perfectly. 

I have tried casting and everything.

Other queries work perfectly.


Connection string:
Driver={Hortonworks Hive ODBC Driver};authmech=3;hiveservertype=2;host=hostname;httppath=gateway/default/hive;port=443;rowsfetchedperblock=10000;schema=schema;ssl=1;thrifttransport=2;UseNativeQuery=1

Don't have an account?
Coming from Hortonworks? Activate your account here