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

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

    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.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

            People

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

              Dates

                Created:
                Updated:
                Resolved: