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

TPCH q16 return wrong result when CBO is on

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.2, 2.0.0
    • 2.1.0
    • CBO, Logical Optimizer
    • None

    Description

      Running tpch with factor 2,
      q16 returns 1,160 rows when CBO is on,
      while returns 24,581 rows when CBO is off.
      See attachment for detail .

      Attachments

        1. explain_cbo_bad_part1.out
          17 kB
          Nemon Lou
        2. explain_cbo_bad_part2.out
          21 kB
          Nemon Lou
        3. explain_cbo_bad_part3.out
          12 kB
          Nemon Lou
        4. calcite_cbo_bad.out
          8 kB
          Nemon Lou
        5. calcite_cbo_good.out
          7 kB
          Nemon Lou
        6. explain_cbo_good(rewrite)_part1.out
          17 kB
          Nemon Lou
        7. explain_cbo_good(rewrite)_part2.out
          17 kB
          Nemon Lou
        8. explain_cbo_good(rewrite)_part3.out
          15 kB
          Nemon Lou
        9. HIVE-13602.01.patch
          36 kB
          Pengcheng Xiong
        10. HIVE-13602.03.patch
          184 kB
          Pengcheng Xiong
        11. HIVE-13602.04.patch
          69 kB
          Pengcheng Xiong
        12. HIVE-13602.05.patch
          95 kB
          Pengcheng Xiong
        13. HIVE-13602.final.patch
          116 kB
          Pengcheng Xiong

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-14705 Hive outer queries is not picking up the right column from subqueries

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-13733 CTE + "IS NULL" predicate + column aliasing as existing column leads to wrong results

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15495 subquery's column alias can not be the same with partition column name

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15888 constant propagation optimizer failed when query has the same alias with subquery

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link RB request

          Activity

            People

              pxiong Pengcheng Xiong
              nemon Nemon Lou
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: