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 BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.14.0, 1.0.0, 1.1.0, 1.2.0, 2.0.0
    • Fix Version/s: 2.0.1, 2.1.0
    • Component/s: Query Planning
    • Labels:
      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.1.patch.txt
          2 kB
          Navis Ryu
        2. HIVE-9499.2.patch.txt
          3 kB
          Navis Ryu
        3. HIVE-9499.3.patch.txt
          3 kB
          Navis Ryu

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              navis Navis Ryu Assign to me
              Reporter:
              AnLei Alexander Kasper

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment