I would also like to add that if you avoid IN and use async queries instead, it
is pretty trivial to use a semaphore or some other limiting mechanism to put a
ceiling on the amount on concurrent work you are sending to the cluster. If you
use a query with an IN clause with a thousand things, you
I'd like to add that in() is usually a bad idea. It is convenient, but not
really what you want in production. Go with Jens' original suggestion of
multiple queries.
I recommend reading Ryan Svihla's post on why in() is generally a bad
thing:
http://lostechies.com/ryansvihla/2014/09/22/cassandra
Hi Rahul,
No, you can't do this in a single query. You will need to execute two
separate queries if the requirements are on different columns. However, if
you'd like to select multiple rows of with restriction on the same column
you can do that using the `IN` construct:
select * from table where
Hi
I want to make uniqueness for my data so i need to add OR clause in my
WHERE clause.
ex: select * from table where id =123 OR name ='abc'
so in above i want that i get data if my id is 123 or my name is abc .
is there any possibility in cassandra to achieve this .
