Package org.apache.hadoop.hbase.client.idx

Examples of org.apache.hadoop.hbase.client.idx.IdxScan

90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
    for (int i = 0; i < 5; i++) {
      service.submit(new Writer(table, family, qualifier, sequence, rows));
    }

    byte[] value = Bytes.toBytes((FIXED_PART + 0).toCharArray());
    IdxScan idxScan = new IdxScan();
    idxScan.setExpression(Expression.comparison(family, qualifier,
      Comparison.Operator.EQ, value));
    idxScan.setFilter(new SingleColumnValueFilter(family, qualifier,
      CompareFilter.CompareOp.EQUAL, value));
    idxScan.setCaching(1000);

    int count = 0;
    int finalCount = maxRows / 10;
    int printCount = 0;
    while (count < finalCount) {
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
    final byte[] intValue = Bytes.toBytes(numberOfRows - numberOfRows / 5);
    final byte[] charsValue =
      Bytes.toBytes(String.format("%010d", 50).toCharArray());
    final byte[] bytesValue = String.format("%010d", 990).getBytes();

    IdxScan scan = new IdxScan();
    scan.setExpression(Expression.or(
      Expression.and(
        Expression.comparison(FAMILY_1_NAME, INT_QUAL_NAME,
          Comparison.Operator.GTE, intValue),
        Expression.comparison(FAMILY_2_NAME, CHARS_QUAL_NAME,
          Comparison.Operator.LT, charsValue)),
      Expression.comparison(FAMILY_1_NAME, BYTES_QUAL_NAME,
        Comparison.Operator.GTE, bytesValue)));

    scan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ONE,
      Arrays.<Filter>asList(
        new FilterList(FilterList.Operator.MUST_PASS_ALL,
          Arrays.<Filter>asList(
            new SingleColumnValueFilter(FAMILY_1_NAME, INT_QUAL_NAME,
              CompareFilter.CompareOp.GREATER_OR_EQUAL, intValue),
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
170
171
172
    region.flushcache();

    byte[] startRow = Bytes.toBytes(75L);

    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setStartRow(startRow);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.GTE, Bytes.toBytes(50L)));
    InternalScanner scanner = region.getScanner(idxScan);

    List<KeyValue> res = new ArrayList<KeyValue>();
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
    assertEquals(Bytes.toLong(res.get(0).getValue()), 42L);

    /**
     * Scan the index with a matching expression
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.EQ, Bytes.toBytes(42L)));
    scanner = region.getScanner(idxScan);
    res.clear();

    while (scanner.next(res)) ;
    assertEquals(1, res.size());
    assertEquals(Bytes.toLong(res.get(0).getValue()), 42L);

    /**
     * Scan the index with a non matching expression
     */
    idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.EQ, Bytes.toBytes(24L)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new ValueFilter(CompareFilter.CompareOp.EQUAL,
        new BinaryComparator(Bytes.toBytes(24L))));
    }
    scanner = region.getScanner(idxScan);
    res.clear();

View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419

    /**
     * Scan the index with a matching expression
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.EQ, Bytes.toBytes(42L)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new SingleColumnValueFilter(family, qualLong,
        CompareFilter.CompareOp.EQUAL,
        new BinaryComparator(Bytes.toBytes(42L))));
    }
    scanner = region.getScanner(idxScan);
    res.clear();

    //long start = System.nanoTime();
    while (scanner.next(res)) ;
    //long end = System.nanoTime();
    //System.out.println("memStoreEmpty=" + memStoreEmpty + ", time=" + (end - start) / 1000000D);
    assertEquals(numColumns, res.size());
    for (KeyValue kv : res) {
      if (Bytes.equals(kv.getQualifier(), qualLong)) {
        assertEquals(42L, Bytes.toLong(kv.getValue()));
      }
    }

    /**
     * Scan the index with a non matching expression
     */
    idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.EQ, Bytes.toBytes(1000000000L)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new SingleColumnValueFilter(family, qualLong,
        CompareFilter.CompareOp.EQUAL,
        new BinaryComparator(Bytes.toBytes(1000000000L))));
    }
    scanner = region.getScanner(idxScan);
    res.clear();

    while (scanner.next(res)) ;
    assertEquals(0, res.size());


    /**
     * Scan for all the records which are greater than 49499
     */
    idxScan = new IdxScan();
    idxScan.addFamily(family);
    long min = numRows - 500L;
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.GTE, Bytes.toBytes(min)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new SingleColumnValueFilter(family, qualLong,
        CompareFilter.CompareOp.GREATER_OR_EQUAL,
        new BinaryComparator(Bytes.toBytes(min))));
    }
    scanner = region.getScanner(idxScan);
    res.clear();

    //long start = System.nanoTime();
    while (scanner.next(res)) ;
    //long end = System.nanoTime();
    //System.out.println("scan for val >= min memStoreEmpty=" + memStoreEmpty + ", time=" + (end - start)/1000000D);
    assertEquals(500 * numColumns, res.size());

    /**
     * Scan for all the records which are greater than 49499
     */
    idxScan = new IdxScan();
    idxScan.addFamily(family);
    min = numRows / 2;
    long delta = 100;
    long max = min + delta;
    idxScan.setExpression(
      And.and(Comparison.comparison(family, qualLong, Comparison.Operator.GTE, Bytes.toBytes(min)),
        Comparison.comparison(family, qualLong, Comparison.Operator.LT, Bytes.toBytes(max))));
    if (!memStoreEmpty) {
      idxScan.setFilter(new FilterList(Arrays.<Filter>asList(
        new SingleColumnValueFilter(family, qualLong, CompareFilter.CompareOp.GREATER_OR_EQUAL,
          new BinaryComparator(Bytes.toBytes(min))),
        new SingleColumnValueFilter(family, qualLong, CompareFilter.CompareOp.LESS,
          new BinaryComparator(Bytes.toBytes(max))))
      ));
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
  private void checkScanWithThreeColumns(byte[] family, boolean memStoreEmpty, int numRows, int numColumns) throws IOException {

    /**
     * Scan the index with a matching or expression on two indices
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    int low = numRows / 10;
    int high = numRows - low;
    idxScan.setExpression(Or.or(Comparison.comparison(family, qualLong, Comparison.Operator.GTE, Bytes.toBytes((long) high)),
      Comparison.comparison(family, qualDouble, Comparison.Operator.LT, Bytes.toBytes((double) low))));
    if (!memStoreEmpty) {
      idxScan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ONE,
        Arrays.<Filter>asList(
          new SingleColumnValueFilter(family, qualLong, CompareFilter.CompareOp.GREATER_OR_EQUAL,
            new BinaryComparator(Bytes.toBytes((long) high))),
          new SingleColumnValueFilter(family, qualDouble, CompareFilter.CompareOp.LESS,
            new BinaryComparator(Bytes.toBytes((double) low))))
      ));
    }
    InternalScanner scanner = region.getScanner(idxScan);
    List<KeyValue> res = new ArrayList<KeyValue>();

    //long start = System.nanoTime();
    while (scanner.next(res)) ;
    //long end = System.nanoTime();
    //System.out.println("[top and botoom 10%] memStoreEmpty=" + memStoreEmpty + ", time=" + (end - start)/1000000D);
    assertEquals(numRows / 5 * numColumns, res.size());

    /**
     * Scan the index with a matching and expression on two indices
     */
    idxScan = new IdxScan();
    idxScan.addFamily(family);
    int half = numRows / 2;
    idxScan.setExpression(And.and(Comparison.comparison(family, qualLong, Comparison.Operator.GTE, Bytes.toBytes((long) half)),
      Comparison.comparison(family, qualBytes, Comparison.Operator.EQ, Bytes.toBytes("str" + 30))));
    if (!memStoreEmpty) {
      idxScan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ALL,
        Arrays.<Filter>asList(
          new SingleColumnValueFilter(family, qualLong, CompareFilter.CompareOp.GREATER_OR_EQUAL,
            new BinaryComparator(Bytes.toBytes((long) half))),
          new SingleColumnValueFilter(family, qualBytes, CompareFilter.CompareOp.EQUAL,
            new BinaryComparator(Bytes.toBytes("str" + 30))))
View Full Code Here
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
    boolean memStoreEmpty, int numRows, int numColumns) throws IOException {

    /**
     * Scan the index with a matching or expression on two indices
     */
    IdxScan idxScan = new IdxScan();
    final byte[] longVal = Bytes.toBytes((long) 1);
    final byte[] doubleVal = Bytes.toBytes((double) 4);
    final byte[] bytesVal = Bytes.toBytes(String.format("%04d", 9));
    idxScan.setExpression(
      Or.or(Comparison.comparison(family1, qualLong, Comparison.Operator.EQ, longVal),
        Comparison.comparison(family1, qualDouble, Comparison.Operator.EQ, doubleVal),
        Comparison.comparison(family2, qualBytes, Comparison.Operator.EQ, bytesVal)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ONE,
        Arrays.<Filter>asList(
          new SingleColumnValueFilter(family1, qualLong, CompareFilter.CompareOp.EQUAL,
            new BinaryComparator(longVal)),
          new SingleColumnValueFilter(family1, qualDouble, CompareFilter.CompareOp.EQUAL,
            new BinaryComparator(doubleVal)),
View Full Code Here
700
701
702
703
704
705
706
707
708
709
710
711
  private void checkIndexedScanWithMultipleVersions(byte[] family, boolean memStoreEmpty, int numRows, int numVersions) throws IOException {

    /**
     * Scan the index with a matching or expression on two indices
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);

    int[] values = new int[numVersions];
    for (int i = 0; i < numVersions; i++) {
      values[i] = 10 * i + 7;
    }
View Full Code Here
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
    boolean memStoreEmpty, long value, int expectedCount) throws IOException {

    /**
     * Scan the index with a matching or expression on two indices
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(Comparison.comparison(family, qualLong,
      Comparison.Operator.EQ, Bytes.toBytes(value)));
    if (!memStoreEmpty) {
      idxScan.setFilter(new SingleColumnValueFilter(family, qualLong,
        CompareFilter.CompareOp.EQUAL,
        new BinaryComparator(Bytes.toBytes(value))));
    }
    InternalScanner scanner = region.getScanner(idxScan);
    List<KeyValue> res = new ArrayList<KeyValue>();
View Full Code Here
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
    throws IOException {

    /**
     * Scan the index with a matching or expression on two indices
     */
    IdxScan idxScan = new IdxScan();
    idxScan.addFamily(family);
    idxScan.setExpression(
      Comparison.and(Comparison.comparison(family, qualLong,
        Comparison.Operator.GTE, Bytes.toBytes(minValue)),
        Comparison.comparison(family, qualLong,
          Comparison.Operator.LTE, Bytes.toBytes(maxValue))));
    if (!memStoreEmpty) {
      idxScan.setFilter(new FilterList(FilterList.Operator.MUST_PASS_ALL,
        Arrays.<Filter>asList(new SingleColumnValueFilter(family, qualLong,
          CompareFilter.CompareOp.GREATER_OR_EQUAL,
          new BinaryComparator(Bytes.toBytes(minValue))),
          new SingleColumnValueFilter(family, qualLong,
            CompareFilter.CompareOp.LESS_OR_EQUAL,
View Full Code Here
TOP

Related Classes of org.apache.hadoop.hbase.client.idx.IdxScan

  • org.apache.hadoop.hbase.io.ImmutableBytesWritable
  • org.apache.hadoop.hbase.regionserver.TestIdxRegion
  • org.apache.hadoop.hbase.regionserver.TestIdxRegionPerformance
  • org.apache.hadoop.hbase.TestIdxHBaseCluster
  • org.apache.hadoop.io.DataInputBuffer
  • org.apache.hadoop.io.DataOutputBuffer
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.