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!
+2What 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
+2This 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?
+2Workaround with:
alter session set EnableWITHTempRelReuseLimit = 0;
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
