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

Fix Union All Operator

    XMLWordPrintableJSON

Details

    Description

      The current specification/behavior of UNION ALL is not well defined.
      This issue attempts to reach agreement on the expected behavior of UNION ALL.

      A link for the latest design document is below:
      https://docs.google.com/document/d/1OQFQ6IvdeBJkDLKHFBlwP3tle2WuzpBgZf6R_6Vh0mw/edit
      ..............................................................................................................................

      An example of the current implementation:
      (select n_name from cp.`tpch/nation.parquet` limit 1)" +
      "UNION ALL " +
      "(select r_name from cp.`tpch/region.parquet` limit 1);

      returns:

      n_name
      ALGERIA
      r_name
      AFRICA

      Attachments

        1. DRILL-2207.1.patch
          75 kB
          Sean Hsuan-Yi Chu

        Issue Links

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. DRILL-1847 Union All does not match corresponding columns by index to union columns

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

          Bug - A problem which impairs or prevents the functions of the product. DRILL-1886 NPE in queries with a project on a subquery with Union all

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. DRILL-1923 Unexpected exception when one column of a leg of a UNION ALL is a numeric constant

          • Major - Major loss of function.
          • Resolved

          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-2203 DISTINCT over UNION ALL subquery with fully qualified column names returns wrong result

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

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2204 DISTINCT statement over UNION ALL subquery asserts during execution with streaming aggregation

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2317 UNION ALL on sub-queries with single column projection fails on GROUP BY

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DRILL-2376 UNION ALL on Aggregates with GROUP BY returns incomplete results

          • Major - Major loss of function.
          • 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
              seanhychu Sean Hsuan-Yi Chu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: