Support Questions
Find answers, ask questions, and share your expertise

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

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

could anyone help here?

1 ACCEPTED SOLUTION

Accepted Solutions

Cloudera Employee

@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.

View solution in original post

2 REPLIES 2

Cloudera Employee

@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.

View solution in original post

Thank you! This was helpful.