>
> I think you just need to quote the "Users" identifier. Without quotes,
> identifiers are treated as case-insensitive.
> https://cassandra.apache.org/doc/cql3/CQL.html#identifiers
Hi Adam!
Yes that was it. It's working now.
cqlsh:demo> select * from "Users";
key | column1 | value
----------------------------------------------+--------------------+------------------------------------------------------------------------------------
0x63686574616e2e7468756d6172407469657a2e6e6c | 0x63726561746564 |
0x323031342d30382d31332030323a34313a3438
0x63686574616e2e7468756d6172407469657a2e6e6c | 0x6c6f636174696f6e |
0x496e646961
0x63686574616e2e7468756d6172407469657a2e6e6c | 0x6e616d65 |
0x63686574616e
0x63686574616e2e7468756d6172407469657a2e6e6c | 0x70617373776f7264 |
0x30613830623837373338616638633466313761663334636561316135613663386562333730623462
0x63686574616e2e7468756d6172407469657a2e6e6c | 0x757365726e616d65 |
0x63686574616e
0x7269742e727573736f40676d61696c2e636f6d | 0x63726561746564 |
0x323031342d30382d31332030393a33383a3239
0x7269742e727573736f40676d61696c2e636f6d | 0x6c6f636174696f6e |
0x556e6974656420537461746573
0x7269742e727573736f40676d61696c2e636f6d | 0x6e616d65 |
0x52697420527573736f
0x7269742e727573736f40676d61696c2e636f6d | 0x70617373776f7264 |
0x37323838656464306663336666636265393361306366303665333536386532383532313638376263
0x7269742e727573736f40676d61696c2e636f6d | 0x757365726e616d65 |
0x4461726b776f6c66
0x7465656e612e73686168407469657a2e6e6c | 0x63726561746564 |
0x323031342d30382d31332030323a33393a3537
0x7465656e612e73686168407469657a2e6e6c | 0x6c6f636174696f6e |
0x496e646961
0x7465656e612e73686168407469657a2e6e6c | 0x6e616d65 |
0x5465656e612053686168
0x7465656e612e73686168407469657a2e6e6c | 0x70617373776f7264 |
0x34353532356363653733353363373832323032303930343464366438386234326431313430316136
0x7465656e612e73686168407469657a2e6e6c | 0x757365726e616d65 |
0x7465656e61
0x6a6a407469657a2e6e6c | 0x63726561746564 |
0x323031342d30382d31332030313a31303a3437
0x6a6a407469657a2e6e6c | 0x6c6f636174696f6e |
0x496e646961
0x6a6a407469657a2e6e6c | 0x6e616d65 |
0x6a6a
0x6a6a407469657a2e6e6c | 0x70617373776f7264 |
0x37333233613534333164316333313037323938336136613562663233373435623635356464663539
0x6a6a407469657a2e6e6c | 0x757365726e616d65 |
0x6a6a
(20 rows)
Thanks!
Tim
On Wed, Aug 13, 2014 at 10:37 AM, Adam Holmberg <[email protected]>
wrote:
> I think you just need to quote the "Users" identifier. Without quotes,
> identifiers are treated as case-insensitive.
> https://cassandra.apache.org/doc/cql3/CQL.html#identifiers
>
> Adam
>
>
> On Wed, Aug 13, 2014 at 9:27 AM, Tim Dunphy <[email protected]> wrote:
>
>> Hello,
>>
>> I am trying to figure out how to do a select * from a table that's
>> stored in a cassandra database.
>>
>> [root@beta-new:/home/tiezinteractive/www/cassandra] #cqlsh
>> Connected to Jokefire Cluster at beta-new.jokefire.com:9160.
>> [cqlsh 4.1.0 | Cassandra 2.0.6 | CQL spec 3.0.0 | Thrift protocol 19.39.0]
>> Use HELP for help.
>> cqlsh> describe keyspaces;
>>
>> system animals joke_fire1 game_of_thrones system_traces demo
>>
>> cqlsh> use demo;
>> cqlsh:demo> describe tables;
>>
>> Users
>>
>> cqlsh:demo> select * from Users;
>> *Bad Request: unconfigured columnfamily users*
>>
>> Can someone please help me with what I'm doing wrong in using this select
>> statement?
>>
>> Thanks
>> Tim
>>
>> --
>> GPG me!!
>>
>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>>
>>
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
