Snowpark Migration Accelerator: Spark SQL-Datentypen¶

Umrechnungstabelle¶


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

Anmerkungen¶

Bemerkung

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

Ganzzahltypen¶

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