[jira] [Created] (SPARK-32752) Alias breaks for interval typed literals

["Kent Yao (Jira)" <ji...@apache.org>]

Kent Yao created SPARK-32752:
--------------------------------

             Summary: Alias breaks for interval typed literals
                 Key: SPARK-32752
                 URL: https://issues.apache.org/jira/browse/SPARK-32752
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.0.0, 3.1.0
            Reporter: Kent Yao


Cases we found：

{code:java}
+-- !query
+select interval '1 day' as day
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.parser.ParseException
+
+no viable alternative at input 'as'(line 1, pos 24)
+
+== SQL ==
+select interval '1 day' as day
+------------------------^^^
+
+
+-- !query
+select interval '1 day' day
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.parser.ParseException
+
+Error parsing ' 1 day day' to interval, unrecognized number 'day'(line 1, pos 16)
+
+== SQL ==
+select interval '1 day' day
+----------------^^^
+
+
+-- !query
+select interval '1-2' year as y
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.parser.ParseException
+
+Error parsing ' 1-2 year' to interval, invalid value '1-2'(line 1, pos 16)
+
+== SQL ==
+select interval '1-2' year as y
+----------------^^^
{code}




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