QSM-02138: agg(expr) requires correspondng agg(expr*expr) function

QSM-02138: agg(expr) requires correspondng agg(expr*expr)
function

Question Posted / guest

1 Answers
2546 Views
I also Faced
E-Mail Answers

QSM-02138: agg(expr) requires correspondng agg(expr*expr) function..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses certain aggregate functions but omits
an invocation of that same aggregate function on the square
of the same argument.

Action: Add an invocation of the same aggregate function on
the square of the same argument (that is, the argument
multiplied by itself).

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer