[ 
https://issues.apache.org/jira/browse/KUDU-1363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15240277#comment-15240277
 ] 

Sameer Abhyankar commented on KUDU-1363:
----------------------------------------

An IN list predicate would require extending the KuduPredicate.ComparionOp and 
KuduPredicate class to allow an "IN" list comparison and also the Scanner APIs 
to be able to process it. Would that be the right approach? If so, I dont mind 
taking a crack at this.

> 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)

Reply via email to