Gengliang Wang created SPARK-28997:
--------------------------------------
Summary: Add `spark.sql.dialect`
Key: SPARK-28997
URL: https://issues.apache.org/jira/browse/SPARK-28997
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 3.0.0
Reporter: Gengliang Wang
Assignee: Gengliang Wang
After https://github.com/apache/spark/pull/25158 and
https://github.com/apache/spark/pull/25458, SQL features of PostgreSQL are
introduced into Spark. AFAIK, both features are implementation-defined
behaviors, which are not specified in ANSI SQL.
In such a case, this proposal is to add a configuration `spark.sql.dialect` for
choosing a database dialect.
After this PR,
Spark supports two database dialects, `Spark` and `PostgreSQL`. With
`PostgreSQL` dialect, Spark will:
1. perform integral division with the / operator if both sides are integral
types;
2. accept "true", "yes", "1", "false", "no", "0", and unique prefixes as input
and trim input for the boolean data type.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
