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)
