title: Cassandra Select Query using Collection Primary Key in Where Clause
body: <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>