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

hive.limit.query.max.table.partition makes queries fail on non-partitioned tables

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: Closed
    • Major
    • Resolution: Fixed
    • 0.14.0, 1.0.0, 1.1.0, 1.2.0, 2.0.0
    • 2.0.1, 2.1.0
    • Query Planning
    • None

    Description

      If you use hive.limit.query.max.table.partition to limit the amount of partitions that can be queried it makes queries on non-partitioned tables fail.

      Example:

      CREATE TABLE tmp(test INT);
      SELECT COUNT(*) FROM TMP; -- works fine
      SET hive.limit.query.max.table.partition=20;
      SELECT COUNT(*) FROM TMP; -- generates NPE (FAILED: NullPointerException null)
      SET hive.limit.query.max.table.partition=-1;
      SELECT COUNT(*) FROM TMP; -- works fine again
      

      Attachments

        1. HIVE-9499.3.patch.txt
          3 kB
          Navis Ryu
        2. HIVE-9499.2.patch.txt
          3 kB
          Navis Ryu
        3. HIVE-9499.1.patch.txt
          2 kB
          Navis Ryu

        Issue Links

        Activity

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

          People

            navis Navis Ryu Assign to me
            AnLei Alexander Kasper
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment