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

Fix multi-insert query and write qtests

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • Logical Optimizer
    • None

    Description

      On HIVE-16415, it was found that the bug reported to be fixed in HIVE-14519 was not actually fixed.

      This task is to find the problem, fix it, and add qtests to verify no future regression.

      Specifically, the following query does not produce correct answers:

      From (select * from src) a
      insert overwrite directory '/tmp/emp/dir1/'
      select key, value
      insert overwrite directory '/tmp/emp/dir2/'
      select 'header'
      limit 0
      insert overwrite directory '/tmp/emp/dir3/'
      select key, value 
      where key = 100;
      

      This gives incorrect result in master. All dirs end up with 0 rows instead of just dir2.

      Attachments

        1. HIVE-16427.1.patch
          4 kB
          Yongzhi Chen
        2. HIVE-16427.2.patch
          8 kB
          Yongzhi Chen
        3. HIVE-16427.3.patch
          8 kB
          Yongzhi Chen

        Issue Links

          Activity

            People

              ychena Yongzhi Chen
              poeppt Thomas Poepping
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: