question Re: creat script that stop hive on My cluster in Archives of Support Questions (Read Only)

creat script that stop hive on My cluster

sihi_yassine — Tue, 20 Feb 2018 18:11:39 GMT

I need to create a script shell that stops the Hive Metastore and Hive Server2 from any node of cluster and I need to know where the hive is hosted in My cluster in order to run this command:

ssh nodename:ps aux | awk '{print $1,$2}' | grep hive | awk '{print $2}' | xargs kill >/dev/null 2>&1

how can I know where nodes hive is hosted?

Re: creat script that stop hive on My cluster

jsensharma — Tue, 20 Feb 2018 18:37:30 GMT

@yassine sihi

If you have Ambari managed cluster then you can find that information just by a simple API call:

1. To findout Hive metastore host:

# curl -u admin:admin -H "X-Requested-By: ambari" -X GET http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE/components/HIVE_METASTORE | grep 'host_name' | awk '{print $NF}'

2. To findout Hive Server2 host.

# curl -u admin:admin -H "X-Requested-By: ambari" -X GET http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE/components/HIVE_SERVER | grep 'host_name' | awk '{print $NF}'

You will need to replace "amb25101.example.com" with Ambari Server Hostname. Also the "plain_ambari" with your Ambari cluster name.

Re: creat script that stop hive on My cluster

sihi_yassine — Tue, 20 Feb 2018 18:40:00 GMT

@Jay Kumar SenSharma

is there some alternative to stop the whole service "hive service" on one command??

Re: creat script that stop hive on My cluster

jsensharma — Tue, 20 Feb 2018 18:41:43 GMT

@yassine sihi

Similarly you can use the following API calls to stop the HIveServer2 & Metastore:

To stop HiveServer2 on host "amb25103.example.com"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT  -d '{"RequestInfo":{"context":"Stop HiveServer2","operation_level":{"level":"HOST_COMPONENT","cluster_name":"plain_ambari","host_name":"amb25103.example.com","service_name":"HIVE"}},"Body":{"HostRoles":{"state":"INSTALLED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/hosts/amb25103.example.com/host_components/HIVE_SERVER?

To stop HiveMetastore on host "amb25103.example.com"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT  -d '{"RequestInfo":{"context":"Stop Hive Metastore","operation_level":{"level":"HOST_COMPONENT","cluster_name":"plain_ambari","host_name":"amb25103.example.com","service_name":"HIVE"}},"Body":{"HostRoles":{"state":"INSTALLED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/hosts/amb25103.example.com/host_components/HIVE_METASTORE?

Re: creat script that stop hive on My cluster

sihi_yassine — Tue, 20 Feb 2018 18:44:18 GMT

@Jay Kumar SenSharma

do I need to run the both command to stop hive, isn't there one command that can do this??

Re: creat script that stop hive on My cluster

jsensharma — Tue, 20 Feb 2018 18:44:48 GMT

@yassine sihi

To stop whole "Hive Service"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT -d '{"RequestInfo":{"context":"_PARSE_.START.HIVE","operation_level":{"level":"SERVICE","cluster_name":"plain_ambari","service_name":"HIVE"}},"Body":{"ServiceInfo":{"state":"INSTALLED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE

To start whole "Hive Service"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT -d '{"RequestInfo":{"context":"_PARSE_.START.HIVE","operation_level":{"level":"SERVICE","cluster_name":"plain_ambari","service_name":"HIVE"}},"Body":{"ServiceInfo":{"state":"STARTED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE

Re: creat script that stop hive on My cluster

sihi_yassine — Tue, 20 Feb 2018 18:53:06 GMT

@Jay Kumar SenSharma

Do I need to run the both command to stop hive service, isn't there one line command that can do this??

Re: creat script that stop hive on My cluster

jsensharma — Tue, 20 Feb 2018 18:58:27 GMT

@yassine sihi

One command is to To stop HiveServer2 on host "amb25103.example.com"

And the other command is to To stop HiveMetastore on host "amb25103.example.com"

If you want to stop the Whole Hive Service then please refer to my previous command in same thread:

To stop whole "Hive Service"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT -d '{"RequestInfo":{"context":"_PARSE_.START.HIVE","operation_level":{"level":"SERVICE","cluster_name":"plain_ambari","service_name":"HIVE"}},"Body":{"ServiceInfo":{"state":"INSTALLED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE

To start whole "Hive Service"

# curl -u admin:admin -H "X-Requested-By: ambari" -X PUT -d '{"RequestInfo":{"context":"_PARSE_.START.HIVE","operation_level":{"level":"SERVICE","cluster_name":"plain_ambari","service_name":"HIVE"}},"Body":{"ServiceInfo":{"state":"STARTED"}}}' http://amb25101.example.com:8080/api/v1/clusters/plain_ambari/services/HIVE

Re: creat script that stop hive on My cluster

sihi_yassine — Tue, 20 Feb 2018 19:39:01 GMT

ok thanks @Jay Kumar SenSharma

Re: creat script that stop hive on My cluster

jsensharma — Mon, 26 Feb 2018 04:34:25 GMT

@Yassine

If this answers your query then please mark this thread as answered by clicking on the "Accepted" button that way other HCC users can quickly browser the answered queries.