question Re: How do I view Session and Query details in hiveserver2 web UI? in Support Questions

How do I view Session and Query details in hiveserver2 web UI?

vi1 — Wed, 01 Mar 2023 14:27:22 GMT

hiveserver2 web UI page opens but cannot see any details like no of active users and all .I am using cdp 7.1.3 in which kerberos and ranger both are enable..how to resolve this ?

Re: How do I view Session and Query details in hiveserver2 web UI?

cjervis — Wed, 01 Mar 2023 14:37:19 GMT

Hi @vi1 and thank you for the question. I found documentation for Activating the Hive Web UI that states.

HiveServer2 GUI/ Web UI does not display active client connections after enabling Kerberos. You must correct this problem, which leads to a Kerberos ticket problem for a browser client.

The documentation goes into details on the steps to take. Hopefully this helps.

Re: How do I view Session and Query details in hiveserver2 web UI?

vi1 — Thu, 02 Mar 2023 18:01:02 GMT

Thanks @cjervis for the reply.. I already followed this document which you have shared with me but it doesn't work.

Re: How do I view Session and Query details in hiveserver2 web UI?

cjervis — Thu, 02 Mar 2023 18:27:08 GMT

I'm sorry to hear that. I'm not an expert but hoped it would be helpful while you waited for a more knowledgable member of the community to respond.

Re: How do I view Session and Query details in hiveserver2 web UI?

vi1 — Fri, 03 Mar 2023 19:20:34 GMT

Hello community please help me out! Iam still unable to activate hiveserver2 web UI.

Re: How do I view Session and Query details in hiveserver2 web UI?

vijithv — Fri, 05 Jul 2024 05:04:44 GMT

Found another Cloudera KB, where it says:

To resolve this issue we have to set this property hadoop.security.authorization to false under hive safety valve as this will be used only by Hive without impacting the storage, since it cannot be set to false at storage layer as it is needed for storage.

STEPS TO SET THE PROPERTY:

CM < Hive on tez < Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml

Name: hadoop.security.authorization
Value: false