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

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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.14.0, 1.0.0, 1.1.0, 1.2.0, 1.3.0, 2.0.0
    • 1.2.1
    • None
    • 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-branch-1.0.patch
          2 kB
          Prasanth Jayachandran
        2. HIVE-11035.patch
          2 kB
          Prasanth Jayachandran

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            prasanth_j Prasanth Jayachandran Assign to me
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment