Teradata Database Message 6924 - 6924 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Illegal or unsupported set operation inside a recursive query/view.
Explanation
A set operation like UNION, INTERSECT, INTERSECT ALL, MINUS, MINUS ALL, EXCEPT, or EXCEPT ALL is being used inside the recursive query/view, which is not allowed.
Generated By
SYN modules
For Whom
End User
Notes
None
Remedy
Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the recursive query rules and resubmit the request.