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

前へ次へ

TeradataソースとDatabricks Deltaターゲット

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

Teradataソースデータ型	Databricks Deltaターゲットデータ型
array	binary
bigint	long
blob	binary
byte(`precision`), 1 <= p <= 64000	binary
byteint	integer
char(`size`), 1 <= size <= 64000	string
clob	string
date	string
decimal(p,s), 1 <= p <= 38, 1 <= s <= 37	decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
float	double
integer	integer
interval day(`precision`) to hour, 1 <= p <= 4	string
interval day(`precision`) to minute, 1 <= p <= 4	string
interval day(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval day(`precision`), 1 <= p <= 4	string
interval hour(`precision`) to minute, 1 <= p <= 4	string
interval hour(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval hour(`precision`), 1 <= p <= 4	string
interval minute(`precision`) to second (s), 1 <= p <= 4, 0 <= s <= 6	string
interval minute(`precision`), 1 <= p <= 4	string
interval month(`precision`), 1 <= p <= 4	string
interval second(p,s), 1 <= p <= 4, 0 <= s <= 6	string
interval year(`precision`) to month, 1 <= p <= 4	string
interval year(`precision`), 1 <= p <= 4	string
json	string
mbr	binary
number(*,s), 0 <= s <= 37	string
number(p,s), 1 <= p <= 38, 1 <= s <= 37	decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37	decimal(p,s), 1 <= p <= 38, 1 <= s <= 37
period(date)	string
period(time(`precision`) with time zone), 0 <= p <= 6	string
period(time(`precision`) ), 0 <= p <= 6	string
period(timestamp(`precision`) with time zone), 0 <= p <= 6	string
period(timestamp(`precision`) ), 0 <= p <= 6	string
smallint	integer
time(`precision`) with time zone, 0 <= p <= 6	string
time(`precision`), 0 <= p <= 6	string
timestamp(`precision`) with time zone, 0 <= p <= 6	timestamp
timestamp(`precision`), 0 <= p <= 6	timestamp
varbyte(`precision`), 1 <= p <= 64000	binary
varchar(`size`), 1 <= size <= 64000	string
varray	binary
xml	string