Ask Your Question
0

Data Type Conversion

asked 2018-09-11 05:24:51 -0600

AWT gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-09-11 10:37:56 -0600

todd gravatar image

Have you tried the for Field Type Converter?

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-11 05:24:51 -0600

Seen: 72 times

Last updated: Sep 11