How to create an index on Hive table

Question

Hi Guys,

I have created one table in Hive. I want to create an index on a table. How can I do that?

Answer 1

Hi@akhtar,

An Index is nothing but a pointer on a particular column of a table. Creating an index means creating a pointer on a particular column of a table. You can use the below command.

$ CREATE INDEX inedx_salary ON TABLE employee(salary) AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler';