CODEWITHSUNDEEP
cassandraphpcassa
Linas
Linas

Reputation: 4408

Cassandra composite column partial querying

I can't find a way to get columns by second or any other part of the column name, for example if i have

user_id:timestamp

How can i select that column by timestamp and completely ignore user_id?

This is the code i'm using now:

$slice = new ColumnSlice( array('user_id'), "", 1);

$row = $cf->get("key", $slice);

Thank you.

Upvotes: 1

Views: 338

Answers (1)

Chris Gerken
Chris Gerken

Reputation: 16392

You can't. You have to specify the start and end values of the slice, and that means specifying at least the first of the composite values.

The converse of that is that you can do this, but you have to select all of the columns and test on the client side whether the filter criteria is met by each column value.

Upvotes: 3

Related Questions