Help Center> MapReduce Service> Component Operation Guide (Normal)> Using CarbonData (for MRS 3.x or Later)> CarbonData Syntax Reference> DML> SHOW SECONDARY INDEXES
Updated on 2022-09-22 GMT+08:00
View PDF

SHOW SECONDARY INDEXES

Function

This command is used to list all secondary index tables in the CarbonData table.

Syntax

SHOW INDEXES ON db_name.table_name;

Parameter Description

Table 1 SHOW SECONDARY INDEXES parameters

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 (_).

Precautions

db_name is optional.

Examples

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;

System Response

All index tables and corresponding index columns in a given CarbonData table will be listed.

Parent topic: DML