Major Description
The blew SQL will be executed successfully, the name of data tables is incorrectly inputted that the parent table has the same name with index tables.
DROP INDEX INDEX_TABLE_X on INDEX_TABLE_X;
Some regions will not online and some queries will not normally execute after executing above SQL. Everything will be ok unless manually delete dirty metadata information in SYSTEM.CATALOG table.