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

mysql
hive

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

casel.chen
241 ●43 ●52 ●57

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

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.

edit retag flag offensive close merge delete

Comments

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

casel.chen ( 2017-11-08 02:07:32 -0500 )edit

add a comment

1 Answer

Sort by » oldest newest most voted

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

MarcoM
1 ●3 ●4 ●4

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

add a comment

Question Tools

1 follower

Stats

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

Seen: 604 times

Last updated: Nov 08 '17

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

Comments

1 Answer

Question Tools

Stats

Related questions

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