Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
None
-
None
-
None
-
None
Description
In scenarios where the surrogate keys are entirely contiguous, the cache can offer a fast-path for [min,max], without a further lookup in the hashtable.
hive> select min(c_customer_sk), max(c_customer_sk), max(c_customer_sk) - min(c_customer_sk), count(1) from customer; 1 65000000 64999999 65000000
Attachments
Attachments
Issue Links
- is superceded by
-
HIVE-17040 Join elimination in the presence of FK relationship
- Closed