MATERIALIZED_VIEW_NOT_INCREMENTALIZABLE error condition
Cannot create the materialized view with <refreshPolicy> refresh policy because it is not supported for incremental refresh. 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.