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
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