title: How to perform a simple select from HBase with criteria (Where clause)
body: <p>I have the following simple table I've created from the following source: <a href="https://hortonworks.com/hadoop-tutorial/introduction-apache-hbase-concepts-apache-phoenix-new-backup-restore-utility-hbase/#start-hbase" rel="nofollow noreferrer">https://hortonworks.com/hadoop-tutorial/introduction-apache-hbase-concepts-apache-phoenix-new-backup-restore-utility-hbase/#start-hbase</a></p>
  
  <p>using the following:</p>
  
  <pre><code>create 'driver_dangerous_event','events'
  put 'driver_dangerous_event','4','events:driverId','78'
  put 'driver_dangerous_event','4','events:driverName','Carl'
  put 'driver_dangerous_event','4','events:eventTime','2016-09-23 03:25:03.567'
  put 'driver_dangerous_event','4','events:eventType','Normal'
  put 'driver_dangerous_event','4','events:latitudeColumn','37.484938'
  put 'driver_dangerous_event','4','events:longitudeColumn','-119.966284'
  put 'driver_dangerous_event','4','events:routeId','845'
  put 'driver_dangerous_event','4','events:routeName','Santa Clara to San Diego'
  put 'driver_dangerous_event','4','events:truckId','637'
  </code></pre>
  
  <p>I need to query this row but using a where filter (for future use), I have a rest api or thrift api running on my server.</p>
  
  <p>I tried using rest api but failed to do it, is it possible?</p>
  
  <p>also I tried using this nuget: <a href="https://hbasenet.codeplex.com/releases/view/133288" rel="nofollow noreferrer">https://hbasenet.codeplex.com/releases/view/133288</a> but I can't understand how to filter the data with where clause, I can only select a specific row:</p>
  
  <pre><code>Hbase.Client c = new Hbase.Client(serverHostName, port, 10000);
  var res = c.Scan&lt;Driver&gt;("driver_dangerous_event", "events", "1");
  </code></pre>
  
  <p><strong>Is there any option to do a simple filtered query with REST api/ Thrift API/ some other C# library?</strong></p>