title: Cassandra - filter rows based on a range
body: <p>Using <code>cassandra</code> and <code>spark</code> and <code>datastax</code>'s <code>spark-cassandra-connector</code>.</p>
  
  <p>In the <a href="https://github.com/datastax/spark-cassandra-connector/blob/master/doc/3_selection.md" rel="nofollow">spark-cassandra-connector</a> it support gives such filter example:</p>
  
  <pre><code>sc.cassandraTable("test", "cars").select("id", "model").where("color = ?", "black").toArray.foreach(println)
  </code></pre>
  
  <p>Basically it filters the <code>color</code> column with <code>black</code>. However, can I filter the row based on a range? Like I want to filter the <code>range</code> column which is a <code>long</code> type and the <code>range</code> falls between <code>100000</code> and <code>200000</code> ? Does <code>cql</code> support such a range filter? </p>