范围分区中如何根据手机号末尾分10个区

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】：windows
【CPU】: 8cpu
【问题描述】*：范围分区中如何根据手机号末尾分10个区;
有个人员信息表[RY_INFO]表有人员id[ry_id],手机号[phone]2个字段,
现在创建分区表，如何按照人员手机号尾数将数据放入不同的分区表中，分区表表达式如何创建，下面SQL语句是错误的：

CREATE TABLE "RY_INFO"
(
"RYID" BIGINT NOT NULL,
"PHONE" VARCHAR(16),
CLUSTER PRIMARY KEY("RYID"))
PARTITION BY RANGE ("PHONE") [INTERVAL (MOD(CAST(SUBSTR("PHONE", -1) AS INT), 10))] 
(
    PARTITION "RY_INFO_P0" VALUES  LESS THAN (1),
    PARTITION "RY_INFO_P1" VALUES  LESS THAN (2),
    PARTITION "RY_INFO_P2" VALUES  LESS THAN (3),
    PARTITION "RY_INFO_P3" VALUES  LESS THAN (4),
    PARTITION "RY_INFO_P4" VALUES  LESS THAN (5),
    PARTITION "RY_INFO_P5" VALUES  LESS THAN (6),
    PARTITION "RY_INFO_P6" VALUES  LESS THAN (7),
    PARTITION "RY_INFO_P7" VALUES  LESS THAN (8),
    PARTITION "RY_INFO_P8" VALUES  LESS THAN (9),
    PARTITION "RY_INFO_P9" VALUES  LESS THAN (MAXVALUE)
);

我这边测试了一种添加一个虚拟列作为辅助字段，是可行的，您可以试一下。

CREATE TABLE RY_INFO (RY_ID VARCHAR(20),PHONE VARCHAR(20),PHONE_TAIL_NUMBER CHAR(1) AS (SUBSTR(PHONE,-1))) PARTITION BY LIST(PHONE_TAIL_NUMBER) (
    PARTITION P0 VALUES ('0'),
    PARTITION P1 VALUES ('1'),
    PARTITION P2 VALUES ('2'),
    PARTITION P3 VALUES ('3'),
    PARTITION P4 VALUES ('4'),
    PARTITION P5 VALUES ('5'),
    PARTITION P6 VALUES ('6'),
    PARTITION P7 VALUES ('7'),
    PARTITION P8 VALUES ('8'),
    PARTITION P9 VALUES ('9')
);

INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('001','13013231831');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('002','13598384928');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('003','13398450834');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('004','13878574398');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('005','13493845340');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('006','13891823984');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('007','13289385435');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('008','13989845432');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('009','13983485956');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('010','13834590435');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('011','13982432423');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('012','13983458324');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('013','13989848232');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('014','13243728437');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('015','13989348582');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('016','13989283432');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('017','18983578470');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('018','18273498321');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('019','18293849327');
INSERT INTO RY_INFO (RY_ID,PHONE) VALUES ('020','13920340213');

SELECT * FROM RY_INFO_P7;