Mysql to Vertica

Chris_Parker

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

[Deleted User]

All ansi sql statements should work fine in Vertica. Not need to convert them. It may be very few exceptions.

[Deleted User]

See linke below.. http://scale-out-blog.blogspot.com/2012/06/mysql-to-vertica-replication-part-2.html

Steve_O_Hara

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.

Steve_O_Hara

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.