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 Runtime error in SSIS

ODBC Runtime error in SSIS

New Contributor

Hello all,


I'm facing an issue with my ETL process while executing a query from SSIS to Impala.

This query is a simple insert query, and fails after inserting 84% of the rows (in the below example, but can fail before or later). This is happening randomly, it works some days and then suddenly stop working, for no obvious reason.


This is the error coming from SSIS :


[Execute SQL Task] Error: Executing the query "INSERT INTO TABLE 982_1376_5007.CDPOS_COND_A SELE..." failed with the following error: "[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Runtime Error: Query c8431f7e73c4a19f:8adf209c00000000: 84% Complete (1012 out of 1200)

". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Also, the same query works perfectly if I run it on HUE.


I am using Impala 2.9.0-cdh5.12.2.

Driver is Impala ODBC Connector 2.6.0 


I was not able to find anything about this issue on the web.


Any help would be very appreciated.





Re: ODBC Runtime error in SSIS

Hi Matthieu,

Are you able to share query PROFILE and enable ODBC driver TRACE logs so that we can see the error in more detail, both from client and server side?
Don't have an account?
Coming from Hortonworks? Activate your account here