Ask Your Question
1

DateTime type column convert issue when replicate data from MySQL to Hive

asked 2017-11-03 04:08:20 -0600

casel.chen gravatar image

updated 2017-11-08 04:31:33 -0600

I found when do replicate data from MySQL to Hive, those DateTime type columns in MySQL will be converted to String type in Hive through Hive Metadata processor, why? How to resolve this issue?

1. image description 2. image description

edit retag flag offensive close merge delete

Comments

The DataType of record is JSON. How to enforce it to hive datetime type?

casel.chen gravatar imagecasel.chen ( 2017-11-08 02:07:32 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2018-10-15 09:59:42 -0600

MarcoM gravatar image

HI casel,

Probaly to avoid this error, you should convert any date/datime to the type LONG and then in right string format for the destination, or leave it as LONG and see if the metastore do the conversion for you in date.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-03 04:08:20 -0600

Seen: 245 times

Last updated: Nov 08 '17