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

incorrect results for not in on partition columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 2.1.0, 2.2.0
    • 2.1.1, 2.2.0
    • None
    • None

    Description

      create table foo (i int) partitioned by (s string);
      
      insert overwrite table foo partition(s='foo') select cint from alltypesorc limit 10;
      insert overwrite table foo partition(s='bar') select cint from alltypesorc limit 10;
      
      select * from foo where s not in ('bar');
      

      No results. IN ... works correctly

      Attachments

        1. HIVE-14652.01.patch
          27 kB
          Sergey Shelukhin
        2. HIVE-14652.02.patch
          30 kB
          Sergey Shelukhin
        3. HIVE-14652.03.patch
          30 kB
          Sergey Shelukhin
        4. HIVE-14652.patch
          29 kB
          Sergey Shelukhin

        Issue Links

          Activity

            People

              sershe Sergey Shelukhin
              spragues stephen sprague
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: