HIVE-29026: Cleanup Log4j properties file to adhere to 2.x changes

HIVE-28983: Log HS2 and HMS PID and update hive-env.sh template

HIVE-29068: Drop deprecated compactor.history.retention.attempted property