title: CQL: Unable to Null Check in "Where" Clause
body: <p>Try to return all rows where a specific field is null or not null.  </p>
  
  <pre><code>select * from ADDRESS where addr1 = null;  
  </code></pre>
  
  <p>or  </p>
  
  <pre><code>select * from ADDRESS where addr1 = 'NULL';  
  </code></pre>
  
  <p>addr1 can be a boolean or text field.</p>
  
  <p>I've tried <code>!= null</code>, <code>is null</code>, <code>&lt;&gt; null</code>, and <code>isnull(addr1, 'NULL')</code></p>
  
  <p>but I get </p>
  
  <pre><code>no viable alternative at input '='
  </code></pre>
  
  <p>or </p>
  
  <pre><code>no index columns present in by-columns clause with "equals' operator"
  </code></pre>
  
  <p>Using Cassandra 1.1.1 &amp; Java 1.7_05</p>