Cassandra CQL not equal operator on any column

cassandra cql
Gargee Banerjee picture Gargee Banerjee · Oct 15, 2013 · Viewed 39.6k times · Source

Hi is there any way I can use != operator using CQL in Cassandra? I am trying to use a != operator on my columnfamily but when I try using that it says:

cqlsh:EPCContent> select * from "MediaCategoryGroup" where "MCategoryID"!=1;

I get this error:

Invalid syntax at line 1, char 55
  select * from "MediaCategoryGroup" where "MCategoryID"!=1;
                                                        ^

Answer

emgsilva picture emgsilva · Oct 15, 2013

If you look at the Cassandra SELECT syntax, you will see that the WHERE clause must be "composed of relations on the columns that are part of the PRIMARY KEY and/or have a secondary index defined on them." Does your column conform to that specification?

Just for your information this is the full list of relation operators: '=' | '<' | '>' | '<=' | '>=' | '!=' | IN | CONTAINS | CONTAINS KEY.

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