Mass Ingestion
- Mass Ingestion
- 所有产品
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
|