Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 3.1.0
    • None
    • SQL
    • None

    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
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              dongjoon Dongjoon Hyun
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: