This command is used to list all secondary index tables in the CarbonData table.
SHOW INDEXES ON db_name.table_name;
Parameter |
Description |
|---|---|
db_name |
Database name. It consists of letters, digits, and special characters (_). |
table_name |
Name of the database table. It consists of letters, digits, and special characters (_). |
db_name is optional.
create table productdb.productSalesTable(id int,price int,productName string,city string) stored as carbondata;
CREATE INDEX productNameIndexTable on table productdb.productSalesTable (productName,city) as 'carbondata' ;
SHOW INDEXES ON productdb.productSalesTable;
All index tables and corresponding index columns in a given CarbonData table will be listed.