error cast varchar2 in tImpalaOutput

vtabel — Sat, 16 Nov 2024 01:53:40 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'

Re: error cast varchar2 in tImpalaOutput

Anonymous — Fri, 17 Jul 2020 02:41:00 GMT

@Viky Tabellio I check the mapping_Impala.xml file and found that the DB type is string mapped to Talend type string, no varchar type declared in the mapping file.

Do you select Type 'String' and DB type 'String' for column 'id' and has this error?

topic error cast varchar2 in tImpalaOutput in Talend Studio

error cast varchar2 in tImpalaOutput

Re: error cast varchar2 in tImpalaOutput