Aller au contenu principal

METRIC_VIEW_MATERIALIZATION_NOT_INCREMENTALIZABLE error condition

SQLSTATE: 42601

Metric view <viewName>: materialization <materialization> requests the <refreshPolicy> refresh policy but cannot be refreshed incrementally. Reason:

AGGREGATE_NOT_TOP_NODE​

GROUP BY with complex expressions above it is not supported. Consider rewriting the query to make GROUP BY the top-level operation.

EXPRESSION_NOT_DETERMINISTIC​

Expressions <expressionNames> are not deterministic. Consider rewriting the query to avoid using them.

INPUT_NOT_IN_DELTA​

Tables <tableNames> are not in Delta format. Consider converting them to Delta tables.

OPERATOR_NOT_INCREMENTALIZABLE​

Operators <operatorNames> are not incrementalizable. Consider rewriting the query to avoid using them.

ROW_TRACKING_NOT_ENABLED​

Tables <tableNames> do not have row tracking enabled. Please enable row tracking on the tables.

SUBQUERY_EXPRESSION_NOT_INCREMENTALIZABLE​

Subquery expressions <subqueryExpressionTypes> are not incrementalizable. Consider rewriting the query to avoid using them.

UDF_NOT_DETERMINISTIC​

UDFs <expressionNames> are not deterministic. Please mark the UDFs as deterministic.

WINDOW_WITHOUT_PARTITION_BY​

Window specifications without PARTITION BY are not incrementalizable. Consider adding PARTITION BY clauses to the window specifications.