error cast varchar2 in tImpalaOutput

[vtabel]

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'

[Anonymous]

@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?