Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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?
Thanks,
Hi
did you define lengths for all columns in DBOutput schema?