starrocks mysql cli doesn't show table metadata completely, lacking sort_order field

[zeddit]

is there a command to show the metadata starrocks load for a table?

I have create a table in trino with

trino> CREATE TABLE iceberg.sort_order_exp.csdate1001 (
    ->     date date
    -> )
    -> WITH (
    ->     format = 'PARQUET',
    ->     format_version = 2,
    ->     location = 's3a://test/csdate1001',
    ->     sorted_by = ARRAY['date']
    -> )
    -> ;

while in starrocks I check the table with

mysql> show create table csdate1001;
+------------+-------------------------------------------------------------------------------------------------------------+
| Table      | Create Table                                                                                                |
+------------+-------------------------------------------------------------------------------------------------------------+
| csdate1001 | CREATE TABLE `csdate1001` (
  `date` date DEFAULT NULL
)
PROPERTIES ("location" = "s3a://test/csdate1001"); |
+------------+-------------------------------------------------------------------------------------------------------------+
1 row in set (1.10 sec)

it seems to lost the sort_order property.

However, I have checked that sort_order is worked but not displayed in starrocks. When I using INSERT OVERWRITE csdate1001 SELECT * FROM csdate1001 , the final result is a sorted one.

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!