[MAPREDUCE-1235] java.io.IOException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.20.1

Environment

hadoop 0.20.1
sqoop
ubuntu karmic
mysql 4

• Hadoop Flags: Reviewed
• Assignee: Aaron Kimball
• Reporter: valentina kroshilina
• Created: 23/Nov/09 15:41
• Updated: 02/Jul/10 06:31
• Resolved: 23/Dec/09 05:14

Description

Description: java.io.IOException is thrown when trying to import a table to HDFS using Sqoop. Table has "0" value in a field of type datetime.
Full Exception: java.io.IOException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
Original question: http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_link&utm_medium=email&utm_source=reply_notification