I haven't used CQL functionality much, but thirft client I think what I encounter is exactly this problem! > If you want to query over key, you can index keys to other CF, get the column names (that is key of other CF ). and then query actual CF with keys.
switch away from the random partitioner. > switching away is not a good choice, RP is very good for load distribution.
