目次

Search

  1. はじめに
  2. 一括取り込みデータベース

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

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

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

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

次の表は、TeradataソースとGoogle BigQueryターゲットを使用した一括取り込みデータベース設定の推奨データ型マッピングを示しています。
Teradataソースデータ型
Google BigQueryターゲットデータ型
array
bytes
bigint
int64
blob
bytes
byte(
precision
), 1 <= p <= 64000
bytes
byteint
int64
char(
size
), 1 <= size <= 64000
string
clob
string
date
date
decimal(10,10)
bignumeric
decimal(11,s), 10 <= s <= 11
bignumeric
decimal(12,s), 10 <= s <= 12
bignumeric
decimal(13,s), 10 <= s <= 13
bignumeric
decimal(14,s), 10 <= s <= 14
bignumeric
decimal(15,s), 10 <= s <= 15
bignumeric
decimal(16,s), 10 <= s <= 16
bignumeric
decimal(17,s), 10 <= s <= 17
bignumeric
decimal(18,s), 10 <= s <= 18
bignumeric
decimal(19,s), 10 <= s <= 19
bignumeric
decimal(20,s), 10 <= s <= 20
bignumeric
decimal(21,s), 10 <= s <= 21
bignumeric
decimal(22,s), 10 <= s <= 22
bignumeric
decimal(23,s), 10 <= s <= 23
bignumeric
decimal(24,s), 10 <= s <= 24
bignumeric
decimal(25,s), 10 <= s <= 25
bignumeric
decimal(26,s), 10 <= s <= 26
bignumeric
decimal(27,s), 10 <= s <= 27
bignumeric
decimal(28,s), 10 <= s <= 28
bignumeric
decimal(29,s), 10 <= s <= 29
bignumeric
decimal(
precision
), 1 <= p <= 18
int64
decimal(
precision
), 19 <= p <= 29
numeric
decimal(
precision
), 30 <= p <= 38
bignumeric
decimal(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
decimal(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
decimal(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
decimal(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
decimal(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
decimal(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
decimal(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
decimal(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
decimal(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
float
float64
integer
int64
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
bytes
number(*,s), 0 <= s <= 37
string
number(10,10)
bignumeric
number(11,s), 10 <= s <= 11
bignumeric
number(12,s), 10 <= s <= 12
bignumeric
number(13,s), 10 <= s <= 13
bignumeric
number(14,s), 10 <= s <= 14
bignumeric
number(15,s), 10 <= s <= 15
bignumeric
number(16,s), 10 <= s <= 16
bignumeric
number(17,s), 10 <= s <= 17
bignumeric
number(18,s), 10 <= s <= 18
bignumeric
number(19,s), 10 <= s <= 19
bignumeric
number(20,s), 10 <= s <= 20
bignumeric
number(21,s), 10 <= s <= 21
bignumeric
number(22,s), 10 <= s <= 22
bignumeric
number(23,s), 10 <= s <= 23
bignumeric
number(24,s), 10 <= s <= 24
bignumeric
number(25,s), 10 <= s <= 25
bignumeric
number(26,s), 10 <= s <= 26
bignumeric
number(27,s), 10 <= s <= 27
bignumeric
number(28,s), 10 <= s <= 28
bignumeric
number(29,s), 10 <= s <= 29
bignumeric
number(
precision
), 1 <= p <= 18
int64
number(
precision
), 19 <= p <= 29
numeric
number(
precision
), 30 <= p <= 36
bignumeric
number(p,s), 1 <= p <= 38, 1 <= s <= 9
numeric
number(p,s), 30 <= p <= 31, 1 <= s <= 30
bignumeric
number(p,s), 31 <= p <= 32, 1 <= s <= 31
bignumeric
number(p,s), 32 <= p <= 33, 1 <= s <= 32
bignumeric
number(p,s), 33 <= p <= 34, 1 <= s <= 33
bignumeric
number(p,s), 34 <= p <= 35, 1 <= s <= 34
bignumeric
number(p,s), 35 <= p <= 36, 1 <= s <= 35
bignumeric
number(p,s), 36 <= p <= 37, 1 <= s <= 36
bignumeric
number(p,s), 37 <= p <= 38, 1 <= s <= 37
bignumeric
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(
precision
), 1 <= p <= 18
int64
numeric(
precision
), 19 <= p <= 29
numeric
numeric(
precision
), 30 <= p <= 36
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
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
int64
time(
precision
) with time zone, 0 <= p <= 6
timestamp
time(
precision
), 0 <= p <= 6
time
timestamp(
precision
) with time zone, 0 <= p <= 6
timestamp
timestamp(
precision
), 0 <= p <= 6
datetime
varbyte(
precision
), 1 <= p <= 64000
bytes
varchar(
size
), 1 <= size <= 64000
string
varray
bytes
xml
string
サポートされていないソースデータ型
一括取り込みデータベースでは、次のTeradataデータ型はサポートされません。
  • ARRAY
  • Blob
  • CLOB
  • JSON
  • ST_GEOMETRY
  • XML
サポートされていないデータ型のほとんどがデフォルトのマッピングに表示されます。ただし、これらのマッピングではnullがレプリケートされます。