注册

mysql分区表迁移到dm8数据库报错显示无效列

叾屾 2024/10/18 431 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:
这个sql迁移的时候报错,我这边的定位到的报错语句是PARTITION BY RANGE("TO_DAYS(""GET_TIME"")"是不是达梦数据库不支持这个时间类型的分区
CREATE TABLE "NRMM_MACHINE"."VEHICLE_MONITOR_DATA"
(
"XH" VARCHAR(15) DEFAULT '' NOT NULL,
"GET_TIME" TIMESTAMP(0) NOT NULL,
"HPHM" VARCHAR(15) NULL,
"CLBH" VARCHAR(255) NULL,
"VAL_01" VARCHAR(63) NULL,
"VAL_02" VARCHAR(63) NULL,
"VAL_03" VARCHAR(63) NULL,
"VAL_04" VARCHAR(63) NULL,
"VAL_05" VARCHAR(63) NULL,
"VAL_06" VARCHAR(63) NULL,
"VAL_07" VARCHAR(63) NULL,
"VAL_08" VARCHAR(63) NULL,
"VAL_09" VARCHAR(63) NULL,
"VAL_10" VARCHAR(63) NULL,
"VAL_11" VARCHAR(63) NULL,
"VAL_12" VARCHAR(63) NULL,
"VAL_13" VARCHAR(63) NULL,
"VAL_14" VARCHAR(63) NULL,
"VAL_15" VARCHAR(63) NULL,
"VAL_16" VARCHAR(63) NULL,
"VAL_17" VARCHAR(63) NULL,
"VAL_18" VARCHAR(63) NULL,
"VAL_19" VARCHAR(63) NULL,
"VAL_20" VARCHAR(63) NULL,
"VAL_21" VARCHAR(63) NULL,
"VAL_22" VARCHAR(63) NULL,
"VAL_23" VARCHAR(63) NULL,
"VAL_24" VARCHAR(63) NULL,
"VAL_25" VARCHAR(63) NULL,
"VAL_26" VARCHAR(63) NULL,
"VAL_27" VARCHAR(63) NULL,
"VAL_28" VARCHAR(63) NULL,
"VAL_29" VARCHAR(63) NULL,
"VAL_30" VARCHAR(63) NULL,
"VAL_31" VARCHAR(63) NULL,
"VAL_32" VARCHAR(63) NULL,
"VAL_33" VARCHAR(63) NULL,
"VAL_34" VARCHAR(63) NULL,
"VAL_35" VARCHAR(63) NULL,
"VAL_36" VARCHAR(63) NULL,
"VAL_37" VARCHAR(63) NULL,
"VAL_38" VARCHAR(63) NULL,
"VAL_39" VARCHAR(63) NULL,
"VAL_40" VARCHAR(63) NULL,
"VAL_41" VARCHAR(63) NULL,
"VAL_42" VARCHAR(63) NULL,
"VAL_43" VARCHAR(63) NULL,
"VAL_44" VARCHAR(63) NULL,
"VAL_45" VARCHAR(63) NULL,
"VAL_46" VARCHAR(63) NULL,
"VAL_47" VARCHAR(63) NULL,
"VAL_48" VARCHAR(63) NULL,
"VAL_49" VARCHAR(63) NULL,
"VAL_50" VARCHAR(63) NULL,
"VAL_51" VARCHAR(63) NULL,
"VAL_52" VARCHAR(63) NULL,
"VAL_53" VARCHAR(63) NULL,
"VAL_54" VARCHAR(63) NULL,
"VAL_55" VARCHAR(63) NULL,
"VAL_56" VARCHAR(63) NULL,
"VAL_57" VARCHAR(63) NULL,
"VAL_58" VARCHAR(63) NULL,
"VAL_59" VARCHAR(63) NULL,
"VAL_60" VARCHAR(63) NULL,
"VAL_61" VARCHAR(63) NULL,
"VAL_62" VARCHAR(63) NULL,
"VAL_63" VARCHAR(63) NULL,
"VAL_64" VARCHAR(63) NULL,
"VAL_65" VARCHAR(63) NULL,
"VAL_66" VARCHAR(63) NULL,
"VAL_67" VARCHAR(63) NULL,
"VAL_68" VARCHAR(63) NULL,
"VAL_69" VARCHAR(63) NULL,
"VAL_70" VARCHAR(63) NULL,
"VAL_71" VARCHAR(63) NULL,
"VAL_72" VARCHAR(63) NULL,
"VAL_73" VARCHAR(63) NULL,
"VAL_74" VARCHAR(63) NULL,
"VAL_75" VARCHAR(63) NULL,
"VAL_76" VARCHAR(63) NULL,
"VAL_77" VARCHAR(63) NULL,
"VAL_78" VARCHAR(63) NULL,
"VAL_79" VARCHAR(63) NULL,
"VAL_80" VARCHAR(63) NULL,
"CHECK_FLAG" CHAR(1) DEFAULT '1' NULL,
"XAIS" DECIMAL(10,6) NULL,
"YAIS" DECIMAL(10,6) NULL,
"UPDATE_TIME" TIMESTAMP(0) NULL,
"VAL_81" VARCHAR(63) NULL,
"VAL_82" VARCHAR(63) NULL,
"VAL_83" VARCHAR(63) NULL,
"VAL_84" VARCHAR(63) NULL,
"VAL_85" VARCHAR(63) NULL,
"VAL_86" VARCHAR(63) NULL,
"VAL_87" VARCHAR(63) NULL,
"VAL_88" VARCHAR(63) NULL,
"VAL_89" VARCHAR(63) NULL,
"VAL_90" VARCHAR(63) NULL,
"VAL_123" VARCHAR(64) NULL,
"VAL_126" VARCHAR(64) NULL,
"VAL_128" VARCHAR(64) NULL,
"VAL_156" VARCHAR(64) NULL,
"DWZT" VARCHAR(8) NULL,
"CSBH" VARCHAR(8) NULL
)PARTITION BY RANGE("TO_DAYS(""GET_TIME"")")
(PARTITION "P_MONITOR_201608" VALUES LESS THAN (736573)
,PARTITION "P_MONITOR_201609" VALUES LESS THAN (736603)
,PARTITION "P_MONITOR_201610" VALUES LESS THAN (736634)
,PARTITION "P_MONITOR_201611" VALUES LESS THAN (736664)
,PARTITION "P_MONITOR_201612" VALUES LESS THAN (736695)
,PARTITION "P_MONITOR_201701" VALUES LESS THAN (736726)
,PARTITION "P_MONITOR_201702" VALUES LESS THAN (736754)
,PARTITION "P_MONITOR_201703" VALUES LESS THAN (736785)
,PARTITION "P_MONITOR_201704" VALUES LESS THAN (736815)
,PARTITION "P_MONITOR_201705" VALUES LESS THAN (736846)
,PARTITION "P_MONITOR_201706" VALUES LESS THAN (736876)
,PARTITION "P_MONITOR_201707" VALUES LESS THAN (736907)
,PARTITION "P_MONITOR_201708" VALUES LESS THAN (736938)
,PARTITION "P_MONITOR_201709" VALUES LESS THAN (736968)
,PARTITION "P_MONITOR_201710" VALUES LESS THAN (736999)
,PARTITION "P_MONITOR_201711" VALUES LESS THAN (737029)
,PARTITION "P_MONITOR_201712" VALUES LESS THAN (737060)
,PARTITION "P_MONITOR_201801" VALUES LESS THAN (737091)
,PARTITION "P_MONITOR_201802" VALUES LESS THAN (737119)
,PARTITION "P_MONITOR_201803" VALUES LESS THAN (737150)
,PARTITION "P_MONITOR_201804" VALUES LESS THAN (737180)
,PARTITION "P_MONITOR_201805" VALUES LESS THAN (737211)
,PARTITION "P_MONITOR_201806" VALUES LESS THAN (737241)
,PARTITION "P_MONITOR_201807" VALUES LESS THAN (737272)
,PARTITION "P_MONITOR_201808" VALUES LESS THAN (737303)
,PARTITION "P_MONITOR_201809" VALUES LESS THAN (737333)
,PARTITION "P_MONITOR_201810" VALUES LESS THAN (737364)
,PARTITION "P_MONITOR_201811" VALUES LESS THAN (737394)
,PARTITION "P_MONITOR_201812" VALUES LESS THAN (737425)
,PARTITION "p0" VALUES LESS THAN (738156)
,PARTITION "P_MONITOR_202302" VALUES LESS THAN (738943)
,PARTITION "P_MONITOR_202303" VALUES LESS THAN (738975)
)

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