"assume" isn't in CQL, that's right--however, it IS in cqlsh.  You're just using it wrong.  Try:

    ASSUME <myCF> KEY values are text;

Remember, in CQL, row keys are just another column, so you need to treat "KEY" (if that's the name of your key column) as a normal column.  "HELP ASSUME" in cqlsh might help you out more (or it might not).


On Sat, Aug 11, 2012 at 2:59 PM, Tyler Hobbs <tyler@datastax.com> wrote:
As far as I know, "assume" isn't a CQL feature, it's only part of cassandra-cli.

On Tue, Aug 7, 2012 at 10:16 PM, Jason Hill <jasonhillpdx@gmail.com> wrote:

I'm using:

[cqlsh 2.0.0 | Cassandra 1.0.10 | CQL spec 2.0.0 | Thrift protocol 19.20.0]

I have a column family with a key that is a blob so I query it like this:

    SELECT FIRST 10 1..1344385804 FROM <myCF> WHERE KEY =

Is there any way to avoid the hex I'm using for the key?

I tried the following

    ASSUME <myCF> KEYS ARE text;

but it gave this error:

    Improper assume command.

I'm thinking I've missed something here and hope a kind soul would
point me to a solution.


Tyler Hobbs