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

UnionProcessor misses results for multi-insert when hive.optimize.union.remove=true

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None
    • None

    Description

      To reproduce:

      In union_remove_6.q, just change

      FROM (
      SELECT key, count(1) as values from inputTbl1 group by key
      UNION ALL
      SELECT key, count(1) as values from inputTbl1 group by key
      ) a
      insert overwrite table outputTbl1 select *
      insert overwrite table outputTbl2 select *;

      to

      FROM (
      select * from(
      SELECT key, count(1) as values from inputTbl1 group by key
      UNION ALL
      SELECT key, count(1) as values from inputTbl1 group by key
      )subq
      ) a
      insert overwrite table outputTbl1 select *
      insert overwrite table outputTbl2 select *;

      select * from outputtbl2 will output nothing

      Attachments

        1. HIVE-9217.03.patch
          36 kB
          Pengcheng Xiong
        2. HIVE-9217.02.patch
          16 kB
          Pengcheng Xiong
        3. HIVE-9217.01.patch
          15 kB
          Pengcheng Xiong

        Issue Links

          Activity

            People

              pxiong Pengcheng Xiong
              pxiong Pengcheng Xiong
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: