Re: Drop an HBase backed table

2012-12-09 Thread kulkarni.swar...@gmail.com
Hi David, DROP TABLE is the right command to drop a table. You can look at the hive logs under "/tmp//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 wro

Drop an HBase backed table

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