DDL statement interfered with query replan?

When 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?


  • Options
    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?
  • Options
    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.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file