Teradata Database Message 6925 - 6925 - Analytics Database - Teradata Vantage

Message

Unsupported use of DISTINCT inside a recursive query/view.

Explanation

A DISTINCT clause is being used inside the recursive statement of a recursive query/view, which is not allowed.

Generated By

SYN/OPT modules

For Whom

End User

Notes

None

Remedy

Examine the SQL statement and verify that the request is correct. Remove the DISTINCT modifier from the recursive statement and resubmit the request.