[SPARK-30551] Disable comparison for interval type

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 17/Jan/20 11:09
• Updated: 20/Jan/20 00:29
• Resolved: 19/Jan/20 07:33

Description

As we are not going to follow ANSI, it is weird to compare the year-month part to the day-time part for our current implementation of interval. Additionally, the current ordering logic comes from PostgreSQL where the implementation of the interval is messy. And we are not aiming PostgreSQL compliance at all.

Issue Links

• fixes: SPARK-29679 Make interval type camparable and orderable
• links to: GitHub Pull Request #27262