Skip to main content

Converting complicated Postgres queries

  • October 31, 2013
  • 1 reply
  • 8 views

Robert_James
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?

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • October 31, 2013
There is not guide to rewrite queries. However, Vertica should take most of the ANSI SQL, what Vertica does not like?