I found KB327367 which says:
"PowerCenter does not support a native/ODBC connection, especially for the Impala database.
Any third party type 2 ODBC driver can be used as per the ODBC support statement."
Here is the link to the KB:
And here you can find the ODBC Support Statement:
ODBC Connection is working fine on reader side, Pre SQL and Post SQL.
Even I am able to write the data in a flat file by using Hive table as a source.
However I am getting this error when writing the data to Hive table. Any thoughts.
From my understanding ODBC is only supposed to be used to read from Hive . To write into hive PWX is supposed to be used .
I may be wrong but this is what I remember from last time i discussed this with someone .
Hope this helps.