Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

ODBC Runtime error in SSIS

avatar
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.

 

Thanks!

Matthieu

1 REPLY 1

avatar
Super Guru
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?