Teradataは、次のデータ型の列へのシュレッディング処理をサポートします。
CHAR | VARCHAR | CHARACTER(n) CHARACTER SET GRAPHIC |
VARCHAR(n) CHARACTER SET GRAPHIC | CLOB | BYTE |
VARBYTE | BLOB | BYTEINT |
SMALLINT | INTEGER | BIGINT |
FLOAT (該当する場合、精度がサポートされるデータ型の場合) | DECIMAL | NUMBER |
DATE | TIME | TIME WITH TIME ZONE |
TIMESTAMP | TIMESTAMP WITH TIME ZONE | INTERVAL YEAR |
INTERVAL YEAR TO MONTH | INTERVAL MONTH | INTERVAL DAY |
INTERVAL DAY TO HOUR | INTERVAL DAY TO MINUTE | INTERVAL DAY TO SECOND |
INTERVAL HOUR | INTERVAL HOUR TO MINUTE | INTERVAL HOUR TO SECOND |
INTERVAL MINUTE | INTERVAL MINUTE TO SECOND | INTERVAL SECOND |
PERIOD (DATE) | PERIOD (TIME) | PERIOD (TIME WITH TIME ZONE) |
PERIOD (TIMESTAMP) | PERIOD (TIMESTAMP WITH TIME ZONE) | XML |
JSON |