Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ Hudi CALL COMMAND Syntax/ CHANGE_TABLE
Updated on 2024-10-09 GMT+08:00
View PDF
Share

CHANGE_TABLE

The Hudi CALL COMMAND syntax is available in MRS 3.2.0 and later versions.

Function

Modifies 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: Hudi CALL COMMAND Syntax