title: Hive files on hdfs not being deleted when managed (not external) table is dropped
body: <p>When I drop a managed table from the Hive interactive command line, the underlying files that were created on hdfs in <code>/user/hive/warehouse/&lt;databasename&gt;.db</code> still exist.  This causes issues when I recreate the table with the same name and try to do </p>
  
  <pre><code>INSERT INTO TABLE 
  </code></pre>
  
  <p>as it still contains the data that I loaded into those partitions (dt and hr partitions in my case) in my initial go around.  Only if I use </p>
  
  <pre><code>INSERT OVERWRITE TABLE
  </code></pre>
  
  <p>will it then finally load the data properly, but my ETL needs to use <code>INSERT INTO TABLE</code>.  </p>
  
  <p>Any ideas?  I'm about ready to just create the same table but with a different name, or just go in and delete the stuff on hdfs but I'm worried if that'll break the metastore or something.  Lastly, I'm positive it is a managed table and not external.</p>