cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matteo Rulli <>
Subject Select values from map with multiple key values in where clause
Date Wed, 10 Feb 2016 14:00:26 GMT
I have a table like the following 

    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 <>
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, 

View raw message