[IMPALA-7919] Add predicates line in plan output for partition key predicates

• 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: planner ramp-up
• Epic Color: ghx-label-2
• Assignee: Paul Rogers
• Reporter: Greg Rahn
• Created: 02/Dec/18 02:45
• Updated: 31/Jan/19 01:22
• Resolved: 30/Jan/19 23:07

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

Issue Links

• is part of: IMPALA-8021 Add estimated cardinality to EXPLAIN output