Dilip Biswal created SPARK-24966:
------------------------------------
Summary: 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
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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
