Snowpark Migration Accelerator: Tipos de dados do Spark SQL¶

Tabela de conversão¶


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

Notas¶

Nota

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

Tipos de inteiros¶

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: Intervalo de -32.768 a 32.767
SparkSQL SHORT: Intervalo de -9.223.372.036.854.775.808 a 9.223.372.036.854.775.807
Snowflake INTEGER: Intervalo de -9,9999999999999999999999999999999999999 x 10^38 a +9,9999999999999999999999999999999999999 x 10^38