select * from mytable where mykey IN('xxx', 'yyy', 'zzz','111',222','333')
is there a limit on how many item you can specify inside IN clause?
CQL IN clause will help reduce the round trip traffic otherwise needed if
use multiple select statement, correct?
but how about the co-ordinate node that receive this request? is that
possible we are putting lot of pressure on a single node when the IN clause
has many items(100s)?
or Cassandra has special handling of IN clause that is efficient handling
the load?
thanks
