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

        Activity

        Hide
        stakiar_impala_496e Sahil Takiar added a comment -
        Show
        stakiar_impala_496e Sahil Takiar added a comment - Gerrit Review: https://gerrit.cloudera.org/#/c/4357/
        Hide
        stakiar_impala_496e Sahil Takiar added a comment -

        Gerrit review merged

        Show
        stakiar_impala_496e Sahil Takiar added a comment - Gerrit review merged

          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:

              Development