DDL statement interfered with query replan?
+1When I run a large query with multiple joins on TEMP tables, I get an error saying: "DDL statement interfered with query replan". It works well for relatively small tables. But it fails for a 100M rows table. I have no idea where to start looking. Any ideas?
My first guess would be that your statistics are not up to date on that larger table.
Can you check on this maybe or refresh them and see if it helps?
Can you check on this maybe or refresh them and see if it helps?
Hi Kris,
Look through the query history between when the query started and when you get the error, looking for anything that affected the tables' projections. Also search the vertica.log files on all nodes for anything affecting those projections during that time window.
--Sharon
Look through the query history between when the query started and when you get the error, looking for anything that affected the tables' projections. Also search the vertica.log files on all nodes for anything affecting those projections during that time window.
--Sharon
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
