Drop an index from a Hive table

Question

Hi Team,

I have created an index in the hive table. Now I don't need that index. How can drop that index?

Answer 1

Hi@akhtar,

You can drop an index from the hive table as well. You need to use the below command to do so.

$ DROP INDEX index_salary ON table_name;