Bad Request: unconfigured columnfamily <CF_name> in Cassandra

cassandra cql
NullException picture NullException · Apr 22, 2013 · Viewed 17.6k times · Source

I am using following version of cql and cassandra. See below: cqlsh 2.3.0 | Cassandra 1.1.10 | CQL spec 3.0.0 | Thrift protocol 19.33.0

I have all CF and tons of data in it. When I run:

cqlsh -2 or cqlsh -3 cql> USE "test_keyspace"; cql:test_keyspace> SELECT * FROM "column_family_name" LIMIT 1;

Note: CFs were created using pycassa and am trying to read using cql. Not sure, if this will make a difference.

It throws, Bad Request: unconfigured columnfamily Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh.

Is there any specific settings, that I need to be looking at, to resolve this issue?

Answer

abhi picture abhi · Apr 22, 2013

by default CQL3 is case-insensitive unless enclosed in double quotation marks. Try putting your CFNAME in double quotes.

SELECT * FROM "CFNAME" LIMIT 1;

Looks like you have forgotten to enable CQL3 from api at the time of table creation

Related questions

Difference between partition key, composite key and clustering key in Cassandra?

I have been reading articles around the net to understand the differences between the following key types. But it just seems hard for me to grasp. Examples will definitely help make understanding better. primary key, partition key, composite key clustering …

Read More
How to get current timestamp with CQL while using Command Line?

I am trying to insert into my CQL table from the command line. I am able to insert everything. But I am wondering if I have a timestamp column, then how can I insert into timestamp column from the command …

Read More
How to run cql files (.cql) from within cqlsh?

The problem that I am having is that I want to run the following command (and I can't): cqlsh < cql_directory/cql_create_stuff.cql Because I have not logged in to cqlsh. So I logged in: cqlsh -u …

Read More