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: 20.0/14400 Memtable thresholds: 0.267187497/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: 20.0/14400 Memtable thresholds: 0.267187497/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)
Re: Unable to access column family in CLI after building CF in CQL
If you create CFs outside the cli, you may need to restart it to refresh its internal cache of the schema. On Thu, Jun 16, 2011 at 8:51 AM, yikes bigdata yikes.bigd...@gmail.com wrote: 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: 20.0/14400 Memtable thresholds: 0.267187497/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: 20.0/14400 Memtable thresholds: 0.267187497/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) -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
Re: Unable to access column family in CLI after building CF in CQL
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. - Original Message - 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: 20.0/14400 Memtable thresholds: 0.267187497/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: 20.0/14400 Memtable thresholds: 0.267187497/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)
Re: Unable to access column family in CLI after building CF in CQL
Ah that works. Thanks everyone for the help. On Thu, Jun 16, 2011 at 9:04 AM, Konstantin Naryshkin konstant...@a-bb.netwrote: 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: 20.0/14400 Memtable thresholds: 0.267187497/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: 20.0/14400 Memtable thresholds: 0.267187497/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)
