Details
-
New Feature
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
Impala 1.2.1
-
None
-
None
Description
Consider the following simplified example based on store_sales and date_dim from tpc-ds:
select count(*) from store_sales join date_dim on (store_sales.ss_sold_date_sk = date_dim.d_date_sk) where date_dim.d_year in (1998, 1999, 2000) and (date_dim.d_dom between 1 and 3 or date_dim.d_dom between 25 and 28)
If store_sales.ss_sold_date_sk is the partition key, then it would be nice to eliminate unneeded partitions at run time. Currently a literal predicate on the partition key is required to get partition pruning. In this case that list of values is 249 large and not easily expressed in simple range base predicates.