not a support question
Anonymous
Unregistered
Hi, I'm new to Cassandra. I am wondering why CQL only supports using 'and' but does not support the use of 'or' in the where clause. Am I missing something about Cassandra? Do people not need to do this typically when using Cassandra?
Is it recommended to just issue multiple CQL select statements, one for each column you want to filter on?
Thanks,
Erik
Anonymous
Unregistered
Take a look at this http://stackoverflow.com/questions/10139390/alternative-for-or-condition-after-where-clause-in-select-statement-cassandra
Short answer is - disjunctions are not currently supported in Cassandra and wouldn't be supported until probably 1.2 or later this is related to internal data organization.
Anonymous
Unregistered
Xedin, thanks for the reply. I actually came across that stackoverflow post before but it doesn't help me since I need to have multiple columns compared using OR in my WHERE clause.
I guess I will have to use multiple queries for now until this functionality gets added to Cassandra.
Thanks,
Erik