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

前へ次へ

NetezzaソースとGoogle BigQueryターゲット

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

Netezzaソースデータ型	Google BigQueryターゲットデータ型
bigint	int64
boolean	bool
byteint	int64
char(`size`), 1 <= size <= 64000	string
date	date
double	float64
integer	int64
interval	string
nchar(`size`), 1 <= size <= 16000	string
numeric(10,10)	bignumeric
numeric(11,s), 10 <= s <= 11	bignumeric
numeric(12,s), 10 <= s <= 12	bignumeric
numeric(13,s), 10 <= s <= 13	bignumeric
numeric(14,s), 10 <= s <= 14	bignumeric
numeric(15,s), 10 <= s <= 15	bignumeric
numeric(16,s), 10 <= s <= 16	bignumeric
numeric(17,s), 10 <= s <= 17	bignumeric
numeric(18,s), 10 <= s <= 18	bignumeric
numeric(19,s), 10 <= s <= 19	bignumeric
numeric(20,s), 10 <= s <= 20	bignumeric
numeric(21,s), 10 <= s <= 21	bignumeric
numeric(22,s), 10 <= s <= 22	bignumeric
numeric(23,s), 10 <= s <= 23	bignumeric
numeric(24,s), 10 <= s <= 24	bignumeric
numeric(25,s), 10 <= s <= 25	bignumeric
numeric(26,s), 10 <= s <= 26	bignumeric
numeric(27,s), 10 <= s <= 27	bignumeric
numeric(28,s), 10 <= s <= 28	bignumeric
numeric(29,s), 10 <= s <= 29	bignumeric
numeric(38,s), 10 <= s <= 38	bignumeric
numeric(`precision`), 1 <= p <= 17	int64
numeric(`precision`), 19 <= p <= 29	numeric
numeric(`precision`), 30 <= p <= 38	bignumeric
numeric(p,s), 1 <= p <= 38, 1 <= s <= 9	numeric
numeric(p,s), 30 <= p <= 31, 1 <= s <= 30	bignumeric
numeric(p,s), 31 <= p <= 32, 1 <= s <= 31	bignumeric
numeric(p,s), 32 <= p <= 33, 1 <= s <= 32	bignumeric
numeric(p,s), 33 <= p <= 34, 1 <= s <= 33	bignumeric
numeric(p,s), 34 <= p <= 35, 1 <= s <= 34	bignumeric
numeric(p,s), 35 <= p <= 36, 1 <= s <= 35	bignumeric
numeric(p,s), 36 <= p <= 37, 1 <= s <= 36	bignumeric
numeric(p,s), 37 <= p <= 38, 1 <= s <= 37	bignumeric
nvarchar(`size`), 1 <= size <= 16000	string
real	float64
smallint	int64
st_geometry(`precision`), 1 <= p <= 63001	bytes
time	time
timestamp	datetime
timetz	timestamp
varbinary(`size`), 1 <= size <= 64000	bytes
varchar(`size`), 1 <= size <= 64000	string