[
https://issues.apache.org/jira/browse/SPARK-28997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan resolved SPARK-28997.
---------------------------------
Fix Version/s: 3.0.0
Resolution: Fixed
Issue resolved by pull request 25697
[https://github.com/apache/spark/pull/25697]
> 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
> Priority: Major
> Fix For: 3.0.0
>
>
> 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.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
