Lianhui Wang created HIVE-3329:
----------------------------------
Summary: Support bucket filtering when where expression or join
key expression has the bucket key
Key: HIVE-3329
URL: https://issues.apache.org/jira/browse/HIVE-3329
Project: Hive
Issue Type: New Feature
Components: Query Processor
Reporter: Lianhui Wang
in HIVE-3306, it introduces a context.
example:
select /* + MAPJOIN(a) */ count FROM bucket_small a JOIN bucket_big b ON a.key
+ a.key = b.key
also there are some other contexts.i know the following example:
1. join expression is ON (a.key = b.key and a.key=10);
2. select * from bucket_small where a.key=10;
3.
the table is a partition table,that maybe complex.
example:
CREATE TABLE srcbucket_part (key string, value string) partitioned by (ds
string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS RCFile;
select * from srcbucket_part where key='455' and ds='2008-04-08';
maybe complex sql is:
select * from srcbucket_part where (key='455' and ds='2008-04-08') or
ds='2008-04-09';
these contexts should not scan full table's files and only scan the some bucket
files in the table path.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
