Yang, Tong 48706b7552 MRS COMP-LTS 320-lts.1 version

Reviewed-by: Kacur, Michal <michal.kacur@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2024-04-12 12:51:10 +00:00

4.7 KiB

Raw Permalink Blame History

CHANGE_TABLE

Function

The CHANGE_TABLE command can be used to modify the type and index of a table. Key parameters such as the type and index of Hudi tables cannot be modified. Therefore, this command is actually used to rewrite Hudi tables.

Syntax

call change_table(table => '[table_name]', hoodie.index.type => '[index_type]', hoodie.datasource.write.table.type => '[table_type]');

Parameter Description

**Table 1** Parameters
Parameter	Description
table_name	Name of the table to be modified
table_type	Type of the table to be modified
index_type	Type of the index to be modified

Precautions

If the index type to be modified has other configuration parameters, the parameters must be transferred to the SQL statement in the key =>'value' format.

For example, to change the index type to bucket, run the following command:

call change_table(table => 'hudi_table1', hoodie.index.type => 'BUCKET', hoodie.bucket.index.num.buckets => '3');

Example

call change_table(table => 'hudi_table1', hoodie.index.type => 'SIMPLE', hoodie.datasource.write.table.type => 'MERGE_ON_READ');

System Response

After the execution is complete, you can run the desc formatted table command to view the table properties.

Parent topic: CALL COMMAND

4.7 KiB Raw Permalink Blame History