为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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分区列信息,如下图:
多级分区列用ALL_SUBPART_KEY_COLUMNS