Training
UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY error class
Unsupported subquery expression:
Accessing outer query column is not allowed in this location:
<treeNode>
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 a non-equality predicate:
<treeNode>
Correlated column is not allowed in predicate:
<treeNode>
A correlated outer name reference within a subquery expression body was not found in the enclosing query: <value>.
Expressions referencing the outer query are not supported outside of WHERE/HAVING clauses: <sqlExprs>.
Subquery expressions are not supported within higher-order functions. Please remove all subquery expressions from higher-order functions and then try the query again.
Lateral join condition cannot be non-deterministic: <condition>.
Correlated scalar subqueries must be aggregated to return at most one row.
A GROUP BY clause in a scalar correlated subquery cannot contain non-correlated columns: <value>.
Non-deterministic lateral subqueries are not supported when joining with outer relations that produce more than one row:
<treeNode>
Scalar subqueries in the VALUES clause.
Correlated subqueries in the join predicate cannot reference both join inputs:
<subqueryExpression>
Correlated column reference ‘<expr>’ cannot be <dataType> type.
Correlated scalar subqueries can only be used in filters, aggregations, projections, and UPDATE/MERGE/DELETE commands:
<treeNode>
Correlated scalar subqueries cannot be used in the same clause as window operators:
<treeNode>
IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands:
<treeNode>
Table arguments are used in a function where they are not supported:
<treeNode>