Ah that works. Thanks everyone for the help.
On Thu, Jun 16, 2011 at 9:04 AM, Konstantin Naryshkin <konstant...@a-bb.net>wrote: > The second error (the CQL select) is because you have different Key > Validation Class values for your two user columns. users is > org.apache.cassandra.db.marshal.BytesType, > while users2 is org.apache.cassandra.db.marshal.UTF8Type. The select is > failing because you are comparing a String to a bunch of bytes. > > ------------------------------ > *From: *"yikes bigdata" <yikes.bigd...@gmail.com> > *To: *user@cassandra.apache.org > *Sent: *Thursday, June 16, 2011 3:51:41 PM > *Subject: *Unable to access column family in CLI after building CF in CQL > > > 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) > >