Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

4.9 KiB

Raw Permalink Blame History

REGISTER INDEX TABLE

Function

This command is used to register an index table with the primary table.

Syntax

REGISTER INDEX TABLE indextable_name ON db_name.maintable_name;

Parameter Description

**Table 1** REFRESH INDEX TABLE parameters
Parameter	Description
db_name	Database name. If this parameter is not specified, the current database is selected.
indextable_name	Index table name.
maintable_name	Primary table name.

Precautions

Before running this command, run REFRESH TABLE to register the primary table and secondary index table with the Hive metastore.

Examples

REGISTER INDEX TABLE productNameIndexTable ON productdb.productSalesTable;

System Response

By running this command, the index table will be registered to the primary table.

Parent topic: DDL

4.9 KiB Raw Permalink Blame History