[
https://issues.apache.org/jira/browse/SPARK-36431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394230#comment-17394230
]
Max Gekk commented on SPARK-36431:
----------------------------------
FYI [~cloud_fan] and [~sarutak] [~angerszhuuu] [~beliefer] Please, leave a
comment here if you would like to work on this.
> Support comparison of ANSI interval with different fields
> ---------------------------------------------------------
>
> Key: SPARK-36431
> URL: https://issues.apache.org/jira/browse/SPARK-36431
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.2.0
> Reporter: Max Gekk
> Priority: Major
>
> Support comparison of
> - a day-time interval with another day-time interval which has different
> fields
> - a year-month interval with another year-month interval where fields are
> different.
> The example below shows the issue:
> {code:sql}
> spark-sql> select interval '1' day > interval '1' hour;
> Error in query: cannot resolve '(INTERVAL '1' DAY > INTERVAL '01' HOUR)' due
> to data type mismatch: differing types in '(INTERVAL '1' DAY > INTERVAL '01'
> HOUR)' (interval day and interval hour).; line 1 pos 7;
> 'Project [unresolvedalias((INTERVAL '1' DAY > INTERVAL '01' HOUR), None)]
> +- OneRowRelation
> spark-sql> select interval '2' year > interval '11' month;
> Error in query: cannot resolve '(INTERVAL '2' YEAR > INTERVAL '11' MONTH)'
> due to data type mismatch: differing types in '(INTERVAL '2' YEAR > INTERVAL
> '11' MONTH)' (interval year and interval month).; line 1 pos 7;
> 'Project [unresolvedalias((INTERVAL '2' YEAR > INTERVAL '11' MONTH), None)]
> +- OneRowRelation
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
