cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dunphy <bluethu...@gmail.com>
Subject Re: select * from table in CQLSH
Date Wed, 13 Aug 2014 14:58:24 GMT
>
> 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 <adam.holmberg@datastax.com>
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 <bluethundr@gmail.com> 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

Mime
View raw message