topic Re: error cast varchar2 in tImpalaOutput in Talend Studio

error cast varchar2 in tImpalaOutput

vtabel — Sat, 16 Nov 2024 01:52:56 GMT

Hello,

i have a problem, i can't cast from String to varchar2 in tImpalaOutput.

In edit schema of

tImpalaOutput

,I can't find varchar2 in

db type ,

while my cloudera table has the varchar2 db type;

I extract the data of salesforce. this is the error :

[statistics] disconnected

[INFO ] 12:02:46 mig_ss_dev.jobload_rl_sf_account_test_0_1.JobLoad_rl_sf_account_test- TalendJob: 'JobLoad_rl_sf_account' - Done.

Exception in the component tImpalaOutput_2:AnalysisException: Possible loss of precision for target table 'edl_rl_svil.rl_sf_account'.

Expression ''0010e00000uhuwpqaw'' (type: STRING) would need to be cast to VARCHAR(18) for column 'id'.

can someone help me thanks

Re: error cast varchar2 in tImpalaOutput

manodwhb — Fri, 17 Jul 2020 05:43:29 GMT

@Viky Tabellio , use sting data type ,which you will find in tImpalaOutput.

Re: error cast varchar2 in tImpalaOutput

vtabel — Fri, 17 Jul 2020 08:42:16 GMT

thanks for the reply, but they asked me to create the tables with varchar, I wanted to know if it is possible to cast with java, perhaps using the java.sql.type, perhaps writing a routines, you know if there is the possibility of to do it ?