DDL statement interfered with query replan?

Kris_PeetersKris_Peeters
in General Discussion
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

  • Flavien_BessedeFlavien_Bessede
    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?
  • Sharon_CutterSharon_Cutter ✭✭
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...