[
https://issues.apache.org/jira/browse/IMPALA-7919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Greg Rahn updated IMPALA-7919:
------------------------------
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:
{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}
was:
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}
> 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
