Impala using JDBC - tDBOutput

Highlighted
Four Stars

Impala using JDBC - tDBOutput

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, 

Highlighted
Forteen Stars

Re: Impala using JDBC - tDBOutput

Hi

 

did you define lengths for all columns in DBOutput schema? 

-----------
Highlighted
Four Stars

Re: Impala using JDBC - tDBOutput

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


Highlighted
One Star

Re: Impala using JDBC - tDBOutput

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read