Show Index in Apache Phoenix

Question

I have Apache Phoenix 4.4 installed on HDP 2.3. Does anyone know how to view all indexes created on a table? Like MySQL has show index on table_name query. I couldn't find help on the documentation here.

Answer 1

In case you are using sqlline, which is, by default, bundled with Phoenix, you should be able to see existing indices by issuing command

!indexes ${schema_name}.${table_name}