title: How can I select certain rows that the key starts with a prefix in Hive?
body: <p>A very simple question:</p>
  
  <p>I wanted to select all the rows that their keys have a certain prefix in Hive, but somehow it's not working.</p>
  
  <p>The queries I've tried:</p>
  
  <pre><code>select * from solr_json_history where dt='20170814' and hour='2147' and substr(`_root_`,1,9)='P10004232' limit 100;
  
  SELECT * FROM solr_json_history where dt='20170814' and hour='2147' and `_root_` like 'P19746284%' limit 100; 
  </code></pre>
  
  <p>My Hue editor just hangs there without returning anything.</p>
  
  <p>I've checked this time range there's data in my table by this query:</p>
  
  <pre><code>select * from solr_json_history where dt='20170814' and hour='2147' limit 15;
  </code></pre>
  
  <p>It's returning 15 records as expected.</p>
  
  <p>Any help please?</p>
  
  <p>Thanks a lot!</p>