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

Column "‘mergeout’" does not exist?

Hi, I am a relative newbie to Vertica and came across my first ROS-needs-to-be-cleaned problem. The solution suggested is to run "SELECT DO_TM_TASK(‘mergeout’, ‘mydb.mytable’);", however when Ido that I get an error:

ERROR 2624: Column "‘mergeout’" does not exist

This confuses me sine I am trying to run a task called "mergeout" not access a data column of the same name.

Any information would be appreciated, especially around why it thinks I want to access a column and how I can get this command to work, as I am clearly misunderstanding something here.

|\/|

Best Answer

  • Accepted Answer

    OK, PEBCAK (although I can partially blame my laptop). The quotes around the 'mergeout' got changed to so-called smart quotes, so the system could not work out the correct command. Sorry for wasting your time.

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.