データ型マッピング
データ型のマッピング
本製品 は、データソースの型を、スキーマで使用可能な対応するデータ型にマッピングします。以下のテーブルはこれらのマッピングを説明します。
ARRAY | SYSUDTLIB.MyArrayName |
BYTE | BYTE |
BLOB | BLOB |
CHAR | CHAR |
DATASET | DATASET STORAGE FORMAT AVRO |
DATE | DATE |
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TIME WITH TIME ZONE | TIME WITH TIME ZONE |
TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE |
ST_Geometry | SYSUDTLIB.ST_GEOMETRY |
MBR | SYSUDTLIB.MBR |
INTERVAL YEAR | INTERVAL YEAR |
INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
INTERVAL MONTH | INTERVAL MONTH |
INTERVAL DAY | INTERVAL DAY |
INTERVAL DAY TO HOUR | INTERVAL DAY TO HOUR |
INTERVAL DAY TO MINUTE | INTERVAL DAY TO MINUTE |
INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND |
INTERVAL HOUR | INTERVAL HOUR |
INTERVAL HOUR TO MINUTE | INTERVAL HOUR TO MINUTE |
INTERVAL HOUR TO SECOND | INTERVAL HOUR TO SECOND |
INTERVAL MINUTE | INTERVAL MINUTE |
INTERVAL MINUTE TO SECOND | INTERVAL MINUTE TO SECOND |
INTERVAL SECOND | INTERVAL SECOND |
JSON | JSON |
BYTEINT | BYTEINT |
SMALLINT | SMALLINT |
INTEGER | INT |
BIGINT | BIGINT |
DECIMAL | DECIMAL |
NUMERIC | DECIMAL |
FLOAT | FLOAT |
REAL | FLOAT |
DOUBLE PRECISION | FLOAT |
NUMBER | NUMBER |
PERIOD(DATE) | PERIOD(DATE) |
PERIOD(TIME) | PERIOD(TIME) |
XML | XML |