QSM-02086
Materialized view uses the MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.
Cause
Fast refresh after an update or delete was not supported because the materialized view used the MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.
Action
Rephrase the query to avoid using MIN, MAX, ANY_VALUE, BIT_*_AGG, BOOLEAN_*_AGG, or EVERY aggregate function.
QSM-02086
materialized view uses MIN, MAX, ANY_VALUE, or BIT_*_AGG aggregate function
Cause
Fast refresh after an update or delete was not supported because the materialized view used MIN, MAX, ANY_VALUE, or BIT_*_AGG aggregate function.
Action
Rephrase the query to avoid using MIN, MAX, ANY_VALUE, or BIT_*_AGG aggregate function.
QSM-02086
mv uses the MIN, MAX or ANY_VALUE aggregate functions
Cause
The capability in question is not supported when the materialized view uses the MIN, MAX, or ANY_VALUE function.
Action
Re-phrase the query to avoid the use of the MIN, MAX or ANY_VALUE functions.