Cassandra Select Query using Collection Primary Key in Where Clause
<p>I'm new to Cassandra and I created a table with a frozen collection as the primary key</p>

<pre><code>cqlsh&gt; create table rick_morty (id uuid, name text, adventure text, instigator frozen&lt;set&lt;text&gt;&gt;, PRIMARY KEY((instigator), adventure, name, id));    
</code></pre>

<p>Now I want to query based on the primary key (instigator) for all of the values held in the collection. I have found that if I just wanted to query on 1 value, I can use CONTAINS 'contained_value', but I want to query on the entire collection.</p>

<p>I've been looking all over to figure out how to do this but I can't find the answer.</p>

<p>Doing something like</p>

<pre><code>const query = 'SELECT name from rick_morty';
</code></pre>

<p>retrieves all results but I want to do something like...</p>

<pre><code>const query = 'SELECT name from rick_morty where instigator = ["Rick", "Morty", "Beth"]';
</code></pre>

<p>to retrieve all list of names associated with that array of instigators.</p>

<p>Is this possible?? Did I just create my table in an improper way?</p>