Command to see the indexes of a table in Hive

Question

Can anyone suugest what command can be used to see the indexes of a  table in Hive?

Answer 1

Hey,

The command you can use to see the indexes of a table is written below:

SHOW INDEX ON table_name

This command will list all the indexes on any of the columns with this table_name command.