[HCATALOG-144] DROP DATABASE CASCADE doesn't drop HBase tables

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.3
• Component/s: storage handlers
• Labels: hbase
• Assignee: Vandana Ayyalasomayajula
• Reporter: David Capwell
• Created: 27/Oct/11 22:08
• Updated: 01/Nov/11 23:58

Description

#!bin/bash -x
DB="hbase1319752566842_test"

/home/y/bin/hcat -e "CREATE DATABASE IF NOT EXISTS $DB LOCATION '/tmp/hbase'"
/home/y/bin/hcat -e "USE $DB ;
CREATE TABLE TableDataProvider_73851724954245847 (key int, value string)
STORED BY 'org.apache.hcatalog.hbase.HBaseHCatStorageHandler'
TBLPROPERTIES(
'hbase.columns.mapping'=':key,cf:value',
'hcat.osd'='org.apache.hcatalog.hbase.HBaseOutputStorageDriver',
'hcat.isd'='org.apache.hcatalog.hbase.HBaseInputStorageDriver');"
/home/y/bin/hcat -e "DROP DATABASE IF EXISTS $DB CASCADE"

DB is deleted in HCat
hcat -e "SHOW DATABASES;" | grep hbase1319752566842_test
Hive history file=/tmp/dcapwell/hive_job_log_dcapwell_201110272209_1344228397.txt
OK
Time taken: 1.671 seconds

But not in HBase
hbase> list
...
hbase1319752566842_test.TableDataProvider_73851724954245847
...

Sub-Tasks

• DROP Table doesn't drop HBase tables: Resolved