Converting complicated Postgres queries
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?