[SPARK-29385] Make `INTERVAL` values comparable

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Max Gekk
• Created: 08/Oct/19 10:07
• Updated: 02/Dec/20 23:09
• Resolved: 02/Dec/20 23:09

Description

PostgreSQL allows to compare interval by `=`, `<>`, `<`, `<=`, `>`, `>=`. For example:

maxim=# select interval '1 month' > interval '29 days';
 ?column? 
----------
 t

but the same fails in Spark:

spark-sql> select interval 1 month > interval 29 days;
Error in query: cannot resolve '(interval 1 months > interval 4 weeks 1 days)' due to data type mismatch: GreaterThan does not support ordering on type interval; line 1 pos 7;
'Project [unresolvedalias((interval 1 months > interval 4 weeks 1 days), None)]
+- OneRowRelation

Issue Links

• is duplicated by: SPARK-29679 Make interval type camparable and orderable