This is a exact sample of a query which I have been trying to run... SELECT 'abc' AS ctx, SUM(A.TID) AS TID, SUM(A.AMT) AS AMT, SUM(A.BMT) AS BMT, (SELECT SUM(rzrm) FROM abcd o) AS rzrm FROM xyz a GROUP BY 1 This version works well in oracle but when trying it in vertica I get following error [Verti...

Is there any way to implement group by grouping sets() like in oracle. I am writing queries that were previously implemented in oracle but I am not being able to find this feature in vertica. In oracle we can rewrite queries of the format SELECT a, b, SUM( c ) FROM t GROUP BY GROUPING SETS ( ( a, b ...