Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to change HiveServer2 Logging Threshold per beeline session

Highlighted

How to change HiveServer2 Logging Threshold per beeline session

Contributor

Hi

 

I have CDH 5.7.0

 

I need to debug problems with mapJoins resulting in Code 1 in mapred.localTask errors on HiveServer.

I must not raise HiveServer2 Logging Threshold, because it affects log in Hue Query Editor and my users with weak laptops can't work with Hue, because tons of logs killing their browsers.

 

I've already tried:

set hive.server2.logging.operation.enabled=true;
set hive.server2.logging.operation.verbose=true;
set hive.debug.localtask=true;

 

But those did not gave me any more feedback than I've already had.

 

Is it possible to raise HiveServer2 Logging Threshold in beeline session?

 

 

 

2 REPLIES 2

Re: How to change HiveServer2 Logging Threshold per beeline session

Champion

You can modify the  beeline-log4j.properties to log4j.rootLogger= Any level you like , console.

Re: How to change HiveServer2 Logging Threshold per beeline session

Cloudera Employee

Hi lsegrim,

 

In CDH 5.7.0, you could set hive.server2.logging.operation.level

to VERBOSE. You can set this configuration via the HiveServer2 safety valve

hive-site.xml in Cloudera Manager. 

 

See https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hi...

 

Note that hive.server2.logging.operation.enabled should also be set to true (which 

is the default via Cloudera Manager)

Don't have an account?
Coming from Hortonworks? Activate your account here