Impala using JDBC - tDBOutput

[Anonymous]

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, 

[vapukov]

Hi

did you define lengths for all columns in DBOutput schema? 

[Anonymous]

Yes. I see that it is taking the size of the data content. eg some of the
columns are empty and this is why is it setting it as Char(0).

[cdelbene]

Hello, were you able to come up with a solution to this problem? I appear to be having the same exact issue.