Examples of org.apache.hadoop.hbase.filter.SingleColumnValueFilter

org.apache.hadoop.hbase.filter.SingleColumnValueFilter
This filter is used to filter cells based on value. It takes a {@link CompareFilter.CompareOp}operator (equal, greater, not equal, etc), and either a byte [] value or a ByteArrayComparable.
If we have a byte [] value then we just do a lexicographic compare. For example, if passed value is 'b' and cell has 'a' and the compare operator is LESS, then we will filter out this cell (return true). If this is not sufficient (eg you want to deserialize a long and then compare it to a fixed long value), then you can pass in your own comparator instead.
You must also specify a family and qualifier. Only the value of this column will be tested. When using this filter on a {@link Scan} with specifiedinputs, the column to be tested should also be added as input (otherwise the filter will regard the column as missing).
To prevent the entire row from being emitted if the column is not found on a row, use {@link #setFilterIfMissing}. Otherwise, if the column is found, the entire row will be emitted only if the value passes. If the value fails, the row will be filtered out.
In order to test values of previous versions (timestamps), set {@link #setLatestVersionOnly} to false. The default is true, meaning thatonly the latest version's value is tested and all previous versions are ignored.
To filter based on the value of all scanned columns, use {@link ValueFilter}.

    FlushThread flushThread = new FlushThread();
    flushThread.start();


    Scan scan = new Scan();
    scan.addFamily(family);
    scan.setFilter(new SingleColumnValueFilter(family, qual1,
      CompareFilter.CompareOp.EQUAL, new BinaryComparator(Bytes.toBytes(5L))));


    int expectedCount = 0;
    List<KeyValue> res = new ArrayList<KeyValue>();

View Full Code Here

    region.put(put);


    Scan idxScan = new Scan();
    idxScan.addFamily(family);
    idxScan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ALL,
      Arrays.<Filter>asList(new SingleColumnValueFilter(family, qual1,
        CompareFilter.CompareOp.GREATER_OR_EQUAL,
        new BinaryComparator(Bytes.toBytes(0L))),
        new SingleColumnValueFilter(family, qual1,
          CompareFilter.CompareOp.LESS_OR_EQUAL,
          new BinaryComparator(Bytes.toBytes(3L)))
      )));
    InternalScanner scanner = region.getScanner(idxScan);
    List<KeyValue> res = new ArrayList<KeyValue>();

View Full Code Here

    EqualsExpression equalsExpression = new EqualsExpression(column, value);
    singleIndexExpression.addEqualsExpression(equalsExpression);


    Scan scan = new Scan();
    scan.setAttribute(Constants.INDEX_EXPRESSION, IndexUtils.toBytes(singleIndexExpression));
    Filter filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER1, CompareOp.EQUAL, value);
    scan.setFilter(filter);
    ScanFilterEvaluator evaluator = new ScanFilterEvaluator();
    List<IndexSpecification> indices = new ArrayList<IndexSpecification>();
    IndexSpecification index = new IndexSpecification(indexName);
    HColumnDescriptor colDesc = new HColumnDescriptor(FAMILY1);

View Full Code Here

    singleIndexExpression.setRangeExpression(re);


    Scan scan = new Scan();
    scan.setAttribute(Constants.INDEX_EXPRESSION, IndexUtils.toBytes(singleIndexExpression));
    FilterList fl = new FilterList(Operator.MUST_PASS_ALL);
    Filter filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER1, CompareOp.EQUAL, value1);
    fl.addFilter(filter);
    filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER2, CompareOp.EQUAL, value2);
    fl.addFilter(filter);
    filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER3, CompareOp.GREATER_OR_EQUAL, value3_1);
    fl.addFilter(filter);
    filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER3, CompareOp.LESS, value3_2);
    fl.addFilter(filter);
    scan.setFilter(fl);


    ScanFilterEvaluator evaluator = new ScanFilterEvaluator();
    List<IndexSpecification> indices = new ArrayList<IndexSpecification>();

