[
https://issues.apache.org/jira/browse/HIVE-4470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13720398#comment-13720398
]
Edward Capriolo commented on HIVE-4470:
---------------------------------------
{quote}
But on the other hand, if you have 10's or 100s of queries running
concurrently, having them run locally will potentially slow things down,
because of high resource utilization on HS2 machine. When we have something
like MR framework that does a good job of resource allocation, we should use
that.
{quote}
Does the user only have 1 HS2 machine? For redundancy you want 2, but
technically you could run N HiveServers and put a load balancer in front of
them. That is what we do with hive-server1. Users always do bad things, you can
not stop them from shooting themselves :)
{quote}
I did a poor job of describing what I meant. What I mean is this should be a
HS2 admin flag, that users who connect using jdbc should not be allowed to
override for their query. Admins themselves should be able to configure HS2 the
way they want.
{quote}
This sounds good. Although there are plenty of potentially dangerous flags in
there outside of this one. This starts getting into the same mess hive auth is
in. Like who polices the police? with config options to stop other config
options.
> HS2 should disable local query execution
> ----------------------------------------
>
> Key: HIVE-4470
> URL: https://issues.apache.org/jira/browse/HIVE-4470
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Reporter: Thejas M Nair
>
> Hive can run queries in local mode (instead of using a cluster), if the size
> is small. This happens when "hive.exec.mode.local.auto" is set to true.
> This would affect the stability of the hive server2 node, if you have heavy
> query processing happening on it. Bugs in udfs triggered by a bad record can
> potentially add very heavy load making the server inaccessible.
> By default, HS2 should set these parameters to disallow local execution or
> send and error message if user tries to set these.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
