ERROR | DISTINCT clause on a duplicate sensitive aggregate function |
CAUSE | The capability in question is not supported when the materialized view uses the DISTINCT clause in this context. |
ACTION | Re-phrase the query to avoid the use of the DISTINCT clause. |