You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Philippe Kernévez <pk...@octo.com> on 2015/01/27 18:10:49 UTC
Drop Index and table

Hi,

I have a table and an index (created on hive 0.13) I'm currently using hive
0.15.
I want to drop both.
When I drop my index I don't have any message :
hive -e "DROP INDEX INX_CampaignId ON xxx.campaigns;"

*OK*
*Time taken: 0.43 seconds*
Nothing special in the hive log.

When I drop the the table the command never stop and I have an infinite
loop in the hive logs :
2015-01-27 17:57:21,225 INFO  [pool-3-thread-1]: metastore.HiveMetaStore
(HiveMetaStore.java:logInfo(713)) - 1: source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,225 INFO  [pool-3-thread-1]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=hue ip=192.168.1.1
cmd=source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-64]: metastore.HiveMetaStore
(HiveMetaStore.java:logInfo(713)) - 4: source:192.168.1.1
drop_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-64]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=hue ip=192.168.1.1
cmd=source:192.168.1.1
drop_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-64]: metastore.HiveMetaStore
(HiveMetaStore.java:logInfo(713)) - 4: source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-64]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=hue ip=192.168.1.1
cmd=source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-1]: metastore.HiveMetaStore
(HiveMetaStore.java:logInfo(713)) - 1: source:192.168.1.1
drop_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,228 INFO  [pool-3-thread-1]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=hue ip=192.168.1.1
cmd=source:192.168.1.1
drop_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,229 INFO  [pool-3-thread-1]: metastore.HiveMetaStore
(HiveMetaStore.java:logInfo(713)) - 1: source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
2015-01-27 17:57:21,229 INFO  [pool-3-thread-1]: HiveMetaStore.audit
(HiveMetaStore.java:logAuditEvent(339)) - ugi=hue ip=192.168.1.1
cmd=source:192.168.1.1
get_index_by_name: db=xxx tbl=campaigns index=INX_CampaignId
etc....

Nothing related to that in the HDFS log.

Do you have an ID on how remove those table and index ?
Manually by stopping hive, removing the hive files and the delete
hive-metastore rows (tables INDEX_PARAMS, IDXS, TABLE_PARAMS, TBLS,
SORT_COLS and SDS) ?

Regards,
Philippe