Support CQL IN ?

0

We're migrating some existing code to AWS Keyspaces, some of it relies on the IN keyword.
Queries are failing with "IN is not yet supported".

Will this functionality be added in the future ?
Is there any alternative that would allow us to achieve the same result ?

Kamek
asked 3 years ago395 views
6 Answers
0

Can you explain your use case for needing the keyword in a bit more detail? If you can share your specific use case we can discuss the best way to help you.

You are correct that at the time of this writing, Amazon Keyspaces does not support the IN keyword. As a general rule, we don't comment on the future direction of the service, but we do prioritize our roadmap based on customer feedback.

answered 3 years ago
0

Bump

Ostico
answered 3 years ago
0

In many cases with Cassandra, it’s better to break the IN Operator statement into multiple queries that are executed independently by the client driver. The application can execute the independent statements in parallel to achieve higher throughput and lower latency. If you find yourself executing the IN statement often you may want to consider changing the datamodel so that you can perform the lookup in a single statement. Could you share your model and query ?

answered 3 years ago
0

Cassandra supports In clause and it works in my local environment with Cassandra 3.11.6:

https://docs.datastax.com/en/cql-oss/3.3/cql/cql_using/useQueryIN.html

I use it also with Datastax DAO
import com.datastax.oss.driver.api.mapper.annotations.*;
...
@Query("SELECT * FROM ${keyspaceId}.${tableId} WHERE target_id IN :target_ids")
PagingIterable<Targets> getAllByPrimaryKeyInClause( List<UUID> target_ids );

Ostico
answered 3 years ago
0

We are currently evaluating KeySpaces. For us we do use IN in a number of places. Changing all of them will be expensive, so it can be a critical reason for us to not migrating over. It's probably sound silly but well I think IN is quite commonly-used in the condition clause.

Also I kinda curious why Amazon decided to not support this keyword in a first place?

answered 3 years ago
0

I can't really share information about our model, but we did end up splitting queries using IN into multiple queries, so this solution works for us.
Still, supporting IN would be nice, additional work is otherwise required while migrating from Cassandra.

Edited by: Kamek on Feb 24, 2021 1:37 PM

Kamek
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions