Search code examples
cassandrawso2cql3wso2-bam

Cannot query some of the cassandra datastore using cql3 in BAM

I am trying the real time traffic sample in BAM, and find the message is stored into cassandra keyspace, with column family: bam_message_store.
However, with cql3, I can't browse the data, can you figure out why?

cqlsh:bam_util_ks> select * from bam_message_store;  
Bad Request: Keyspace bam_util_ks does not exist  
cqlsh:bam_util_ks>
Solution

  • Please try login with keyspace given as parameter in command line parameter, it works. 

    cqlsh -k BAM_UTIL_KS -u admin -p admin

cqlsh:BAM_UTIL_KS> describe tables;

bam_notification_messages 

cqlsh:BAM_UTIL_KS> select * from bam_notification_messages;