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
