title: Accumulo: How to index data for efficient queries?
body: <p>I need an efficient indexing schema to store alerts. Each alert has the following attributes:</p>
  
  <ul>
  <li>alertId</li>
  <li>timestamp</li>
  <li>type</li>
  <li>location</li>
  </ul>
  
  <p>I need to perform the following queries:</p>
  
  <ul>
  <li>How many alerts were on created in a defined date range?</li>
  <li>How many alerts of type X were created in a defined date range?</li>
  <li>How many alerts from location Y were created in a defined date range?</li>
  </ul>
  
  <p>My initial thought was to index a follows:</p>
  
  <pre><code>ROWID -&gt; alertId_timestamp,
  CF -&gt; attribute (type, location),
  CQ -&gt; value
  </code></pre>
  
  <p>However I think the query performance will be poor for my #2 &amp; #3 query use cases. How should I index my data?</p>