[SPARK-25453] OracleIntegrationSuite IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

• Type: Test
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 2.4.0
• Component/s: Tests
• Assignee: Chenxiao Mao
• Reporter: Yuming Wang
• Created: 18/Sep/18 13:16
• Updated: 01/Oct/18 05:50
• Resolved: 01/Oct/18 05:50

Description

- SPARK-22814 support date/timestamp types in partitionColumn *** FAILED ***

  java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

  at java.sql.Timestamp.valueOf(Timestamp.java:204)

  at org.apache.spark.sql.execution.datasources.jdbc.JDBCRelation$.toInternalBoundValue(JDBCRelation.scala:183)

  at org.apache.spark.sql.execution.datasources.jdbc.JDBCRelation$.columnPartition(JDBCRelation.scala:88)

  at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:36)

  at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:318)

  at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:223)

  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:211)

  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:167)

  at org.apache.spark.sql.jdbc.OracleIntegrationSuite$$anonfun$18.apply(OracleIntegrationSuite.scala:445)

  at org.apache.spark.sql.jdbc.OracleIntegrationSuite$$anonfun$18.apply(OracleIntegrationSuite.scala:427)

  ...

Issue Links

• is related to: SPARK-22814 JDBC support date/timestamp type as partitionColumn
• links to: [Github] Pull Request #22461 (seancxmao)