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.