UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY error class
Unsupported subquery expression:
ACCESSING_OUTER_QUERY_COLUMN_IS_NOT_ALLOWED
Accessing outer query column is not allowed in this location:
<treeNode>
AGGREGATE_FUNCTION_MIXED_OUTER_LOCAL_REFERENCES
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_NON_EQUALITY_PREDICATE
Correlated column is not allowed in a non-equality predicate:
<treeNode>
CORRELATED_COLUMN_IS_NOT_ALLOWED_IN_PREDICATE
Correlated column is not allowed in predicate:
<treeNode>
CORRELATED_COLUMN_NOT_FOUND
A correlated outer name reference within a subquery expression body was not found in the enclosing query: <value>
.
CORRELATED_REFERENCE
Expressions referencing the outer query are not supported outside of WHERE
/HAVING
clauses: <sqlExprs>
.
HIGHER_ORDER_FUNCTION
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_NON_DETERMINISTIC
Lateral join condition cannot be non-deterministic: <condition>
.
MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY
Correlated scalar subqueries must be aggregated to return at most one row.
NON_CORRELATED_COLUMNS_IN_GROUP_BY
A GROUP BY
clause in a scalar correlated subquery cannot contain non-correlated columns: <value>
.
NON_DETERMINISTIC_LATERAL_SUBQUERIES
Non-deterministic lateral subqueries are not supported when joining with outer relations that produce more than one row:
<treeNode>
SCALAR_SUBQUERY_IN_VALUES
Scalar subqueries in the VALUES
clause.
UNSUPPORTED_CORRELATED_EXPRESSION_IN_JOIN_CONDITION
Correlated subqueries in the join predicate cannot reference both join inputs:
<subqueryExpression>
UNSUPPORTED_CORRELATED_REFERENCE_DATA_TYPE
Correlated column reference '<expr>
' cannot be <dataType>
type.
UNSUPPORTED_CORRELATED_SCALAR_SUBQUERY
Correlated scalar subqueries can only be used in filters, aggregations, projections, and UPDATE
/MERGE
/DELETE
commands:
<treeNode>
UNSUPPORTED_CORRELATED_SCALAR_SUBQUERY_IN_WINDOW
Correlated scalar subqueries cannot be used in the same clause as window operators:
<treeNode>
UNSUPPORTED_IN_EXISTS_SUBQUERY
IN
/EXISTS
predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE
/MERGE
/DELETE
commands:
<treeNode>
UNSUPPORTED_TABLE_ARGUMENT
Table arguments are used in a function where they are not supported:
<treeNode>