一括取り込みデータベース

前へ次へ

TeradataソースとAmazon Redshiftターゲット

次の表は、TeradataソースとAmazon Redshiftターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。

Teradataソースデータ型	Amazon Redshiftターゲットデータ型
array	binary varying(1024000)
bigint	bigint
blob	binary varying(1024000)
byte(`precision`), 1 <= p <= 64000	binary varying(`size`), 1 <= size <= 64000
byteint	smallint
char(`size`), 1 <= size <= 64000	character varying(`size`), 4 <= size <= 65535
clob	character varying(65535)
date	date
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
float	double precision
integer	integer
interval day(`precision`) to hour, 1 <= p <= 4	character varying(`size`), 5 <= size <= 8
interval day(`precision`) to minute, 1 <= p <= 4	character varying(`size`), 8 <= size <= 11
interval day(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	character varying(`size`), 12 <= size <= 21
interval day(`precision`), 1 <= p <= 4	character varying(`size`), 2 <= size <= 5
interval hour(`precision`) to minute, 1 <= p <= 4	character varying(`size`), 5 <= size <= 8
interval hour(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	character varying(`size`), 9 <= size <= 18
interval hour(`precision`), 1 <= p <= 4	character varying(`size`), 2 <= size <= 5
interval minute(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	character varying(`size`), 9 <= size <= 18
interval minute(`precision`), 1 <= p <= 4	character varying(`size`), 2 <= size <= 5
interval month(`precision`), 1 <= p <= 4	character varying(`size`), 2 <= size <= 5
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6	character varying(`size`), 3 <= size <= 12
interval year(`precision`) to month, 1 <= p <= 4	character varying(`size`), 5 <= size <= 8
interval year(`precision`), 1 <= p <= 4	character varying(`size`), 2 <= size <= 5
json	character varying(65535)
mbr	binary varying(256)
number(*,s), 0 <= s <= 37	character varying(255)
number(p,s), 1 <= p <= 38, 1 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37	numeric(p,s), 1 <= p <= 38, 0 <= s <= 37
period(date)	character varying(28)
period(time(`precision`) with time zone), 0 <= p <= 6	character varying(`size`), 36 <= size <= 50
period(time(`precision`) ), 0 <= p <= 6	character varying(`size`), 24 <= size <= 38
period(timestamp(`precision`) with time zone), 0 <= p <= 6	character varying(`size`), 58 <= size <= 72
period(timestamp(`precision`) ), 0 <= p <= 6	character varying(`size`), 46 <= size <= 60
smallint	smallint
time(`precision`) with time zone, 0 <= p <= 6	timetz
time(`precision`), 0 <= p <= 6	time without time zone
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp with time zone
timestamp(`precision`), 0 <= p <= 6	timestamp without time zone
varbyte(`precision`), 1 <= p <= 64000	binary varying(`size`), 1 <= size <= 64000
varchar(`size`), 1 <= size <= 64000	character varying(`size`), 4 <= size <= 65535
varray	binary varying(1024000)
xml	character varying(65535)