Mass Ingestion
- Mass Ingestion
- 所有产品
MySQLソースデータ型
| Google BigQueryターゲットデータ型
|
---|---|
bigint
| int64
|
bigint unsigned
| bignumeric
|
binary( size ), 1 <= size <= 255
| bytes
|
bit( precision ), 1 <= p <= 64
| bytes
|
blob
| bytes
|
char( size ), 1 <= size <= 255
| string
|
date
| date
|
datetime
| datetime
|
decimal(1,1)
| numeric
|
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(2,s), 1 <= s <= 2
| numeric
|
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(3,s), 1 <= s <= 3
| numeric
|
decimal(4,s), 1 <= s <= 4
| numeric
|
decimal(40,0)
| string
|
decimal(41,s), 0 <= s <= 1
| string
|
decimal(42,s), 0 <= s <= 2
| string
|
decimal(43,s), 0 <= s <= 3
| string
|
decimal(44,s), 0 <= s <= 4
| string
|
decimal(45,s), 0 <= s <= 5
| string
|
decimal(46,s), 0 <= s <= 6
| string
|
decimal(47,s), 0 <= s <= 7
| string
|
decimal(48,s), 0 <= s <= 8
| string
|
decimal(49,s), 0 <= s <= 9
| string
|
decimal(5,s), 1 <= s <= 5
| numeric
|
decimal(50,s), 0 <= s <= 10
| string
|
decimal(51,s), 0 <= s <= 11
| string
|
decimal(52,s), 0 <= s <= 12
| string
|
decimal(53,s), 0 <= s <= 13
| string
|
decimal(54,s), 0 <= s <= 14
| string
|
decimal(55,s), 0 <= s <= 15
| string
|
decimal(56,s), 0 <= s <= 16
| string
|
decimal(57,s), 0 <= s <= 17
| string
|
decimal(58,s), 0 <= s <= 18
| string
|
decimal(59,s), 0 <= s <= 19
| string
|
decimal(6,s), 1 <= s <= 6
| numeric
|
decimal(60,s), 0 <= s <= 20
| string
|
decimal(61,s), 0 <= s <= 21
| string
|
decimal(62,s), 0 <= s <= 22
| string
|
decimal(63,s), 0 <= s <= 23
| string
|
decimal(64,s), 0 <= s <= 24
| string
|
decimal(65,s), 0 <= s <= 25
| string
|
decimal(7,s), 1 <= s <= 7
| numeric
|
decimal(8,s), 1 <= s <= 8
| numeric
|
decimal(p,0), 1 <= p <= 18
| int64
|
decimal(p,s), 19 <= p <= 29, 0 <= s <= 9
| numeric
|
decimal(p,s), 29 <= p <= 64, 0 <= s <= 29
| bignumeric
|
decimal(p,s), 30 <= p <= 31, 0 <= s <= 29
| bignumeric
|
decimal(p,s), 39 <= p <= 65, 21 <= s <= 29
| bignumeric
|
decimal(p,s), 9 <= p <= 38, 1 <= s <= 9
| numeric
|
double
| float64
|
float
| float64
|
geomcollection
| bytes
|
geometry
| bytes
|
geometrycollection
| bytes
|
int
| int64
|
int unsigned
| int64
|
json
| string
|
linestring
| bytes
|
longblob
| bytes
|
longtext
| string
|
mediumblob
| bytes
|
mediumint
| int64
|
mediumint unsigned
| int64
|
mediumtext
| string
|
multilinestring
| bytes
|
multipoint
| bytes
|
multipolygon
| bytes
|
numeric
| int64
|
point
| bytes
|
polygon
| bytes
|
smallint
| int64
|
smallint unsigned
| int64
|
text
| string
|
time( precision ), 0 <= p <= 6
| string
|
timestamp( precision ), 0 <= p <= 6
| datetime
|
tinyblob
| bytes
|
tinyint
| int64
|
tinyint unsigned
| int64
|
tinytext
| string
|
varbinary( size ), 1 <= size <= 65535
| bytes
|
varchar( size ), 1 <= size <= 21844
| string
|
year
| int64
|