XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.1.0
    • client, perf, tablet
    • 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"

      Attachments

        Activity

          People

            danburkert Dan Burkert
            armoredMojo Chris George
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: