Hive, mail # user - Drop an HBase backed table

Drop an HBase backed table

David Koch 2012-12-10, 00:06

Hello,

How can I drop a Hive table which was created using "CREATE EXTERNAL
TABLE..."? I tried "DROP TABLE <table_name>;" but the shell hangs. The
underlying HBase table should not be deleted. I am using Hive 0.9

Thank you,

/David

Re: Drop an HBase backed table

kulkarni.swarnim@...) 2012-12-10, 00:30

Hi David,

DROP TABLE <table> is the right command to drop a table. You can look at
the hive logs under "/tmp/<user>/hive.log" to see why your shell is
hanging. With dropping an EXTERNAL TABLE, you are guaranteed that the
underlying hbase table won't be touched.
On Sun, Dec 9, 2012 at 6:06 PM, David Koch <[EMAIL PROTECTED]> wrote:

> Hello,
>
> How can I drop a Hive table which was created using "CREATE EXTERNAL
> TABLE..."? I tried "DROP TABLE <table_name>;" but the shell hangs. The
> underlying HBase table should not be deleted. I am using Hive 0.9
>
> Thank you,
>
> /David
>

--
Swarnim