【详述】问题详细描述
创建表指定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 模式指定OSS为远程存储
【StarRocks版本】
3,2,2
【集群规模】
1fe + 2 cn
【机器信息】CPU虚拟核/内存/网卡，例如：32C/64G/万兆