Todd Lipcon created KUDU-2875:
---------------------------------
Summary: Convert scans with IN-list predicates on primary key
prefix to multiple scans with equality predicates
Key: KUDU-2875
URL: https://issues.apache.org/jira/browse/KUDU-2875
Project: Kudu
Issue Type: Sub-task
Components: perf, tserver
Reporter: Todd Lipcon
In the case that an IN predicate is applied to a prefix of the primary key (or
to column N of a composite key with equality predicates present on all columns
<N), the tserver can convert the IN-list into multiple ranges. For example,
assume a PK (entity, timestamp) and the query 'select * where entity in (1,3)
and timestamp > 10'. In this case, we can internally convert to two scans
'entity = 1 and timestamp > 10' and 'entity = 3 and timestamp > 10'. These can
then be evaluated efficiently using the index.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
