Apache Spark SQL

Property	Value
Label	sparksql
Inherits From	ansi

Default Casing: SparkSQL is case insensitive with both quoted and unquoted identifiers ("delimited" identifiers in Spark terminology). See the Spark Identifiers docs.

Quotes: String Literals: '' or "", Identifiers: backticks.

The dialect for Apache Spark SQL. This includes relevant syntax from hive_dialect_ref for commands that permit Hive Format. Spark SQL extensions provided by the Delta Lake project are also implemented in this dialect.

This implementation focuses on the Ansi Compliant Mode introduced in Spark3, instead of being Hive Compliant. The introduction of ANSI Compliance provides better data quality and easier migration from traditional DBMS.

Versions of Spark prior to 3.x will only support the Hive dialect.