Sink supports automatically setting the number of buckets based on table size when create table

[beryllw]

When I sync multiple MySQL tables to Paimon, the tables have different sizes. Some sinks support using buckets to distribute data, and different tables need different bucket settings. We can use the source data's metadata to automatically set the number of buckets for the sink tables based on their sizes when create sink table.

select DATA_LENGTH from information_schema.tables where  table_schema='db1' and table_name='table1';

Could we support table metadata in the CreateTableEvent? like TABLE_ROWS, AVG_ROW_LENGTH, DATA_LENGTH, and MAX_DATA_LENGTH.
This would allow the sink to automatically set the number of buckets based on the table size when creating the table using the CreateTableEvent.

[beryllw]

Using the source table's data size to set the number of buckets for the sink table has two issues:

1. Transformations may invalidate the statistics.
2. The data size of the source table may grow over time.

Supporting independent table property settings for the sink table might be a better approach.

[beryllw]

Solved by transform table-optis.