Hi Guys, I managed to delete some data in HDFS by dropping a partitioned external Hive table. One explanation is that data resided in the 'warehouse' directory of Hive and that had something to do with? An alternative explanation may that my 'drop table' statement didn't delete the data but my follow up 'create table' statement with a different partition name did. Let me elaborate, files used to be in this directory structure: /user/hive/warehouse/<tablename>/year=2009
I created a new Hive external table with partition column name of 'yr' instead of 'year' pointing to the same base directory. Is it possible that this create statement deleted the data (highly doubt that)? Either case were unexpected to me! This is on Hive 1.0. Thanks, Peyman
