Hi Sam
Hive table details are on he metastore db and would be gone only if that entry
is deleted. That is on a drop command normally.
Hive table will be there even if there is no data corresponding to the storage
location. Infact it'd be there even if the store location doesn't exists.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Sam Darwin
Date: Sun, 9 Sep 2012 12:49:14
To:
Reply-To: user@hive.apache.org
Subject: hive table missing
Hi,
We are seeing a hive table is gone unexpectedly.
I suspect that this must have been caused by someone somewhere issuing
a "drop table" command.But it's unclear.
My question is : are there other known ways for hive to lose a table
besides "drop table". For example, let's say that the underlying
hdfs file system is having some trouble, it is unreachable for a few
minutes, maybe hive could think "I don't see the hdfs files I need for
this table. I will assume the user wishes to delete the table."
And then it proceeds to cause an automatic deletion. That
would certainly be terrible. :-) But I hope you see what I
am getting at..Other ways which might cause a table to be lost,
besides someone typing in the "drop table" command in a hive session.
Thanks,
Sam