[ https://issues.apache.org/jira/browse/SPARK-32205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17153131#comment-17153131 ]
JinxinTang edited comment on SPARK-32205 at 7/8/20, 12:41 AM: -------------------------------------------------------------- [~nileshr.patil] Seems a issue, we can insert timestamp to datetime column predefined in mysql. The table could not auto create by spark currently. was (Author: jinxintang): [~nileshr.patil] Seems a issue, we can insert timestamp to datetime column predefined in mysql. The table should not auto create by spark currently. > Writing timestamp in mysql gets fails > -------------------------------------- > > Key: SPARK-32205 > URL: https://issues.apache.org/jira/browse/SPARK-32205 > Project: Spark > Issue Type: Bug > Components: Java API > Affects Versions: 2.3.4 > Reporter: Nilesh Patil > Priority: Major > > When we are writing to mysql with TIMESTAMP column it supports only range > '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07'. Mysql has DATETIME > datatype which has 1000-01-01 00:00:00' to '9999-12-31 23:59:59' range. > How to map spark timestamp datatype to mysql datetime datatype in order to > use higher supporting range ? > [https://dev.mysql.com/doc/refman/5.7/en/datetime.html] > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org