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
| 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.
