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 (https://spark.apache.org/docs/latest/sql-ref-datatypes.html#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