UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY error class

SQLSTATE: 0A000

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>