Options

Mysql to Vertica

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

Comments

  • Options
    [Deleted User][Deleted User] ✭
    All ansi sql statements should work fine in Vertica. Not need to convert them. It may be very few exceptions.
  • Options
    [Deleted User][Deleted User]
    See linke below.. http://scale-out-blog.blogspot.com/2012/06/mysql-to-vertica-replication-part-2.html
  • Options
    Steve_O_HaraSteve_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.
  • Options
    Steve_O_HaraSteve_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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...