public List<LogEntry> getPending() throws Throwable {
    List<LogEntry> result = new ArrayList<LogEntry>();
    SlicePredicate predicate = new SlicePredicate();
    SliceRange range =
        new SliceRange(
            ByteBufferUtil.bytes(""), ByteBufferUtil.bytes(""), false, MAX_NUMBER_COLUMNS);
    predicate.setSlice_range(range);

    KeyRange keyRange = new KeyRange(BATCH_SIZE);
    keyRange.setStart_key(ByteBufferUtil.bytes(""));
    keyRange.setEnd_key(ByteBufferUtil.EMPTY_BYTE_BUFFER);
    ColumnParent parent = new ColumnParent(COLUMN_FAMILY);

    IndexClause indexClause = new IndexClause();
    indexClause.setCount(BATCH_SIZE);
    indexClause.setStart_key(new byte[0]);
    indexClause.addToExpressions(
        new IndexExpression(
            ByteBufferUtil.bytes(LogEntryColumns.STATUS.toString()),
            IndexOperator.EQ,
            ByteBufferUtil.bytes(LogEntryStatus.COMMITTED.toString())));

    indexClause.addToExpressions(
        new IndexExpression(
            ByteBufferUtil.bytes(LogEntryColumns.HOST.toString()),
            IndexOperator.EQ,
            ByteBufferUtil.bytes(this.getHostName())));

    List<KeySlice> rows =
        getConnection(KEYSPACE)
            .get_indexed_slices(parent, indexClause, predicate, ConsistencyLevel.ALL);

    result.addAll(toLogEntry(rows));

    indexClause = new IndexClause();
    indexClause.setCount(BATCH_SIZE);
    indexClause.setStart_key(new byte[0]);
    indexClause.addToExpressions(
        new IndexExpression(
            ByteBufferUtil.bytes(LogEntryColumns.STATUS.toString()),
            IndexOperator.EQ,
            ByteBufferUtil.bytes(LogEntryStatus.COMMITTED.toString())));

    indexClause.addToExpressions(
        new IndexExpression(
            ByteBufferUtil.bytes((LogEntryColumns.TIMESTAMP.toString())),
            IndexOperator.LT,
            ByteBufferUtil.bytes(
                System.currentTimeMillis() - (1000L * TIME_BEFORE_PROCESS_OTHER_HOST))));

    rows =
        getConnection(KEYSPACE)
            .get_indexed_slices(parent, indexClause, predicate, ConsistencyLevel.ALL);

    result.addAll(toLogEntry(rows));
    return result;
  }
示例#2
0
  @Test
  public void testGetRangeSlices() throws HectorException {
    for (int i = 0; i < 10; i++) {
      ColumnPath cp = new ColumnPath("Standard1");
      cp.setColumn(bytes("testGetRangeSlices_" + i));

      keyspace.insert(
          "testGetRangeSlices0",
          cp,
          StringSerializer.get().toByteBuffer("testGetRangeSlices_Value_" + i));
      keyspace.insert(
          "testGetRangeSlices1",
          cp,
          StringSerializer.get().toByteBuffer("testGetRangeSlices_Value_" + i));
      keyspace.insert(
          "testGetRangeSlices2",
          cp,
          StringSerializer.get().toByteBuffer("testGetRangeSlices_Value_" + i));
    }

    // get value
    ColumnParent clp = new ColumnParent("Standard1");
    SliceRange sr =
        new SliceRange(ByteBuffer.wrap(new byte[0]), ByteBuffer.wrap(new byte[0]), false, 150);
    SlicePredicate sp = new SlicePredicate();
    sp.setSlice_range(sr);

    KeyRange range = new KeyRange();
    range.setStart_key("".getBytes());
    range.setEnd_key("".getBytes());

    Map<String, List<Column>> keySlices = se.fromBytesMap(keyspace.getRangeSlices(clp, sp, range));

    assertNotNull(keySlices);

    assertNotNull("testGetRangeSlices1 is null", keySlices.get("testGetRangeSlices1"));
    assertEquals(
        "testGetRangeSlices_Value_0",
        string(keySlices.get("testGetRangeSlices1").get(0).getValue()));
    assertEquals(10, keySlices.get("testGetRangeSlices1").size());

    ColumnPath cp = new ColumnPath("Standard1");
    keyspace.remove("testGetRanageSlices0", cp);
    keyspace.remove("testGetRanageSlices1", cp);
    keyspace.remove("testGetRanageSlices2", cp);
  }
  @PooledConnection
  public JSONArray getRows(
      String keyspace, String columnFamily, String queryStr, ConsistencyLevel consistencyLevel)
      throws InvalidRequestException, UnavailableException, TimedOutException, TException,
          CharacterCodingException {
    if (StringUtils.isNotBlank(queryStr)) {
      return getRowsWithQuery(keyspace, columnFamily, queryStr, consistencyLevel);
    }
    SlicePredicate predicate = new SlicePredicate();
    SliceRange range =
        new SliceRange(ByteBufferUtil.bytes(""), ByteBufferUtil.bytes(""), false, MAX_COLUMNS);
    predicate.setSlice_range(range);

    KeyRange keyRange = new KeyRange(MAX_ROWS);
    keyRange.setStart_key(ByteBufferUtil.bytes(""));
    keyRange.setEnd_key(ByteBufferUtil.EMPTY_BYTE_BUFFER);
    ColumnParent parent = new ColumnParent(columnFamily);
    List<KeySlice> rows =
        getConnection(keyspace).get_range_slices(parent, predicate, keyRange, consistencyLevel);
    return JsonMarshaller.marshallRows(rows, true);
  }
	public static void main(String[] args) throws UnsupportedEncodingException,
	InvalidRequestException, UnavailableException, TimedOutException,
	TException, NotFoundException {

		TTransport tr = new TSocket(“192.168.1.204″, 9160);
		TProtocol proto = new TBinaryProtocol(tr);
		Cassandra.Client client = new Cassandra.Client(proto);

		tr.open();

		String keyspace = “Historical_Info”;
		String columnFamily = “Historical_Info_Column”;
		//String keyUserID = “3”;

		// read entire row
		SlicePredicate predicate = new SlicePredicate();
		SliceRange sliceRange = new SliceRange();
		sliceRange.setStart(new byte[0]);
		sliceRange.setFinish(new byte[0]);
		predicate.setSlice_range(sliceRange);

		KeyRange keyrRange = new KeyRange();
		keyrRange.setStart_key(“1″);
		keyrRange.setEnd_key(“”);
		//keyrRange.setCount(100);

		ColumnParent parent = new ColumnParent(columnFamily);

		List < KeySlice > ls = client.get_range_slices(keyspace, parent, predicate, keyrRange, ConsistencyLevel.ONE);

		for (KeySlice result: ls) {
			List < ColumnOrSuperColumn > column = result.columns;
			for (ColumnOrSuperColumn result2: column) {
				Column column2 = result2.column;
				System.out.println(new String(column2.name, UTF8) + ” - > ” + new String(column2.value, UTF8));
			}
		}

		tr.close();
	}