Snowpark Migration Accelerator: Spark SQL データ型¶

換算テーブル¶


Spark SQL	Snowflake	注意
`BIGINT`	`BIGINT`
`BOOLEAN`	`BOOLEAN`
`BYTE`	`BYTEINT`
`CHAR`	`CHAR`
`DATE`	`DATE`
`DECIMAL`	`DECIMAL`
`DOUBLE`	`DOUBLE`
`FLOAT`	`FLOAT`
`INTEGER`	`INTEGER`
`LONG`	`INT`	Check out note
`SHORT`	`INT`	Check out note
`STRING`	`STRING`
`TIMESTAMP`	`TIMESTAMP_TZ`
`TIMESTAMPNTZ`	`TIMESTAMP_NTZ`
`VARCHAR`	`VARCHAR`

注意¶

注釈

For more information, refer to the Spark SQL data types documentation.

整数タイプ¶

When converting integer data types from the source system, both LONG and SHORT are mapped to Snowflake's INTEGER data type, as INTEGER can accommodate the full range of values for both data types.

SparkSQL LONG: 範囲は、-32,768～32,767
SparkSQL SHORT: 範囲は、-9,223,372,036,854,775,808～9,223,372,036,854,775,807
Snowflake INTEGER: 範囲は、-9.9999999999999999999999999999999999999 x 10^38～+9.9999999999999999999999999999999999999 x 10^38