Skip to content

Instantly share code, notes, and snippets.

@jsanda
Created October 17, 2012 15:22
Show Gist options
  • Save jsanda/3906119 to your computer and use it in GitHub Desktop.
Save jsanda/3906119 to your computer and use it in GitHub Desktop.
// A Thrift slice query using Hector
SliceQuery<Integer, Long, Double> query = HFactory.createSliceQuery(keyspace, IntegerSerializer.get(),
LongSerializer.get(), DoubleSerializer.get());
query.setColumnFamily(RAW_METRIC_DATA_CF);
query.setKey(scheduleId);
query.setRange(null, null, false, 10);
`
QueryResult<ColumnSlice<Long, Double>> queryResult = query.execute();
List<HColumn<Long, Double>> actual = queryResult.get().getColumns();
// The same query using CQL with Cassandra JDBC driver
Statement statement = connection.createStatement();
String sql = "SELECT * FROM raw_metrics WHERE schedule_id = " + scheduleId + " LIMIT 10";
ResultSet resultSet = statement.executeQuery(sql);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment