Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vtabel
Contributor
Contributor

error cast varchar2 in tImpalaOutput

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'

Labels (2)
1 Reply
Anonymous
Not applicable

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