Multi Node HDP 2.5 cluster - Hiveserver 2 and Hive

[#1]

I've a multi-node HDP Cluster (v 2.5.3), and i'm trying to install Hive.

I've a basic question, Does installing Hive install HiveServer2 component as well ? Or does HiveServer2 need to be installed separately ?

Can i have Hiveserver2 installed on a separate m/c (from where Hive is installed)...

Pls. let me know. Thnx.

[#2]

@Karan Alang

1. Does installing Hive install HiveServer2 component as well ? Or does HiveServer2 need to be installed separately ?

HiveServer2 is a server interface that enables remote clients to connect to Hive. This is independent of Hive and must be installed separately. When using Ambari, it's just a matter of one checkbox. Please see the diagram on the following page for what constitutes Hive (It's very simple and you'll see that HiveServer2 is not part of Hive):

https://cwiki.apache.org/confluence/display/Hive/Design

2. Can i have Hiveserver2 installed on a separate m/c (from where Hive is installed)

Yes. This can be done easily. In some cases, it might even be a good idea.

[#3]

@mqureshi - thanks for the response ..

related question, when i installed HiveServer2 on Node-07, and Hive Metastore on Node-06 - HiveServer2 was not starting up - from Ambari.(pls. see log files & hive-site.xml attached). However, i was able to start it from command line from Node06 .. any idea on what the issue might be or how to debug this ?

I've captured the logs in this issue -

https://community.hortonworks.com/questions/96605/hiveserver2-not-starting-up-1.html#answer-96621

hiveserver2-notstartingup-1.pdf

hive-sitexml.txt

hiveserver2log.txt

I'd to re-install HiveServer2 on Node-06 to get it started (from Ambari).