hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <>
Subject [jira] [Commented] (HIVE-19763) Prevent execution of very large queries
Date Tue, 26 Jun 2018 18:40:00 GMT


Sergey Shelukhin commented on HIVE-19763:

Sounds like we need more strict checks :)

> Prevent execution of very large queries
> ---------------------------------------
>                 Key: HIVE-19763
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>          Components: HiveServer2
>    Affects Versions: 2.3.2
>            Reporter: Luis E Martinez-Poblete
>            Priority: Minor
> 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

View raw message