topic Re: Impala using JDBC - tDBOutput in Data Quality

Impala using JDBC - tDBOutput

Anonymous — Sat, 16 Nov 2024 06:21:20 GMT

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,

Re: Impala using JDBC - tDBOutput

vapukov — Tue, 12 Mar 2019 23:21:52 GMT

did you define lengths for all columns in DBOutput schema?

Re: Impala using JDBC - tDBOutput

Anonymous — Wed, 13 Mar 2019 08:53:38 GMT

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).

Re: Impala using JDBC - tDBOutput

cdelbene — Sun, 15 Mar 2020 19:35:25 GMT

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