title: Simple Hive query is empty
body: <p>I have a csv log file. After loading it into Hive using this sentence:</p>
  
  <pre><code>CREATE EXTERNAL TABLE iprange(id STRING, ip STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\,' STORED AS TEXTFILE LOCATION '/user/hadoop/expandediprange/';
  </code></pre>
  
  <p>I want to perfom a simple query like:</p>
  
  <pre><code>select * from iprange where ip="0.0.0.2";
  </code></pre>
  
  <p>But I get an empty result.</p>
  
  <p>I'm running Hive on HDFS, should I use HBase?
  My conclusion is that it's got something to do with the table size. Log file is 160 MB, and the generated table in Hive has 8 million rows. If I try to create myself a smaller file and load it to Hive it will work.</p>
  
  <p>Any idea of what is wrong?</p>
  
  <p>Edit: I forgot to say that it's running on Amazon Elastic MapReduce using a small instance.</p>