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

PPD: Orc Split elimination fails because filterColumns=[-1]

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.14.0, 1.0.0, 1.1.0, 1.2.0, 1.3.0, 2.0.0
    • Fix Version/s: 1.2.1
    • Component/s: None
    • Labels:
      None

      Description

      create temporary table xx (x int) stored as orc ;
      insert into xx values (20),(200);
      set hive.fetch.task.conversion=none;
      select * from xx where x is null;
      

      This should generate zero tasks after optional split elimination in the app master, instead of generating the 1 task which for sure hits the row-index filters and removes all rows anyway.

      Right now, this runs 1 task for the stripe containing (min=20, max=200, has_null=false), which is broken.

      Instead, it returns YES_NO_NULL from the following default case

      https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcInputFormat.java#L976

        Attachments

        1. HIVE-11035.patch
          2 kB
          Prasanth Jayachandran
        2. HIVE-11035-branch-1.0.patch
          2 kB
          Prasanth Jayachandran

          Issue Links

            Activity

              People

              • Assignee:
                prasanth_j Prasanth Jayachandran
                Reporter:
                gopalv Gopal Vijayaraghavan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: