Alright, thanks again!
I guess I'll stick to the CLI since I'd rather not make schema changes for
the sake of querying (we have hundreds of column families and I don't want
to make that change everywhere).
On Thu, May 3, 2012 at 2:41 PM, paul cannon wrote:
> Very sadly, no. It's not (yet?) mea
Very sadly, no. It's not (yet?) meant to be a particularly good
interactive language, so the only "function" in cql is COUNT(), and that's
really just special syntax. It seems, though, that you might actually be
better off with a key of type 'ascii' or 'text', if that's how you expect
to work with
Gotcha, I probably should have guessed that much. Does CQL have any
functions to convert ascii to hex so that I don't have to do that
conversion elsewhere (I don't see one in the docs)?
On Thu, May 3, 2012 at 2:09 PM, paul cannon wrote:
> On Thu, May 3, 2012 at 12:46 PM, Eric Czech wrote:
>
>>
On Thu, May 3, 2012 at 12:46 PM, Eric Czech wrote:
> I can't believe I have to ask this but I have a CF with about 10 rows and
> the keys are literally 1 through 9.
>
> Why does this not work if I want the row where the key is ascii('5')?
>
> cqlsh:Keyspace1> select first 1 * from CF where key
I can't believe I have to ask this but I have a CF with about 10 rows and
the keys are literally 1 through 9.
Why does this not work if I want the row where the key is ascii('5')?
cqlsh:Keyspace1> select first 1 * from CF where key = '5';
KEY
-
05
* I saw the Jira about the sort of phant
