CODEWITHSUNDEEP
cassandracql
statistic
statistic

Reputation: 181

Cassandra Subquery Alternate

I am looking for this code for cassandra;

SELECT * FROM table_1 WHERE col_1 IN (SELECT col_1 FROM table_2 WHERE col_2=2)

Is there any correspond code for cassandra?

Upvotes: 2

Views: 3808

Answers (1)

Horia
Horia

Reputation: 2982

Two of Cassandra's core concepts is that the tables are designed to serve one query and it does not support these kinds of selects. Of course, you could do that at your application level.

So, the answer in no, it won't support such query.

Upvotes: 6

Related Questions