注册

如何通过达梦8系统字典表获取子表分区列信息

Clark 2023/09/18 636 1 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:Dm8
【操作系统】:win10
【CPU】:
【问题描述】*:
1、分区表DDL语句:

CREATE TABLE "DMHR"."SALES"
(
"SALES_ID" INT,
"SALEMAN" CHAR(20),
"SALEDATE" DATETIME(6),
"CITY" CHAR(10))
PARTITION BY LIST("CITY")
SUBPARTITION BY RANGE("SALEDATE") SUBPARTITION TEMPLATE
(
SUBPARTITION  "P11"  VALUES LESS THAN(DATETIME'2012-04-01 00:00:00') STORAGE(ON "MAIN"),
SUBPARTITION  "P12"  VALUES LESS THAN(DATETIME'2012-07-01 00:00:00') STORAGE(ON "MAIN"),
SUBPARTITION  "P13"  VALUES LESS THAN(DATETIME'2012-10-01 00:00:00') STORAGE(ON "MAIN"),
SUBPARTITION  "P14"  VALUES EQU OR LESS THAN(MAXVALUE) STORAGE(ON "MAIN")
)
(
PARTITION  "P1"  VALUES('北京      ','天津      ')   STORAGE(ON "MAIN", CLUSTERBTR) (
SUBPARTITION  "P11_1"  VALUES LESS THAN(DATETIME'2012-10-01 00:00:00') STORAGE(ON "MAIN", CLUSTERBTR) ,
SUBPARTITION  "P11_2"  VALUES EQU OR LESS THAN(MAXVALUE) STORAGE(ON "MAIN", CLUSTERBTR) 
)
,
PARTITION  "P2"  VALUES('杭州      ','南京      ','上海      ')   STORAGE(ON "MAIN", CLUSTERBTR) ,
PARTITION  "P3"  VALUES(DEFAULT)   STORAGE(ON "MAIN", CLUSTERBTR) 
) STORAGE(HASHPARTMAP(1), ON "MAIN", CLUSTERBTR) ;

我想获取子分区表SALES_P1分区列信息,如下图:
1695018867529.png

回答 0
暂无回答
扫一扫
联系客服