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:[email protected]] Sent: Wednesday, April 16, 2014 5:09 PM To: [email protected] 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
