Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4112

RQG-on-HIve: Remove IS [NOT] DISTINCT FROM clauses from Hive generated queries

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2.4
    • Fix Version/s: Impala 2.8.0
    • Component/s: Infrastructure
    • Labels:
      None

      Description

      The clause is used as a null-safe equality operator and is supported in both Impala and Postgres. In Hive it is implemented as "<=>" (which is what MySQL does).

      https://wiki.postgresql.org/wiki/Is_distinct_from
      http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#operator_equal-to
      https://issues.cloudera.org/browse/IMPALA-2147
      https://issues.apache.org/jira/browse/HIVE-2810

      The RQG should be modified to use <=> instead of IS NOT DISTINCT FROM for Hive queries

        Attachments

          Activity

            People

            • Assignee:
              stakiar_impala_496e Sahil Takiar
              Reporter:
              stakiar_impala_496e Sahil Takiar
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: