Hello! 
I have a table like the following 

CREATE TABLE test (
    my_id uuid,
    values map<UUID, FROZEN <value_reference> >,
    PRIMARY KEY (my_id)
)...

and I would like to perform a query along these lines: 
SELECT * FROM test WHERE my_id = 670287fe-e080-42c3-9fae-7ffdc3309793 AND 
values CONTAINS KEY {00000000-0000-0000-0000-000000000001, 
00000000-0000-0000-0000-000000000002};

Is this possible?

If the answer is no, the other approach I tried is via UDF. So the second 
question is: 

Is it possible to use UDF in where clause?

Reading the https://issues.apache.org/jira/browse/CASSANDRA-8488 
<https://issues.apache.org/jira/browse/CASSANDRA-8488> issue I fear the answer 
is still no, right? 

As a last chance, I'm considering implementing a custom secondary index: is 
this a viable approach to get the kind of SELECT detailed above? 

Many thanks, 
matteo

Reply via email to