Joining two result sets into one

Question

I wanted to know if there's a way to join two or more result sets into one.
I actually need to execute more than one query and return just one result set. I can't use the UNION or the JOIN operators because I'm working with Cassandra (CQL)
Thanks in advance !

Answer 1

Framework like Playorm provide support for JOIN (INNER and LEFT JOINs)queries in Cassandra.

http://buffalosw.com/wiki/Command-Line-Tool/

You may see more examples at:

https://github.com/deanhiller/playorm/blob/master/src/test/java/com/alvazan/test/TestJoins.java