Reply
Highlighted
Explorer
Posts: 22
Registered: ‎04-26-2016
Accepted Solution

How to loginto the Hive server 2

I log into Hue editor and able to access impala or hive and run queries against hadoop fs.

 

How to log into hive server 2, is there a web based interface available,

 

we are on CDH 5.7.1

 

Could you please provide any commands if need to be used in order to log into hive server 2.

 

Thank you for the helpful info.

 

Posts: 137
Topics: 7
Kudos: 15
Solutions: 14
Registered: ‎07-16-2015

Re: How to loginto the Hive server 2

What kind of web based interface do you need from HiveServer2 ?

 

If it is a user interface for querying Hive then HiveServer2 do not provide one OOTB.

But Know that Hue is using HiveServer2 when you are submitting hive queries inside the "Hive Editor".

New Contributor
Posts: 5
Registered: ‎01-11-2017

Re: How to loginto the Hive server 2

Hi cpluplus1, 

 

To log into hive server 2 by command line you need this:

 

$ beeline -u "jdbc:hive2://hive_node:10000/;principal=hive/_HOST@ad_domain

 

To log into hive server 2 web UI:

 

http://hive_node:10002/

 

To run queries from HUE into Hive:

 

https://hue_node:8888/notebook/editor?type=hive

 

With which user are you logging into hue? Maybe you don't have enough privileges to access in hive query editor, can you access with administration user and validate it?

 

Marc.

Announcements