Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18201

Disable XPROD_EDGE for sq_count_check() created for scalar subqueries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 4.0.0-alpha-1
    • None
    • None

    Description

      sq_count_check() will either return an error at runtime or a single row. In case of query6, the subquery has avg() function that should return a single row. Attaching the explain.

      This does not need an x-prod, because it is not useful to shuffle the big table side for a cross-product against 1 row.

      Attachments

        1. HIVE-18201.1.patch
          14 kB
          Ashutosh Chauhan
        2. HIVE-18201.2.patch
          63 kB
          Ashutosh Chauhan
        3. HIVE-18201.3.patch
          114 kB
          Ashutosh Chauhan
        4. query6.explain2.out
          61 kB
          Nita Dembla

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-20281 SharedWorkOptimizer fails with 'operator cache contents and actual plan differ'

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16002 Correlated IN subquery with aggregate asserts in sq_count_check UDF

          • Major - Major loss of function.
          • Closed

          Activity

            People

              ashutoshc Ashutosh Chauhan
              ndembla Nita Dembla
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: