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)

Reply via email to