The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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?

Comments

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

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.