Hi, I was following the CQL example on the DataStax website and was able to create a new column family and query it. But when I viewed the column family in the CLI, it gives me the following error.
# Unable to read column family created from CQL [default@store] list users2; *users2 not found in current keyspace.* Also, when I try to query the user table from CQL, i'm unable to filter on a key. The user table was created in the CLI but accessible by CQL with a simple select * from users; cqlsh> select * from users where key='tyler'; *Bad Request: cannot parse 'tyler' as hex bytes* # In the CLI, the store keyspaces displays two column families . [default@store] show keyspaces; Keyspace: store: Replication Strategy: org.apache.cassandra.locator.SimpleStrategy Options: [replication_factor:1] Column Families: *ColumnFamily: users* Key Validation Class: org.apache.cassandra.db.marshal.BytesType Default column value validator: org.apache.cassandra.db.marshal.BytesType Columns sorted by: org.apache.cassandra.db.marshal.AsciiType Row cache size / save period in seconds: 0.0/0 Key cache size / save period in seconds: 200000.0/14400 Memtable thresholds: 0.26718749999999997/57/1440 (millions of ops/MB/minutes) GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 1.0 Replicate on write: false Built indexes: [] Column Metadata: Column Name: email Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: userName Validation Class: org.apache.cassandra.db.marshal.UTF8Type *ColumnFamily: users2* Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type Default column value validator: org.apache.cassandra.db.marshal.UTF8Type Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type Row cache size / save period in seconds: 0.0/0 Key cache size / save period in seconds: 200000.0/14400 Memtable thresholds: 0.26718749999999997/57/1440 (millions of ops/MB/minutes) GC grace seconds: 864000 Compaction min/max thresholds: 4/32 Read repair chance: 1.0 Replicate on write: true Built indexes: [] Column Metadata: Column Name: session_token Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: state Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: password Validation Class: org.apache.cassandra.db.marshal.UTF8Type Column Name: birth_year Validation Class: org.apache.cassandra.db.marshal.LongType Column Name: gender Validation Class: org.apache.cassandra.db.marshal.UTF8Type Keyspace: system: Able to see the list of keys generate within the CLI [default@store] list users; Using default limit of 100 ------------------- RowKey: foo => (column=age, value=3339, timestamp=1308182349595000) => (column=email, value=f...@email.com, timestamp=1308182349594000) => (column=userName, value=foo, timestamp=1308182349591000) ------------------- RowKey: bar => (column=email, value=b...@email.com, timestamp=1308182355297000) => (column=gender, value=66, timestamp=1308182355299000) => (column=userName, value=bar, timestamp=1308182355295000) ------------------- RowKey: tyler => (column=email, value=ty...@email.com, timestamp=1308182355303000) => (column=sports, value=6261736562616c6c, timestamp=1308182355309000) => (column=userName, value=tyler, timestamp=1308182355302000)