CODEWITHSUNDEEP
cassandracql
chris
chris

Reputation: 89

Specifying column ranges in CQL(1.1) using FIRST N

In CQL docs 1.0 you could specify range of columns using the "FIRST N" attribute with a SELECT statement

In CQL docs 1.1 it seems to be omitted, is this feature being removed from CQL, or is it still supported....perhaps in a different way?

Upvotes: 2

Views: 484

Answers (2)

BigBen
BigBen

Reputation: 1202

I think it's been removed. Here's the official CQL3 doc:

The <select-clause> determines which columns needs to be queried and returned in the result-set. It consists of either the comma-separated list of column names to query, or the wildcard character (*) to select all the columns defined for the table.

Upvotes: 0

the paul
the paul

Reputation: 9161

So that there isn't any misunderstanding, the WRITETIME attribute isn't a replacement for FIRST, or even close to the same thing. The difference is that in CQL 3, wide cassandra rows are now modeled as narrow-looking CQL rows with multi-component primary keys.

For more information and introduction to the modeling changes (which really will make your life lots easier), see http://www.datastax.com/dev/blog/schema-in-cassandra-1-1 .

That said, you can still use CQL 2 and its FIRST clause and the .. range operator, etc. to your heart's content. It's just deprecated.

Upvotes: 3

Related Questions