support order by clause in show data statement.

[immutablecodes]

Feature request

Is your feature request related to a problem? Please describe.

I ususally have to find the biggest disk usage table in my work, this information usually can be found in show data statement, but the data type of 'size' field in the esult schema is formatted to human readable string, make it difficult to sort.

Describe the solution you'd like

1. change the data type of 'size' field in the esult schema from string to bigint.
2. support order by clause in show data statement.

Describe alternatives you've considered

Additional context

[wangsimo0]

good catch. for your scenario, maybe information_schema.tables will be easier to use.

[immutablecodes]

good catch. for your scenario, maybe information_schema.tables will be easier to use.

good point, but I can't found full information, can you show me how to construct the corresponding SQL? including with and without table to the show data statement.

[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!