You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Luis E Martinez-Poblete (JIRA)" <ji...@apache.org> on 2018/06/01 14:53:00 UTC

[jira] [Created] (HIVE-19763) Prevent execution of very large queries

Luis E Martinez-Poblete created HIVE-19763:
----------------------------------------------

             Summary: Prevent execution of very large queries
                 Key: HIVE-19763
                 URL: https://issues.apache.org/jira/browse/HIVE-19763
             Project: Hive
          Issue Type: New Feature
          Components: HiveServer2
    Affects Versions: 2.3.2
            Reporter: Luis E Martinez-Poblete


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.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)