[
https://issues.apache.org/jira/browse/AMBARI-17006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15318115#comment-15318115
]
Masahiro Tanaka commented on AMBARI-17006:
------------------------------------------
Hi [~Sandeep Nemuri]
Can I write a patch to resolve this issue?
> Ambari should be able to use beeline command to check hive metastore health
> status
> ----------------------------------------------------------------------------------
>
> Key: AMBARI-17006
> URL: https://issues.apache.org/jira/browse/AMBARI-17006
> Project: Ambari
> Issue Type: Improvement
> Components: alerts
> Affects Versions: 2.2.1.1
> Environment: Ambari 2.2.2.1
> Reporter: Sandeep Nemuri
> Priority: Minor
>
> BACKGROUND:
> Hive cli is disabled by adding below lines to hive-env-template in hive
> configuration.
> {code}
> if [ "$SERVICE" = "cli" ]; then
> echo "Sorry! hive cli has been disabled for security purpose, please use
> beeline instead."
> exit 1
> fi
> {code}
> PROBLEM :
> After disabling the hive shell , Ambari is reporting that the hive metastore
> is in critical state.
> Below is the error:
> {code}
> Metastore on metastorehost.com failed (Traceback (most recent call last):
> File
> "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_metastore.py",
> line 183, in execute
> timeout=int(check_command_timeout) )
> File "/usr/lib/python2.6/site-packages/resource_management/core/base.py",
> line 154, in __init__
> self.env.run()
> File
> "/usr/lib/python2.6/site-packages/resource_management/core/environment.py",
> line 158, in run
> self.run_action(resource, action)
> File
> "/usr/lib/python2.6/site-packages/resource_management/core/environment.py",
> line 121, in run_action
> provider_action()
> File
> "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py",
> line 238, in action_run
> tries=self.resource.tries, try_sleep=self.resource.try_sleep)
> File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py",
> line 70, in inner
> result = function(command, **kwargs)
> File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py",
> line 92, in checked_call
> tries=tries, try_sleep=try_sleep)
> File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py",
> line 140, in _call_wrapper
> result = _call(command, **kwargs_copy)
> File "/usr/lib/python2.6/site-packages/resource_management/core/shell.py",
> line 291, in _call
> raise Fail(err_msg)
> Fail: Execution of 'export
> HIVE_CONF_DIR='/usr/hdp/current/hive-metastore/conf/conf.server' ; hive
> --hiveconf hive.metastore.uris=thrift://xxxxxxxxxxxxx:9083 --hiveconf
> hive.metastore.client.connect.retry.delay=1 --hiveconf
> hive.metastore.failure.retries=1 --hiveconf hive.metastore.connect.retries=1
> --hiveconf hive.metastore.client.socket.timeout=14 --hiveconf
> hive.execution.engine=mr -e 'show databases;'' returned 1. stty: standard
> input: Inappropriate ioctl for device
> tset: standard error: Invalid argument
> stty: standard input: Inappropriate ioctl for device
> stty: standard input: Inappropriate ioctl for device
> Value of TERM has been set to "dumb".
> stty: standard input: Inappropriate ioctl for device
> Sorry! hive cli has been disabled for security purpose, please use beeline
> instead.
> logout root
> )
> {code}
> Since ambari scripts are using hive command to get the metastore health
> status the health check is failing.
> {code}
> hive --hiveconf hive.metastore.uris=thrift://hostname:9083 --hiveconf
> hive.metastore.client.connect.retry.delay=1 --hiveconf
> hive.metastore.failure.retries=1 --hiveconf hive.metastore.connect.retries=1
> --hiveconf hive.metastore.client.socket.timeout=14 --hiveconf
> hive.execution.engine=mr -e 'show databases;''
> {code}
> This is a feature enhancement request to use the beeline command to check
> hive meta store health status.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
