Mysql to Vertica

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

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

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.