OCI-62512
This aggregate is not yet supported in MATCH_RECOGNIZE clause.
Cause
An unsupported aggregate was specified in the MATCH_RECOGNIZE clause. Only COUNT, SUM, AVG, MIN, and MAX are currently supported in the MATCH_RECOGNIZE clause. Distinct aggregates are currently not supported in the MATCH_RECOGNIZE clause.
Action
Modify the query and retry the operation.