[Bug] (good first issue) In a cluster with only SSD storage, the CREATE TABLE LIKE command fails

[deardeng]

Search before asking

• I had searched in the issues and found no similar issues.

Version

doris-2.1.6

What's Wrong?

In a cluster that only has SSD storage, creating a table not set storage medium, create table succeeds, but the output of the SHOW CREATE TABLE command incorrectly shows the storage medium as HDD, and execute create table t4 like t3 will failed

What You Expected?

1. create table t4 like t3 success
2. show create table t3 show t3 storage medium is ssd

How to Reproduce?

1. Deploy Doris with the disk medium set to SSD
2. Create a table using SQL create table t3(a bigint, b int) engine=olap uniqueKEY(a) distributed by hash (a) buckets 1 properties( "replication_num" = "1");
3. show create table t3 , it will display table medium HHD
4. create table t4 like t3 will failed

Anything Else?

HOW to fix:

1. When calling olapTable.setStorageMedium, also store the isSpecialStorageMedium flag
2. Add isSpecialStorageMedium to the properties stored in TableProperty
3. In the attribute table for ALTER TABLE, set the isSpecialStorageMedium to true
   at last, add a docker regression case for test it

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct