Oracle与MRS Hudi字段类型映射
Migration会根据源端的字段类型按默认规则转换成目的端字段类型,并以此完成自动建表和实时同步。
字段类型映射规则
当源端为Oracle,目的端为Hudi时,支持的字段类型请参见下表,以确保数据完整同步到目的端。
|
数据类型(Oracle) |
数据类型(Hudi) |
|---|---|
|
char |
STRING |
|
varchar |
STRING |
|
varchar2 |
STRING |
|
nchar |
STRING |
|
nvarchar2 |
STRING |
|
raw |
STRING |
|
number |
STRING/DECIMAL |
|
decimal |
STRING/DECIMAL |
|
float |
FLOAT |
|
binary_float |
FLOAT |
|
binary_double |
DOUBLE |
|
date |
TIMESTAMP |
|
timestamp |
TIMESTAMP |
|
timestamp with time zone |
STRING |
|
timestamp with local time zone |
STRING |