[ 
https://issues.apache.org/jira/browse/IMPALA-7919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16706095#comment-16706095
 ] 

Greg Rahn commented on IMPALA-7919:
-----------------------------------

Had a copy mistake in the description -- the 2nd example is the partitioned 
one.  We see that with the predicate we visit exactly one partition as expected 
(partitions=1/2), but we do not include the predicate that restricted it to 
that one partition.

I'm thinking it should be this:
{noformat}
00:SCAN HDFS [default.t1]
   partitions=1/2 files=1 size=2B
   predicates: default.t1.part_key = 42{noformat}

> 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
>            Priority: Major
>
> 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 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org

Reply via email to