Mass Ingestion
- Mass Ingestion
- 所有产品
MySQLソースデータ型
| Amazon Redshiftターゲットデータ型
|
---|---|
bigint
| bigint
|
bigint unsigned
| numeric(20,0)
|
binary( size ), 1 <= size <= 255
| binary varying( size ), 1 <= size <= 255
|
bit
| binary varying(2)
|
bit( precision ), 1 <= p <= 64
| binary varying( size ), 1 <= size <= 8
|
blob
| binary varying(65535)
|
char( size ), 1 <= size <= 255
| character varying( size ), 3 <= size <= 765
|
date
| date
|
datetime
| timestamp without time zone
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
| numeric(p,s), 1 <= p <= 38, 0 <= s <= 29
|
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
| character varying( size ), 40 <= size <= 67
|
double
| double precision
|
float
| real
|
geomcollection
| binary varying(1024000)
|
geometry
| binary varying(1024000)
|
geometrycollection
| binary varying(1024000)
|
int
| integer
|
int unsigned
| bigint
|
json
| character varying(65535)
|
linestring
| binary varying(1024000)
|
longblob
| binary varying(1024000)
|
longtext
| character varying(65535)
|
mediumblob
| binary varying(1024000)
|
mediumint
| integer
|
mediumint unsigned
| integer
|
mediumtext
| character varying(65535)
|
multilinestring
| binary varying(1024000)
|
multipoint
| binary varying(1024000)
|
multipolygon
| binary varying(1024000)
|
numeric
| numeric(10,0)
|
point
| binary varying(1024000)
|
polygon
| binary varying(1024000)
|
smallint
| smallint
|
smallint unsigned
| integer
|
text
| character varying(65535)
|
time( precision ), 0 <= p <= 6
| character varying( size ), 10 <= size <= 17
|
timestamp( precision ), 0 <= p <= 6
| timestamp without time zone
|
tinyblob
| binary varying(255)
|
tinyint
| smallint
|
tinyint unsigned
| smallint
|
tinytext
| character varying(255)
|
varbinary( size ), 1 <= size <= 65535
| binary varying( size ), 1 <= size <= 65535
|
varchar( size ), 1 <= size <= 21844
| character varying( size ), 3 <= size <= 65532
|
year
| smallint
|