[SPARK-31859] Thriftserver with spark.sql.datetime.java8API.enabled=true

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Juliusz Sompolski
• Reporter: Juliusz Sompolski
• Created: 28/May/20 18:48
• Updated: 27/Jun/20 17:13
• Resolved: 30/May/20 06:20

Description

  test("spark.sql.datetime.java8API.enabled=true") {
    withJdbcStatement() { st =>
      st.execute("set spark.sql.datetime.java8API.enabled=true")
      val rs = st.executeQuery("select timestamp '2020-05-28 00:00:00'")
      rs.next()
      // scalastyle:off
      println(rs.getObject(1))
    }
  }

fails with

HiveThriftBinaryServerSuite:
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.hive.jdbc.HiveBaseResultSet.evaluate(HiveBaseResultSet.java:444)
        at org.apache.hive.jdbc.HiveBaseResultSet.getColumnValue(HiveBaseResultSet.java:424)
        at org.apache.hive.jdbc.HiveBaseResultSet.getObject(HiveBaseResultSet.java:464

It seems it might be needed in HiveResult.toHiveString?
cc maxgekk

Issue Links

• causes: SPARK-32057 SparkExecuteStatementOperation does not set CANCELED state correctly
• links to: [Github] Pull Request #28671 (juliuszsompolski)
• links to: [Github] Pull Request #28735 (juliuszsompolski)
• links to: [Github] Pull Request #28735 (juliuszsompolski)