How to loginto the Hive server 2

[#1]

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.

[#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".

[#3 · Accepted solution]

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.