[jira] [Created] (KUDU-1363) Add Multiple column range predicates for the same column in a single scan

["Chris George (JIRA)" <ji...@apache.org>]

Chris George created KUDU-1363:
----------------------------------

             Summary: Add Multiple column range predicates for the same column in a single scan
                 Key: KUDU-1363
                 URL: https://issues.apache.org/jira/browse/KUDU-1363
             Project: Kudu
          Issue Type: New Feature
            Reporter: Chris George


Currently adding multiple column range predicates for the same column does essentially an AND between the two predicates which will cause no results to be returned. 

This would greatly increase performance were I can complete in one scan what would otherwise take two.

As an example using the java api:
ColumnRangePredicate columnRangePredicateColumnNameA = new ColumnRangePredicate(new ColumnSchema.ColumnSchemaBuilder("column_name", Type.STRING).build());
columnRangePredicateColumnNameA.setLowerBound("A");
columnRangePredicateColumnNameA.setUpperBound("A");

ColumnRangePredicate columnRangePredicateColumnNameB = new ColumnRangePredicate(new ColumnSchema.ColumnSchemaBuilder("column_name", Type.STRING).build());
columnRangePredicateColumnNameB.setLowerBound("B");
columnRangePredicateColumnNameB.setUpperBound("B");

which would be equivalent:
select * from some_table where column_name="A" or column_name="B"




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)