HiveServer, Thrift, Beeline

#1

We use Hive very frequently in our daily job !!!
But there are a lot of things, which we are not aware of ?
Can anyone clear my concepts ?

What is thrift client ?
HiveServer1 vs HiveServer2 ?
HiveServer2 vs beeline ?
How you will connect to Hive from beeline ?
Does it required to install Hive service on every Nodes in your Hadoop Cluster ?

0 Likes

#2

What is thrift client ?
If you want use non java based programming languages to connect to hive database, we need to have thrift server

HiveServer1 vs HiveServer2 ?
HiveServer1 and HiveServer2 are used to connect external applications to hive database and issue queries - example visualization tools such as Tableau. HiveServer2 is latest version.

HiveServer2 vs beeline ?
I think beeline provide CLI using JDBC.

How you will connect to Hive from beeline ?
Not explored yet

Does it required to install Hive service on every Nodes in your Hadoop Cluster ?
No, you do not need to set up Hive service on all the nodes. It is enough to setup on gateway node.

3 Likes

#3

what about WebHCat Server?

0 Likes

#4

WebHCat server is to get metadata from hive metastore using APIs. API is called HCatalog.

2 Likes