Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2376

UNION ALL on Aggregates with GROUP BY returns incomplete results

    XMLWordPrintableJSON

Details

    Description

      The following query returns incomplete results:

      select x
from
(SELECT Sum(ss_ext_sales_price) x
FROM  store_sales
UNION ALL
SELECT Sum(cs_ext_sales_price) x
FROM catalog_sales) tmp
GROUP BY x;

Results from Drill:
+------------+
|     x      |
+------------+
| 3658019159.35 |
+------------+
1 row selected (3.474 seconds)

Results from Postgres:
       x       
---------------
 5265207074.51
 3658019159.35
(2 rows)

      Removing GROUP BY returns the right results:

      select x
from
(SELECT Sum(ss_ext_sales_price) x
FROM  store_sales
UNION ALL
SELECT Sum(cs_ext_sales_price) x
FROM catalog_sales) tmp;

Results from Drill:
+------------+
|     x      |
+------------+
| 5265207074.51 |
| 3658019159.35 |
+------------+

      Attachments

        1. t2.parquet
          0.5 kB
          Victoria Markman
        2. t1.parquet
          0.5 kB
          Victoria Markman

        Issue Links

          depends upon

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2234 IOOB when streaming aggregate is on the left side of hash join

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2207 Fix Union All Operator

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2377 UNION ALL on Aggregates with GROUP BY returns null when column aliases don't match

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2378 UNION ALL on Aggregates with GROUP BY and ORDER BY fails when column aliases don't match

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DRILL-1977 Wrong result with aggregation on top of UNION ALL operator

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2380 TPC-DS Query 33 and simplified variants return wrong results

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2377 UNION ALL on Aggregates with GROUP BY returns null when column aliases don't match

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2378 UNION ALL on Aggregates with GROUP BY and ORDER BY fails when column aliases don't match

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2379 UNION ALL with ORDER BY fails when column aliases don't match

          • Major - Major loss of function.
          • Closed

          Activity

            People

              seanhychu Sean Hsuan-Yi Chu
              agirish Abhishek Girish
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: