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

Aditya Kishore commented on DRILL-1403:
---------------------------------------

I tried the following query and it seems to be pushing the filter correctly 
(with the patch of course).

{code}
select cast(t.f.c as varchar(20)) from t where row_key > 'row1' and row_key < 
'row5';
select cast(f['c'] as varchar(20)) from t where row_key > 'row1' and row_key < 
'row5';
{code}


> HBase predicate pushdown filters are not getting applied
> --------------------------------------------------------
>
>                 Key: DRILL-1403
>                 URL: https://issues.apache.org/jira/browse/DRILL-1403
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>            Reporter: B Anil Kumar
>            Assignee: DrillCommitter
>              Labels: patch
>         Attachments: 0001-DRILL-1403.patch, 
> DRILL-1403-HBase-predicate-pushdown-filters-are-not-.patch
>
>
> It seems, due to latest changes HBase predicate pushdown is not getting 
> applied.
> In below snippet, "le.accept(this, null)" returning null.
> {noformat}
>   public HBaseScanSpec parseTree() {
>     HBaseScanSpec parsedSpec = le.accept(this, null);
>     if (parsedSpec != null) {
>       parsedSpec = mergeScanSpecs("booleanAnd", 
> this.groupScan.getHBaseScanSpec(), parsedSpec);
>       /*
>        * If RowFilter is THE filter attached to the scan specification,
>        * remove it since its effect is also achieved through startRow and 
> stopRow.
>        */
>       if (parsedSpec.filter instanceof RowFilter) {
>         parsedSpec.filter = null;
>       }
>     }
>     return parsedSpec;
>   }
> {noformat}



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

Reply via email to