[SPARK-28307] Support Interval comparison

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dongjoon Hyun
• Created: 08/Jul/19 21:46
• Updated: 29/Mar/20 02:25
• Resolved: 29/Mar/20 02:25

Description

postgres=# SELECT INTERVAL '0:0' HOUR TO SECOND = INTERVAL '0:0' HOUR TO SECOND;
 ?column?
----------
 t
(1 row)

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

Issue Links

• duplicates: SPARK-29679 Make interval type camparable and orderable