I am using the DataStax driver and got prepared to work. When I tried to use the "IN" keyword with a SQL it did not work. According to DataStax IN should work.
So if I tried:
Select * from items Where item_id IN (Select item_id FROM users where user_id = ?)
Thanks for the feedback.