RE: Hive bug in Partition

2012-10-15 Thread Chalcy Raja
, Chalcy From: Viral Bajaria [mailto:viral.baja...@gmail.com] Sent: Friday, October 12, 2012 5:24 PM To: user@hive.apache.org Subject: Re: Hive bug in Partition Not sure about this bug and don't have a test table right now on which I can try this or rather don't want to try this on a tabl

Re: Hive bug in Partition

2012-10-12 Thread Viral Bajaria
Not sure about this bug and don't have a test table right now on which I can try this or rather don't want to try this on a table :-) Did you lose the entire table ? If your HDFS trash policy is the default 24 hours, you should be able to recover and run a quick load command to restore the metadat

Hive bug in Partition

2012-10-12 Thread Chalcy Raja
We are using Hive 8 as part of CDH4.0.1. We noticed a bug in Partition. Say if my hive table is partitioned by mydate and to drop a partition I mistype the name of the partition, like, Alter table mytable drop partition (yourdate='2012-09-10') , this will drop all the mytable paritions (mydate