Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Support Questions

Find answers, ask questions, and share your expertise
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!

Hive metastore log files are not getting cleaned up automatically in CDP

avatar
Explorer

-rw-r--r--.  1 hive hive 209715489 Jan  20 23:21 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-20-5
-rw-r--r--.  1 hive hive 209715610 Jan  21 04:31 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-21-1
-rw-r--r--.  1 hive hive 209715215 Jan  21 09:38 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-21-2
-rw-r--r--.  1 hive hive 209715271 Jan  21 14:43 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-21-3
-rw-r--r--.  1 hive hive 209715387 Jan  21 19:50 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-21-4
-rw-r--r--.  1 hive hive 209715339 Jan  22 00:54 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-22-1
-rw-r--r--.  1 hive hive 209715439 Jan  22 05:55 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-22-2
-rw-r--r--.  1 hive hive 209715509 Jan  22 11:08 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-22-3
-rw-r--r--.  1 hive hive 209715418 Jan  22 18:08 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-22-4
-rw-r--r--.  1 hive hive 209715222 Jan  22 23:20 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-22-5
-rw-r--r--.  1 hive hive 209715221 Jan  23 04:14 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-23-1
-rw-r--r--.  1 hive hive 209715565 Jan  24 09:10 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-24-2
-rw-r--r--.  1 hive hive 209715318 Jan  24 14:34 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-24-3
-rw-r--r--.  1 hive hive 209715298 Jan  24 19:37 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-24-4
-rw-r--r--.  1 hive hive 209715216 Jan  26 01:07 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-26-1
-rw-r--r--.  1 hive hive 209715561 Jan  26 06:36 hadoop-cmf-hive-HIVEMETASTORE-masternode3.phenoix.test.com.log.out.2021-01-26-2

 

This is further occupying lot of disk space, could you please help?

1 ACCEPTED SOLUTION

avatar
Expert Contributor

Hey @saurabh707 

 

Could you please try the below:

 

Update hive log4j configs through CM 
Hive on Tez -> Configuration -> HiveServer2 Logging Advanced Configuration Snippet (Safety Valve)
Hive  -> Configuration -> Hive Metastore Server Logging Advanced Configuration Snippet (Safety Valve)

Add the following to config:

appender.DRFA.strategy.action.type=DELETE
appender.DRFA.strategy.action.basepath=${log.dir}
appender.DRFA.strategy.action.maxdepth=1
appender.DRFA.strategy.action.PathConditions.glob=${log.file}.*
appender.DRFA.strategy.action.PathConditions.type=IfFileName
appender.DRFA.strategy.action.PathConditions.nestedConditions.type=IfAccumulatedFileCount
appender.DRFA.strategy.action.PathConditions.nestedConditions.exceeds=10

 

Let me know if the above addresses it.

View solution in original post

2 REPLIES 2

avatar
Expert Contributor

Hey @saurabh707 

 

Could you please try the below:

 

Update hive log4j configs through CM 
Hive on Tez -> Configuration -> HiveServer2 Logging Advanced Configuration Snippet (Safety Valve)
Hive  -> Configuration -> Hive Metastore Server Logging Advanced Configuration Snippet (Safety Valve)

Add the following to config:

appender.DRFA.strategy.action.type=DELETE
appender.DRFA.strategy.action.basepath=${log.dir}
appender.DRFA.strategy.action.maxdepth=1
appender.DRFA.strategy.action.PathConditions.glob=${log.file}.*
appender.DRFA.strategy.action.PathConditions.type=IfFileName
appender.DRFA.strategy.action.PathConditions.nestedConditions.type=IfAccumulatedFileCount
appender.DRFA.strategy.action.PathConditions.nestedConditions.exceeds=10

 

Let me know if the above addresses it.

avatar
Explorer

Thank you for the help Tushar-san , 

understood, we can update log4j property