Spring Data Cassandra: InvalidQueryException: UUID should be 16 or 0 bytes (20)

It looks like as if IN queries using UUID are not possible by passing in a collection into a single bind value.

Here's what happens:

Spring Data transforms your String-query

SELECT * FROM entity WHERE id IN (:id) 

into Cassandra's notation using positional query arguments

SELECT * FROM entity WHERE id IN (?) 

and binds the given parameter to ?. Let's transform this into an executable piece of code:

session.execute(new SimpleStatement("SELECT * FROM entity WHERE id IN (?)", Arrays.asList(UUIDs.random()))); 

When you run this snipped, then you'll end up with InvalidQueryException again. We can still make an IN query happen, but we need to unfold parameters:

new SimpleStatement("SELECT * FROM entity WHERE id IN (?, ?)", UUIDs.random(), UUIDs.random()) 

In an ideal world, Cassandra could accept a List (or Set) of items to keep the query string agnostic against the actual number of arguments.

It is work at me.

Use: findAllBy[object-property]In where [object-property] is name of property of the MyModel UUID.

@Table("example") public class MyModel { @PrimaryKeyColumn(name = "uuid", type = PrimaryKeyType.PARTITIONED) private UUID uuid; @Column("...") ... } public interface MyRepository extends CassandraRepository<MyModel, UUID> { List<Restaurant> findAllByUuidIn(Collection<UUID> uuidButIfYouWant); } // It is OK return this.myRepository.findAllByUuidIn(Set.of( UUID.randomUUID(), UUID.randomUUID() )); // Throw Error: no viable alternative at input '<EOF>' (SELECT * FROM example WHERE [uuid] IN...) return this.myRepository.findAllByUuidIn(Set.of()); 

So if not contain uuid:

Collection<UUID> search = Set.of(); if(search.size() == 0) { return List.of(); } return this.myRepository.findAllByUuidIn(search); 

(I am adding this answer for future reference)

I had the same error when running a spark application.

The error occurred when executing a Cassandra query and where a UUID type was expected, some other data type was sent by the query. In my case, it was a String. Passing the right data type (UUID instead of String) resolved the issue.

I hope you found an answer, but if you are using UUID version 4, maybe the type in your table are wrong. For example instead of UUID your ID field could be varchar.