The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
INTERNAL 3591: Internal EE Error (11) error on a view
pratheek238
Vertica Customer
Hello - We have a view combining data from multiple tables and we're getting below error when we're trying to run a query on top of the view. Does anyone know what this means or how to resolve this issue?
Internal EE Error (11)
DETAIL: rootPath.empty() == false && "Temp relation descriptor not provided"
HINT: Please report this error to Vertica; try restating your query
Thanks!
Tagged:
0
Answers
What exact version of Vertica are you running? Is there a UNION or UNION ALL in the query or underlying view?
We're on v11.1.1-4 and yes, we're doing UNION ALL in the view
This known issue will be fixed in upcoming 11.1.1-6 patch.
Thanks. What is the issue and is there a workaround for this until we can upgrade?
Workaround with:
alter session set EnableWITHTempRelReuseLimit = 0;