Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-29385

Make `INTERVAL` values comparable

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 3.0.0
    • None
    • SQL
    • None

    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

      Attachments

        Issue Links

          is duplicated by

          Sub-task - The sub-task of the issue SPARK-29679 Make interval type camparable and orderable

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              maxgekk Max Gekk
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: