title: How Hive reads data even after dropping from hdfs?
body: <p>I have an external table in hive and pointing to HDFS location. By mistake I have ran the job to load the data into HDFS two times.</p>
  
  <p>Even after deleting the duplicate file from HDFS hive is showing the data count two times(i.e. including deleted duplicate data file count).</p>
  
  <blockquote>
    <p>select count(*) from tbl_name -- returns double time</p>
  </blockquote>
  
  <p>But ,</p>
  
  <blockquote>
    <p>select count(col_name) from tbl_name -- returns actual count.</p>
  </blockquote>
  
  <p>Same table when I tried from Impala after </p>
  
  <blockquote>
    <p>INVALIDATE METADATA</p>
  </blockquote>
  
  <p>I could see only data count which is available in HDFS(not duplicate).</p>
  
  <p>How can hive give count as double even after deleting from physical location(hdfs) , does it read from statistics?</p>