Snowpark Migration Accelerator : Types de données Spark SQL¶

Table de conversion¶


Spark SQL	Snowflake	Remarques
`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`

Remarques¶

Note

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

Types d’entiers¶

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 : De -32 768 à 32 767
SparkSQL SHORT : De -9 223 372 036 854 775 808 à 9 223 372 036 854 775 807
Snowflake INTEGER : De -9,9999999999999999999999999999999999999 x 10^38 à +9,9999999999999999999999999999999999999 x 10^38