I have been trying to use the JDBC with the Impala Driver for connection and then tDBOutput. I am connecting to a Cloudera Impala DB.
The connection was successful but when doing the tDBOutput I am getting:
[WARN ]: org.talend.components.jdbc.runtime.writer.JDBCOutputWriter - [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Char size must be > 0: 0
In the query I could see that it is writing the insert statement VALUE section with castings as below.
, CAST('' AS CHAR(0)), CAST('' AS CHAR(0)),
Is it possible to skip the casting section?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out about Talend Open Studio for Data Quality
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality