You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Greg Rahn (JIRA)" <ji...@apache.org> on 2018/12/02 02:46:00 UTC

[jira] [Created] (IMPALA-7919) Add predicates line in plan output for partition key predicates

Greg Rahn created IMPALA-7919:
---------------------------------

             Summary: Add predicates line in plan output for partition key predicates
                 Key: IMPALA-7919
                 URL: https://issues.apache.org/jira/browse/IMPALA-7919
             Project: IMPALA
          Issue Type: Improvement
          Components: Frontend
            Reporter: Greg Rahn


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:
{noformat}
select * from t1 where part_key=42;
{noformat}

From a non-partitioned table:
{noformat}
00:SCAN HDFS [default.t1]
   partitions=1/1 files=2 size=10B
   predicates: default.t1.part_key = 42
{noformat}

From a non-partitioned table:
{noformat}
00:SCAN HDFS [default.t1]
   partitions=1/2 files=1 size=2B
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)