[jira] [Commented] (HBASE-10067) Filters are not applied if columns are added to the scanner
[ https://issues.apache.org/jira/browse/HBASE-10067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14044578#comment-14044578 ] Vikram Singh Chandel commented on HBASE-10067: -- Any solution available for this issue? Filters are not applied if columns are added to the scanner --- Key: HBASE-10067 URL: https://issues.apache.org/jira/browse/HBASE-10067 Project: HBase Issue Type: Bug Components: Coprocessors, Filters, Scanners Affects Versions: 0.94.6 Environment: Linux 2.6.32-279.11.1.el6.x86_64 Reporter: Vikram Singh Chandel While applying columns to scanner the filtering does not happen and entire scan of the table is done Expected behaviour: Filters should be applied when particular columns are added to scanner Actual behaviour: Filter are not applied entire result set is returned Code Snippet: Scan scan = new Scan(); scan.addColumn(family, qualifier);//Entire scan happens Filters are ignored SingleColumnValueFilter filterOne =new SingleColumnValueFilter(colFal,col, CompareOp.EQUAL, val); filterOne.setFilterIfMissing(true); FilterList filter = new FilterList(Operator.MUST_PASS_ALL, Arrays.asList((Filter) filterOne)); scan.setFilter(filter); // Not working If addFamily is used it works scan.addFamily(family); scan.setFilter(filter); //Works -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HBASE-10067) Filters are not applied if columns are added to the scanner
[ https://issues.apache.org/jira/browse/HBASE-10067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14044649#comment-14044649 ] Anoop Sam John commented on HBASE-10067: You have to add the condition column also on to the Scan and if that column value not needed use SingleColumnValueExcludeFilter instead of SCVF. Filters are not applied if columns are added to the scanner --- Key: HBASE-10067 URL: https://issues.apache.org/jira/browse/HBASE-10067 Project: HBase Issue Type: Bug Components: Coprocessors, Filters, Scanners Affects Versions: 0.94.6 Environment: Linux 2.6.32-279.11.1.el6.x86_64 Reporter: Vikram Singh Chandel While applying columns to scanner the filtering does not happen and entire scan of the table is done Expected behaviour: Filters should be applied when particular columns are added to scanner Actual behaviour: Filter are not applied entire result set is returned Code Snippet: Scan scan = new Scan(); scan.addColumn(family, qualifier);//Entire scan happens Filters are ignored SingleColumnValueFilter filterOne =new SingleColumnValueFilter(colFal,col, CompareOp.EQUAL, val); filterOne.setFilterIfMissing(true); FilterList filter = new FilterList(Operator.MUST_PASS_ALL, Arrays.asList((Filter) filterOne)); scan.setFilter(filter); // Not working If addFamily is used it works scan.addFamily(family); scan.setFilter(filter); //Works -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HBASE-10067) Filters are not applied if columns are added to the scanner
[ https://issues.apache.org/jira/browse/HBASE-10067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13836502#comment-13836502 ] Anoop Sam John commented on HBASE-10067: Creating Scan in CP? Can you tell us more regarding ur usage context pls? Filters are not applied if columns are added to the scanner --- Key: HBASE-10067 URL: https://issues.apache.org/jira/browse/HBASE-10067 Project: HBase Issue Type: Bug Components: Coprocessors, Filters, Scanners Affects Versions: 0.94.6 Environment: Linux 2.6.32-279.11.1.el6.x86_64 Reporter: Vikram Singh Chandel While applying columns to scanner the filtering does not happen and entire scan of the table is done Expected behaviour: Filters should be applied when particular columns are added to scanner Actual behaviour: Filter are not applied entire result set is returned Code Snippet: Scan scan = new Scan(); scan.addColumn(family, qualifier);//Entire scan happens Filters are ignored SingleColumnValueFilter filterOne =new SingleColumnValueFilter(colFal,col, CompareOp.EQUAL, val); filterOne.setFilterIfMissing(true); FilterList filter = new FilterList(Operator.MUST_PASS_ALL, Arrays.asList((Filter) filterOne)); scan.setFilter(filter); // Not working If addFamily is used it works scan.addFamily(family); scan.setFilter(filter); //Works -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HBASE-10067) Filters are not applied if columns are added to the scanner
[ https://issues.apache.org/jira/browse/HBASE-10067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13836532#comment-13836532 ] Vikram Singh Chandel commented on HBASE-10067: -- our normal scan are taking around 62 seconds for around 8.1 million records. And anything beyond 5 sec is not acceptable. Filters are not applied if columns are added to the scanner --- Key: HBASE-10067 URL: https://issues.apache.org/jira/browse/HBASE-10067 Project: HBase Issue Type: Bug Components: Coprocessors, Filters, Scanners Affects Versions: 0.94.6 Environment: Linux 2.6.32-279.11.1.el6.x86_64 Reporter: Vikram Singh Chandel While applying columns to scanner the filtering does not happen and entire scan of the table is done Expected behaviour: Filters should be applied when particular columns are added to scanner Actual behaviour: Filter are not applied entire result set is returned Code Snippet: Scan scan = new Scan(); scan.addColumn(family, qualifier);//Entire scan happens Filters are ignored SingleColumnValueFilter filterOne =new SingleColumnValueFilter(colFal,col, CompareOp.EQUAL, val); filterOne.setFilterIfMissing(true); FilterList filter = new FilterList(Operator.MUST_PASS_ALL, Arrays.asList((Filter) filterOne)); scan.setFilter(filter); // Not working If addFamily is used it works scan.addFamily(family); scan.setFilter(filter); //Works -- This message was sent by Atlassian JIRA (v6.1#6144)
[jira] [Commented] (HBASE-10067) Filters are not applied if columns are added to the scanner
[ https://issues.apache.org/jira/browse/HBASE-10067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13837227#comment-13837227 ] Vasu Mariyala commented on HBASE-10067: --- Only when the filter columns are part of the scan column list, the filter is applied. See HBASE-4364 for more information. Filters are not applied if columns are added to the scanner --- Key: HBASE-10067 URL: https://issues.apache.org/jira/browse/HBASE-10067 Project: HBase Issue Type: Bug Components: Coprocessors, Filters, Scanners Affects Versions: 0.94.6 Environment: Linux 2.6.32-279.11.1.el6.x86_64 Reporter: Vikram Singh Chandel While applying columns to scanner the filtering does not happen and entire scan of the table is done Expected behaviour: Filters should be applied when particular columns are added to scanner Actual behaviour: Filter are not applied entire result set is returned Code Snippet: Scan scan = new Scan(); scan.addColumn(family, qualifier);//Entire scan happens Filters are ignored SingleColumnValueFilter filterOne =new SingleColumnValueFilter(colFal,col, CompareOp.EQUAL, val); filterOne.setFilterIfMissing(true); FilterList filter = new FilterList(Operator.MUST_PASS_ALL, Arrays.asList((Filter) filterOne)); scan.setFilter(filter); // Not working If addFamily is used it works scan.addFamily(family); scan.setFilter(filter); //Works -- This message was sent by Atlassian JIRA (v6.1#6144)