Hi Team,

I am building a job in Spoon to load data from one table to another in Hadoop. My distribution is Cloudera CDH 5, I am using Impala database.

Load is failing with a data type error

Expression ''my data value'' (type: STRING) would need to be cast to VARCHAR(30) for column 'id_type'

I dont see any options to mention column data type or CAST operation in the "Table Output" step.

Any pointers?

thanks,
Sujiith.