Mass Ingestion
- Mass Ingestion
- 所有产品
Oracleソースデータ型
| Google BigQueryターゲットデータ型
|
---|---|
binary_double
| float64
|
binary_float
| float64
|
blob
| bytes
|
char(s byte), 1 <= size <= 2000
| string
|
char(s char), 1 <= size <= 2000
| string
|
clob
| string
|
date
| datetime
|
float( precision ), 1 <= p <= 126
| string
|
integer
| string
|
long raw
| bytes
|
long(2147483648 byte)
| string
|
nchar(s char), 1 <= size <= 2000
| string
|
nclob
| string
|
number
| string
|
number(*,s), -84 <= s <= 127
| string
|
number(1,-38)
| bignumeric
|
number(1,s), -37 <= s <= -29
| bignumeric
|
number(1,s), -84 <= s <= -39
| string
|
number(10,-29)
| bignumeric
|
number(11,-28)
| bignumeric
|
number(12,-27)
| bignumeric
|
number(13,-26)
| bignumeric
|
number(14,-25)
| bignumeric
|
number(15,-24)
| bignumeric
|
number(16,-23)
| bignumeric
|
number(17,-22)
| bignumeric
|
number(18,-21)
| bignumeric
|
number(19,-20)
| bignumeric
|
number(2,-37)
| bignumeric
|
number(20,-19)
| bignumeric
|
number(21,-18)
| bignumeric
|
number(22,-17)
| bignumeric
|
number(23,-16)
| bignumeric
|
number(24,-15)
| bignumeric
|
number(25,-14)
| bignumeric
|
number(26,-13)
| bignumeric
|
number(27,-12)
| bignumeric
|
number(28,-11)
| bignumeric
|
number(29,-10)
| bignumeric
|
number(3,-36)
| bignumeric
|
number(30,-9)
| bignumeric
|
number(31,-8)
| bignumeric
|
number(32,-7)
| bignumeric
|
number(33,-6)
| bignumeric
|
number(34,-5)
| bignumeric
|
number(35,-4)
| bignumeric
|
number(36,-3)
| bignumeric
|
number(37,-2)
| bignumeric
|
number(38,-1)
| bignumeric
|
number(38,s), 10 <= s <= 38
| bignumeric
|
number(4,-35)
| bignumeric
|
number(5,-34)
| bignumeric
|
number(6,-33)
| bignumeric
|
number(7,-32)
| bignumeric
|
number(8,-31)
| bignumeric
|
number(9,-30)
| bignumeric
|
number(p,s), 1 <= p <= 38, -28 <= s <= 9
| numeric
|
number(p,s), 1 <= p <= 38, -36 <= s <= 38
| bignumeric
|
number(p,s), 1 <= p <= 38, -84 <= s <= 127
| string
|
number(p,s), 2 <= p <= 3, -35 <= s <= 38
| bignumeric
|
number(p,s), 2 <= p <= 3, -84 <= s <= 127
| string
|
nvarchar2(s char), 1 <= s <= 4000
| string
|
raw( size ), 1 <= size <= 2000
| bytes
|
rowid
| string
|
timestamp( precision ) with time zone, 0 <= p <= 6
| timestamp
|
timestamp( precision ) with time zone, 7 <= p <= 9
| string
|
timestamp( precision ), 1 <= p <= 6
| datetime
|
timestamp( precision ), 7 <= p <= 9
| string
|
varchar2(s byte), 1 <= size <= 4000
| string
|
varchar2(s char), 1 <= size <= 4000
| string
|