Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
Description
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"