Johan Lasperas created SPARK-43487:
--------------------------------------
Summary: Wrong error message used for
`ambiguousRelationAliasNameInNestedCTEError`
Key: SPARK-43487
URL: https://issues.apache.org/jira/browse/SPARK-43487
Project: Spark
Issue Type: Improvement
Components: Spark Core
Affects Versions: 3.4.0
Reporter: Johan Lasperas
The batch of errors migrated to error classes as part of spark-40540 contains
an error that got mixed up with the wrong error message:
[ambiguousRelationAliasNameInNestedCTEError|https://github.com/apache/spark/commit/43a6b932759865c45ccf36f3e9cf6898c1b762da#diff-744ac13f6fe074fddeab09b407404bffa2386f54abc83c501e6e1fe618f6db56R1983]
uses the same error message as the following commandUnsupportedInV2TableError:
```
WITH t AS (SELECT 1), t2 AS ( WITH t AS (SELECT 2) SELECT * FROM t) SELECT *
FROM t2;
AnalysisException: t is not supported for v2 tables
```
The error should be:
```
AnalysisException: Name tis ambiguous in nested CTE.
Please set spark.sql.legacy.ctePrecedencePolicy to CORRECTED so that name
defined in inner CTE takes precedence. If set it to LEGACY, outer CTE
definitions will take precedence. See more details in SPARK-28228.
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
