[jira] Updated: (MAPREDUCE-1235) java.io.IOException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
[ https://issues.apache.org/jira/browse/MAPREDUCE-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aaron Kimball updated MAPREDUCE-1235: - Status: Patch Available (was: Open) java.io.IOException: Cannot convert value '-00-00 00:00:00' from column 6 to TIMESTAMP. Key: MAPREDUCE-1235 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1235 Project: Hadoop Map/Reduce Issue Type: Bug Components: contrib/sqoop Affects Versions: 0.20.1 Environment: hadoop 0.20.1 sqoop ubuntu karmic mysql 4 Reporter: valentina kroshilina Assignee: Aaron Kimball Priority: Minor Attachments: MAPREDUCE-1235.patch Original Estimate: 4h Remaining Estimate: 4h *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 '-00-00 00:00:00' from column 6 to TIMESTAMP. *Original question*: http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_linkutm_medium=emailutm_source=reply_notification -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (MAPREDUCE-1235) java.io.IOException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
[
https://issues.apache.org/jira/browse/MAPREDUCE-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aaron Kimball updated MAPREDUCE-1235:
-
Attachment: MAPREDUCE-1235.patch
Attaching patch to fix this issue. MySQL supports TIMESTAMP values of
'-00-00 00:00:00' which is out-of-range for java.sql.Timestamp. MySQL
allows various behaviors for handling this; the default used to be to convert
this value to null; since MySQL 5 it now throws IOException when such a
timestamp is retrieved.
Sqoop now sets the default behavior to be convert these values to 'null', since
this is a reasonable data conversion given the imprecision available. Users can
override this default by passing the {{zeroDateTimeBehavior=exception}}
parameter in the connect string.
java.io.IOException: Cannot convert value '-00-00 00:00:00' from column 6
to TIMESTAMP.
Key: MAPREDUCE-1235
URL: https://issues.apache.org/jira/browse/MAPREDUCE-1235
Project: Hadoop Map/Reduce
Issue Type: Bug
Components: contrib/sqoop
Affects Versions: 0.20.1
Environment: hadoop 0.20.1
sqoop
ubuntu karmic
mysql 4
Reporter: valentina kroshilina
Assignee: Aaron Kimball
Priority: Minor
Attachments: MAPREDUCE-1235.patch
Original Estimate: 4h
Remaining Estimate: 4h
*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 '-00-00
00:00:00' from column 6 to TIMESTAMP.
*Original question*:
http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_linkutm_medium=emailutm_source=reply_notification
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (MAPREDUCE-1235) java.io.IOException: Cannot convert value '0000-00-00 00:00:00' from column 6 to TIMESTAMP.
[ https://issues.apache.org/jira/browse/MAPREDUCE-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] valentina kroshilina updated MAPREDUCE-1235: 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 '-00-00 00:00:00' from column 6 to TIMESTAMP. *Original question*: http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_linkutm_medium=emailutm_source=reply_notification was: *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 '-00-00 00:00:00' from column 6 to TIMESTAMP. *Original question*: http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_linkutm_medium=emailutm_source=reply_notification#reply_1604384 java.io.IOException: Cannot convert value '-00-00 00:00:00' from column 6 to TIMESTAMP. Key: MAPREDUCE-1235 URL: https://issues.apache.org/jira/browse/MAPREDUCE-1235 Project: Hadoop Map/Reduce Issue Type: Bug Components: contrib/sqoop Affects Versions: 0.20.1 Environment: hadoop 0.20.1 sqoop ubuntu karmic mysql 4 Reporter: valentina kroshilina Priority: Minor Original Estimate: 4h Remaining Estimate: 4h *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 '-00-00 00:00:00' from column 6 to TIMESTAMP. *Original question*: http://getsatisfaction.com/cloudera/topics/cant_import_table?utm_content=reply_linkutm_medium=emailutm_source=reply_notification -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
