srielau commented on code in PR #37840:
URL: https://github.com/apache/spark/pull/37840#discussion_r968607262
##########
core/src/main/resources/error/error-classes.json:
##########
@@ -327,6 +327,78 @@
],
"sqlState" : "42000"
},
+ "INVALID_SUBQUERY_EXPRESSION" : {
+ "message" : [
+ "Invalid subquery:"
+ ],
+ "subClass" : {
+ "ACCESSING_OUTER_QUERY_COLUMN_IS_NOT_ALLOWED" : {
+ "message" : [
+ "Accessing outer query column is not allowed in this location<plan>"
+ ]
+ },
+ "AGGREGATE_FUNCTION_MIXED_OUTER_LOCAL_REFERENCES" : {
+ "message" : [
+ "Found an aggregate function in a correlated predicate that has both
outer and local references, which is not supported: <function>"
+ ]
+ },
+ "CORRELATED_COLUMN_IS_NOT_ALLOWED_IN_PREDICATE" : {
+ "message" : [
+ "Correlated column is not allowed in predicate<plan>"
+ ]
+ },
+ "CORRELATED_SCALAR_SUBQUERIES_ONLY_IN_CERTAIN_PLACES" : {
+ "message" : [
+ "Correlated scalar subqueries can only be used in filters,
aggregations, projections, and UPDATE/MERGE/DELETE commands<plan>"
+ ]
+ },
+ "IN_EXISTS_SUBQUERIES_ONLY_CERTAIN_PLACES" : {
+ "message" : [
+ "IN/EXISTS predicate subqueries can only be used in filters, joins,
aggregations, window functions, projections, and UPDATE/MERGE/DELETE
commands<plan>"
+ ]
+ },
+ "LATERAL_JOIN_CONDITION_NON_DETERMINISTIC" : {
+ "message" : [
+ "Lateral join condition cannot be non-deterministic: <condition>"
+ ]
+ },
+ "MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY" : {
+ "message" : [
+ "Correlated scalar subqueries in the GROUP BY clause must also be in
the aggregate expressions<plan>"
+ ]
+ },
+ "MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY_OUTPUT" : {
+ "message" : [
+ "The output of a correlated scalar subquery must be aggregated"
+ ]
+ },
+ "NON_CORRELATED_COLUMNS_IN_GROUP_BY" : {
+ "message" : [
+ "A GROUP BY clause in a scalar correlated subquery cannot contain
non-correlated columns: <value>"
+ ]
+ },
+ "NON_DETERMINISTIC_LATERAL_SUBQUERIES" : {
+ "message" : [
+ "Non-deterministic lateral subqueries are not supported when joining
with outer relations that produce more than one row<plan>"
+ ]
+ },
+ "OUTER_ATTRIBUTE_NOT_FOUND" : {
+ "message" : [
+ "Outer attribute not found: <value>"
+ ]
+ },
+ "OUTER_REFERENCES_ONLY_ALLOWED_IN_WHERE_HAVING" : {
Review Comment:
What is the difference between OUTER and CORRELATED? Should this be
CORRELATE_REFERENCE?
Also, as we lift restrictions, maybe we should not include the "whitelist"
in the error class name,
How about:
UNSUPPORTED_CORRELATED_REFERENCE.
Then whitelist in the error test and we can loosen it up over time.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
