[jira] [Created] (SPARK-31859) Thriftserver with spark.sql.datetime.java8API.enabled=true

["Juliusz Sompolski (Jira)" <ji...@apache.org>]

Juliusz Sompolski created SPARK-31859:
-----------------------------------------

             Summary: Thriftserver with spark.sql.datetime.java8API.enabled=true
                 Key: SPARK-31859
                 URL: https://issues.apache.org/jira/browse/SPARK-31859
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Juliusz Sompolski


{code}
  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))
    }
  }
{code}
fails with 
{code}
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
{code}

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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org