sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sandipan.Ghosh <Sandipan.Gh...@target.com>
Subject RE: wrong string created after sqoop import for timestamp
Date Wed, 16 Apr 2014 11:44:21 GMT
This is because HDFS convert it to timestamp Hadoop, which have milisec also. If you don’t
want this cast the date column as string in mysql and import as string in hdfs.

Hope this help.
Thanks
sandipan

From: Prabhakar [mailto:o.prabhakar@gmail.com]
Sent: Wednesday, April 16, 2014 5:09 PM
To: user@sqoop.apache.org
Subject: wrong string created after sqoop import for timestamp

Hi,

 I am trying to import mysql table to HDFS,
here one of the column in mysql is timestamp
after importing this table i am seeing the extra value for column.

in Mysql time is : 1903-05-28 16:13:52

after import in HDFS it is:  1903-05-28 16:13:52.0

at end ".0" adding extra.
pls help me on this

Thanks,
Prabhakar
Mime
View raw message