spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiao Li (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (SPARK-24966) Fix the precedence rule for set operations.
Date Fri, 03 Aug 2018 05:06:00 GMT

     [ https://issues.apache.org/jira/browse/SPARK-24966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Xiao Li reassigned SPARK-24966:
-------------------------------

    Assignee: Dilip Biswal

> Fix the precedence rule for set operations.
> -------------------------------------------
>
>                 Key: SPARK-24966
>                 URL: https://issues.apache.org/jira/browse/SPARK-24966
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.3.1
>            Reporter: Dilip Biswal
>            Assignee: Dilip Biswal
>            Priority: Major
>             Fix For: 2.4.0
>
>
> Currently the set operations INTERSECT, UNION and EXCEPT are assigned the same precedence.
We need to change to make sure INTERSECT is given higher precedence than UNION and EXCEPT.
UNION and EXCEPT should be evaluated in the order they appear in the query from left to right.

> Given this will result in a change in behavior, we need to keep it under a config.
> Here is a reference :
> https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql?view=sql-server-2017



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message