[ 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