How to set the logging level of the hiveserver2Interactive.log to DEBUG in HDP3?

[#1]

I want to set logging level of  hiveserver2Interactive.log to DEBUG in HDP-3.1.

could anyone help here?

[#2 · Accepted solution]

@kuldeephawks 

1. Enable debug for HiveServer Interactive from Ambari -> Hive -> Configs -> Advanced hive-log4j2.
Update below property and set it to DEBUG:
property.hive.log.level = DEBUG
2. Restart HSI

or

From ambari > Hive > Configs > Hive log level > change to DEBUG from INFO.

[#3]

Thank you! This was helpful.