You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Karthikeyan Jambu Rajaraman (JIRA)" <ji...@apache.org> on 2015/12/04 20:45:10 UTC

[jira] [Created] (HAWQ-225) Add aggregate with grouping sets test to hawq

Karthikeyan Jambu Rajaraman created HAWQ-225:
------------------------------------------------

             Summary: Add aggregate with grouping sets test to hawq
                 Key: HAWQ-225
                 URL: https://issues.apache.org/jira/browse/HAWQ-225
             Project: Apache HAWQ
          Issue Type: Test
            Reporter: Karthikeyan Jambu Rajaraman
            Assignee: Lei Chang


Add the below test in ICG and make sure it passes. We found this test was failing in gpdb and want to make sure this pass in hawq.

SELECT type, prod, sum(quantity) s_quant
FROM
(
  SELECT type, prod, quantity
  FROM foo F1
  LIMIT 3
) F2 GROUP BY GROUPING SETS((type, prod), (prod)) ORDER BY type, s_quant;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)