Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Converting complicated Postgres queries

Robert_JamesRobert_James
in General Discussion
I'm having trouble converting an advanced Postgres analytical database.  Vertica doesn't like a lot of the queries, which break a lot of the subquery limits.  Is there any guide on how to rewrite queries which have too complex subqueries (aggregates, more than 2 levels, etc.) to work with Vertica?

Comments

  • [Deleted User][Deleted User] ✭
    There is not guide to rewrite queries. However, Vertica should take most of the ANSI SQL, what Vertica does not like? 

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 ...

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.