title: Cassandra and querying hierarchies
body: <p>I am investigating Cassandra, but cannot find an answer in any documentation to the following.</p>
  
  <p>I need to query ranges across a deep hierarchy. I have determined that the easiest way to represent the hierarchy is to have each level as a column. For example:</p>
  
  <pre><code>Origin           Manufacturer    Price    ID
  Europe.Germany   VW Group.Audi   20000    1
  Europe.Germany   VW Group.Porshe 21000    2
  Europe.Germany   BMW             19000    3
  </code></pre>
  
  <p>Here is a pseudo SQL example:</p>
  
  <pre><code>SELECT ID FROM CompositeTable WHERE (Origin STARTS WITH 'Europe')
  AND (Manufacturer STARTS WITH 'VW Group' AND IS NOT 'VW Group.Porshe' OR IS 'BMW')
  AND (Price BETWEEN 18000 AND 22000)
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>ID = [1, 3]
  </code></pre>
  
  <p>Can Cassandra perform this type of search across a composite index?</p>