[jira] [Created] (SPARK-32132) Thriftserver interval returns "4 weeks 2 days" in 2.4 and "30 days" in 3.0

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

Juliusz Sompolski created SPARK-32132:
-----------------------------------------

             Summary: Thriftserver interval returns "4 weeks 2 days" in 2.4 and "30 days" in 3.0
                 Key: SPARK-32132
                 URL: https://issues.apache.org/jira/browse/SPARK-32132
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Juliusz Sompolski


In https://github.com/apache/spark/pull/26418, a setting spark.sql.dialect.intervalOutputStyle was implemented, to control interval output style. This PR also removed "toString" from CalendarInterval. This change got reverted in https://github.com/apache/spark/pull/27304, and the CalendarInterval.toString got implemented back in https://github.com/apache/spark/pull/26572.

But it behaves differently now: In 2.4 "4 weeks 2 days" are returned, and 3.0 returns "30 days".
Thriftserver uses HiveResults.toHiveString, which uses CalendarInterval.toString to return interval results as string.  The results are now different in 3.0



--
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