Data Type Conversion

edit

Hi there,

For each table we read in from Teradata, we would like time data type to be converted prefixed with a fixed date in the front so that the value would be a timestamp in Hive. And for all the CHAR(n) from Teradata, we would convert to VARCHAR(n+5). Which processor should I be using to achieve this?

And if the tables are many, can we do once (like a template) and apply to all the tables? Or do we have to do it for each table?