[HIVE-9499] hive.limit.query.max.table.partition makes queries fail on non-partitioned tables

• 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
• Assignee: Navis Ryu
• Reporter: Alexander Kasper
• Created: 28/Jan/15 16:45
• Updated: 28/Nov/16 17:20
• Resolved: 25/Mar/16 02:12

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

Issue Links

• relates to: HIVE-12603 Add config to block queries that scan > N number of partitions
• links to: review board