[ https://issues.apache.org/jira/browse/SPARK-28307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971325#comment-16971325 ]
Kent Yao commented on SPARK-28307: ---------------------------------- Resolved by the PR: [https://github.com/apache/spark/pull/26337] > Support Interval comparison > --------------------------- > > Key: SPARK-28307 > URL: https://issues.apache.org/jira/browse/SPARK-28307 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Dongjoon Hyun > Priority: Major > > {code} > postgres=# SELECT INTERVAL '0:0' HOUR TO SECOND = INTERVAL '0:0' HOUR TO > SECOND; > ?column? > ---------- > t > (1 row) > {code} > {code} > spark-sql> SELECT INTERVAL '0:0' HOUR TO SECOND = INTERVAL '0:0' HOUR TO > SECOND; > Error in query: cannot resolve '(interval 0 microseconds = interval 0 > microseconds)' due to data type mismatch: EqualTo does not support ordering > on type calendarinterval; line 1 pos 7; > 'Project [unresolvedalias((interval 0 microseconds = interval 0 > microseconds), 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