incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From paul cannon <p...@datastax.com>
Subject Re: Assume Keys in cqlsh?
Date Sun, 19 Aug 2012 04:21:25 GMT
"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).

p

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:
>
>> Hello,
>>
>> 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 =
>> '436170616369747943616c63756c61746f727c33';
>>
>> 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.
>>
>> Cheers,
>> Jason
>>
>
>
>
> --
> Tyler Hobbs
> DataStax <http://datastax.com/>
>
>

Mime
View raw message