分布式数据库中间件 DDM-拆分算法概述:DDL拆分函数的数据类型

时间：2025-02-24 20:32:05

分布式数据库中间件 DDM DDL

DDM 的拆分函数对各数据类型对支持情况有所不同，下表显示了DDM 拆分函数对各种数据类型的支持情况。

表2 DDM 拆分函数对各种数据类型的支持情况
拆分算法	TINYINT	SMALLINT	MEDIUMINT	INTEGER	INT	BIGINT	CHAR	VARCHAR	DATE	DATETIME	TIMESTAMP	OTHERS
MOD_HASH	√	√	√	√	√	√	√	√	╳	╳	╳	╳
MOD_HASH_CI	√	√	√	√	√	√	√	√	╳	╳	╳	╳
HASH	√	√	√	√	√	√	√	√	╳	╳	╳	╳
RANGE	√	√	√	√	√	√	╳	╳	╳	╳	╳	╳
RIGHT_SHIFT	√	√	√	√	√	√	╳	╳	╳	╳	╳	╳
YYYYMM	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
YYYYDD	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
YYYYWEEK	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
MM	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
DD	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
MMDD	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳
WEEK	╳	╳	╳	╳	╳	╳	╳	╳	√	√	√	╳