详述】问题详细描述
3.2.2版本存算分离模式下创建表指定partition_live_number参数后 show create table 不显示. 但是存算一体模式没问题. 这个在存算分离模式下不能使用吗?
【背景】做过哪些操作？
按照文档创建表语句: CREATE TABLE t_recharge_detail2 ( id bigint, user_id bigint, recharge_money decimal(32,2), city varchar(20) not null, dt varchar(20) not null ) DUPLICATE KEY(id) PARTITION BY (dt,city) DISTRIBUTED BY HASH( id ) PROPERTIES( “partition_live_number” = “3” );
然后show表结构没看到partition_live_number
mysql> show create table t_recharge_detail2;
±-------------------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±-------------------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t_recharge_detail2 | CREATE TABLE t_recharge_detail2 (
id bigint(20) NULL COMMENT “”,
user_id bigint(20) NULL COMMENT “”,
recharge_money decimal128(32, 2) NULL COMMENT “”,
city varchar(20) NOT NULL COMMENT “”,
dt varchar(20) NOT NULL COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY( id )
COMMENT “OLAP”
PARTITION BY ( dt , city )
DISTRIBUTED BY HASH( id )
PROPERTIES (
“replication_num” = “1”,
“datacache.enable” = “true”,
“storage_volume” = “oss_volume”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
); |
查看information_schema.tables_config也没有相关参数输出
mysql> select * from information_schema.tables_config where TABLE_NAME = ‘t_recharge_detail2’;
±-------------±-------------------±-------------±------------±------------±--------------±---------------±----------------±------------------±---------±--------------------------------------------------------------------------------------------------------------------------------------------------------------±---------+
| TABLE_SCHEMA | TABLE_NAME | TABLE_ENGINE | TABLE_MODEL | PRIMARY_KEY | PARTITION_KEY | DISTRIBUTE_KEY | DISTRIBUTE_TYPE | DISTRIBUTE_BUCKET | SORT_KEY | PROPERTIES | TABLE_ID |
±-------------±-------------------±-------------±------------±------------±--------------±---------------±----------------±------------------±---------±--------------------------------------------------------------------------------------------------------------------------------------------------------------±---------+
| bench | t_recharge_detail2 | CLOUD_NATIVE | DUP_KEYS | | | id | HASH | 0 | id | {“enable_persistent_index”:“false”,“datacache.enable”:“true”,“enable_async_write_back”:“false”,“replication_num”:“1”,“compression”:“LZ4”,“in_memory”:“false”} | 16567 |
±-------------±-------------------±-------------±------------±------------±--------------±---------------±----------------±------------------±---------±--------------------------------------------------------------------------------------------------------------------------------------------------------------±---------+
1 row in set (0.01 sec)
【业务影响】
不清楚是否生效
【是否存算分离】
做了存算分离 FE + CN 模式
【StarRocks版本】
3,2,2