Details
-
New Feature
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
2.3.2
-
None
-
None
Description
Synopsis:
=========
Prevent execution of very large queries.
Feature Request:
================
Please enhance Hive with a parameter to restrict the execution of very large queries.
Use case: User is trying to create a view with a size of 8 MB. Creation of this view was possible after increasing heap memory in several components (HMS, HS2, Zookeeper). However, this view caused major issues when it was used in a CTE query which resulted in GC pauses and eventually OOM of the HS2 process.
Although, it is possible to create the view, it may cause other issues when used in queries. From the Hadoop administrator point of view, it would be good to restrict this type of queries.