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

Add predicates line in plan output for partition key predicates

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 3.1.0
    • Fix Version/s: Impala 3.2.0
    • Component/s: Frontend
    • Labels:
    • Epic Color:
      ghx-label-2

      Description

      When there is a predicate on a partitioned table's partition key column the SCAN node does not print the "predicates" line as it would if the table was not partitioned. IMO predicates should always be included in the nodes where they are applied irregardless of partitioning or not to make it clear.

      Query:

      select * from t1 where part_key=42;
      

      From a non-partitioned table:

      00:SCAN HDFS [default.t1]
         partitions=1/1 files=2 size=10B
         predicates: default.t1.part_key = 42
      

      From a partitioned table:

      00:SCAN HDFS [default.t1]
         partitions=1/2 files=1 size=2B
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Paul.Rogers Paul Rogers
                Reporter:
                grahn Greg Rahn
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: