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
