Mysql to Vertica

My company is currently switching from mysql to Vertica. How do I convert the mysql statements over into Vertica?

Comments

  • All ansi sql statements should work fine in Vertica. Not need to convert them. It may be very few exceptions.
  • Most SQL97 style MySQL statements will work with Vertica out of the box but others will require corrections for the strictness Vertica imposes that MySQL just let's through e.g. not all columns in the select are in the group by clause etc. Some function names are different and there are functions missing (IF for instance) but they all have substitutes in Vertica.
  • Most SQL97 style MySQL statements will work with Vertica out of the box but others will require corrections for the strictness Vertica imposes that MySQL just let's through e.g. not all columns in the select are in the group by clause etc. Some function names are different and there are functions missing (IF for instance) but they all have substitutes in Vertica.

Leave a Comment

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