[SPARK-29679] Make interval type camparable and orderable

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Do
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 31/Oct/19 05:34
• Updated: 02/Dec/20 23:10
• Resolved: 19/Jan/20 07:16

Description

postgres=# select INTERVAL '9 years 1 months -1 weeks -4 days -10 hours -46 minutes' > interval '1 s';
 ?column?
----------
 t
(1 row)

Issue Links

• duplicates: SPARK-29385 Make `INTERVAL` values comparable
• is duplicated by: SPARK-28307 Support Interval comparison
• is fixed by: SPARK-30551 Disable comparison for interval type
• links to: GitHub Pull Request #26337