[jira] [Created] (KUDU-2875) Convert scans with IN-list predicates on primary key prefix to multiple scans with equality predicates

[Todd Lipcon (JIRA)]

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)