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 |