Enable logging for client connections and running queries with Phoenix Query Server

Enable logging for client connections and running queries with Phoenix Query Server

Phoenix Query server (PQS) does not log details about client connections and the queries run using the default log level of INFO. It is required to modify the log4j configuration for certain classes to obtain such logs.

To enable logging such messages by PQS, perform the following:

1. On the node that runs PQS service, edit the file: ‘/usr/hdp/current/phoenix-server/bin/log4j.properties’, and add/replace the following properties:

               log4j.threshold=DEBUG
log4j.logger.org.apache.phoenix.queryserver=DEBUG
log4j.logger.org.apache.phoenix.queryserver.server=DEBUG
log4j.logger.org.apache.phoenix=DEBUG
log4j.logger.org.eclipse.jetty.io.AbstractEndPoint=DEBUG

2. Restart the Phoenix Query Server on the node.

Note: It is important to understand that by increasing the logging level using the steps above, the PQS log file size increases faster in comparison to the default logging level.