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 범위