Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Drop an HBase backed table

Copy link to this message
Re: Drop an HBase backed table
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