Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Purge fails: "Not a table"


I run a set of 10 purges and 9 went ok but one crashed on this:

**[Code: 4217, SQL State: 42704] [Vertica]VJDBC ERROR: Object 'xxxx.yyyyyy ' is not a table.
What could be the reason? Table looks ok, works ok, DDL says it is a table, not a view etc.

Vertica is v8.1.1-2, running on linux.



  • Case closed.
    There was a extra space in table name in Purge. My bad, sorry!
    Have a nice day!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.