Data Type Conversion
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?