Database Error Messages

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.