View Full Code Here


    Scan scan = new Scan();
    scan.setAttribute(Constants.INDEX_EXPRESSION, IndexUtils.toBytes(multiIndexExpression));
    FilterList outerFL = new FilterList(Operator.MUST_PASS_ALL);
    FilterList fl = new FilterList(Operator.MUST_PASS_ALL);
    Filter filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER2, CompareOp.EQUAL, value2);
    fl.addFilter(filter);
    filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER3, CompareOp.GREATER_OR_EQUAL, value3_1);
    fl.addFilter(filter);
    filter = new SingleColumnValueFilter(FAMILY1, QUALIFIER3, CompareOp.LESS, value3_2);
    fl.addFilter(filter);
    outerFL.addFilter(fl);
    FilterList innerFL = new FilterList(Operator.MUST_PASS_ONE);
    innerFL.addFilter(new SingleColumnValueFilter(FAMILY1, QUALIFIER1, CompareOp.EQUAL, value1));
    innerFL.addFilter(new SingleColumnValueFilter(FAMILY2, QUALIFIER1, CompareOp.EQUAL, value4));
    outerFL.addFilter(innerFL);
    scan.setFilter(outerFL);


    ScanFilterEvaluator evaluator = new ScanFilterEvaluator();
    List<IndexSpecification> indices = new ArrayList<IndexSpecification>();

View Full Code Here

  public void testNoIndexExpression() throws Exception {
    IndexExpression exp = new NoIndexExpression();
    Scan scan = new Scan();
    scan.setAttribute(Constants.INDEX_EXPRESSION, IndexUtils.toBytes(exp));
    byte[] value1 = Bytes.toBytes("asdf");
    scan.setFilter(new SingleColumnValueFilter(FAMILY1, QUALIFIER1, CompareOp.EQUAL, value1));
    List<IndexSpecification> indices = new ArrayList<IndexSpecification>();
    IndexSpecification is1 = new IndexSpecification("idx1");
    HColumnDescriptor colDesc = new HColumnDescriptor(FAMILY1);
    is1.addIndexColumn(colDesc, COL1, ValueType.String, 15);
    indices.add(is1);

View Full Code Here

    int i = 0;
    Scan s = new Scan();
    FilterList filterList = new FilterList();
    // check for combination of cat in q1 and dog in q1
    Filter filter1 =
        new SingleColumnValueFilter("col1".getBytes(), "ql".getBytes(), CompareOp.EQUAL,
            "cat".getBytes());
    Filter filter2 =
        new SingleColumnValueFilter("col2".getBytes(), "ql".getBytes(), CompareOp.EQUAL,
            "dog".getBytes());
    filterList.addFilter(filter1);
    filterList.addFilter(filter2);
    s.setFilter(filterList);

View Full Code Here

    HTable table = new HTable(conf, tableName);
    Scan s = new Scan();
    Filter filter = null;
    if (isIndexed) {
      filter =
          new SingleColumnValueFilter("col".getBytes(), "ql".getBytes(), CompareOp.EQUAL,
              filterVal.getBytes());
    } else {
      filter =
          new SingleColumnValueFilter("col".getBytes(), "ql".getBytes(), CompareOp.EQUAL,
              "cat".getBytes());
    }
    s.setFilter(filter);
    if (isCached) {
      s.setCaching(cacheNumber);

View Full Code Here


    int i = 0;
    Scan s = new Scan();
    Filter filter = null;
    filter =
        new SingleColumnValueFilter("col".getBytes(), "ql".getBytes(), CompareOp.EQUAL,
            "cat".getBytes());


    s.setFilter(filter);
    s.setCaching(3);
    ResultScanner scanner = table.getScanner(s);

View Full Code Here

      Scan s = new Scan();
      for (byte[] family : targetFamilies) {
        s.addFamily(family);
      }
      Filter filter =
          new SingleColumnValueFilter(FAMILY_A, (Bytes.toString(QUALIFIER_NAME) + "1").getBytes(),
              CompareOp.EQUAL, data);
      s.setFilter(filter);
      ResultScanner scanner = table.getScanner(s);


      for (Result res : scanner) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.hadoop.hbase.filter.SingleColumnValueFilter

co.cask.cdap.data2.transaction.queue.hbase.HBase94QueueConsumer

co.cask.cdap.data2.transaction.queue.hbase.HBase96QueueConsumer

co.cask.tigon.data.transaction.queue.hbase.HBase94QueueConsumer

co.cask.tigon.data.transaction.queue.hbase.HBase96QueueConsumer

co.nubetech.crux.server.filter.HBaseFilterFactory

co.nubetech.crux.server.filter.TestHBaseFilterFactory

com.alibaba.druid.hdriver.impl.execute.SingleTableQueryExecutePlan

com.alibaba.wasp.fserver.EntityGroupScanner

com.alibaba.wasp.plan.execute.ExecutionEngine$AggregateQueryExecutor

com.atlantbh.jmeter.plugins.hbasecomponents.samplers.HBaseScanSampler

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.