title: Operate with Apache Cassandra list
body: <p>I have next table structure in Cassandra:</p>
  
  <pre><code>CREATE TABLE statistics (
    clientId VARCHAR,
    hits LIST&lt;text&gt;,
    PRIMARY KEY (clientId)
  );
  
  INSERT INTO statistics(clientId, hits) VALUES ('clientId', [{'referer': 'http://example.com/asd', 'type': 'PAGE', 'page': '{"title": "Page title"}'}, {'referer': 'http://example.com/dsa', 'type': 'EVENT', 'event': '{"title": "Click on big button"}'}, {'referer': 'http://example.com/fgd', 'type': 'PAGE', 'page': '{"title": "Page title second"}'}]);
  </code></pre>
  
  <p>I want to select count of hits with type = 'PAGE'.</p>
  
  <p>How can I do it ?</p>