Phoenix logging

log4j.properties

log4j.rootLogger=TRACE, A1
log4j.appender.A1=org.apache.log4j.RollingFileAppender
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.maxFileSize=100GB
log4j.appender.A1.File=/tmp/phoenix-query.log

# Print the date in ISO 8601 format
log4j.appender.A1.layout.ConversionPattern=%d [%t] %-5p %c - %m%n

#Adding properties to dump the SQL into the log file
log4j.logger.org.apache.calcite.avatica=TRACE
log4j.logger.org.apache.phoenix.queryserver.server=TRACE
log4j.logger.org.eclipse.jetty.server=TRACE
log4j.logger.java.sql.ResultSet=TRACE
log4j.logger.org.apache.calcite.avatica=TRACE
log4j.logger.org.apache.phoenix.queryserver.server=TRACE
log4j.logger.org.eclipse.jetty.server=TRACE
log4j.logger.org.apache.phoenix.shaded=TRACE
log4j.org.apache.calcite.avatica.remote.Driver=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixStatement=TRACE
log4j.org.apache.phoenix.jdbc=TRACE

log4j.org.apache.phoenix.jdbc.PhoenixResultSet=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixPreparedStatement=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixDatabaseMetaData=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixParameterMetaData=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixStatementFactory=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixResultSetMetaData=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixEmbeddedDriver=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixDriver=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixConnection=TRACE
log4j.org.apache.phoenix.jdbc.PhoenixStatement=TRACE
log4j.org.apache.phoenix.util.JDBCUtil=TRACE


# Custom Logging levels
log4j.logger.org.apache.zookeeper=TRACE
log4j.logger.org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper=TRACE
log4j.logger.org.apache.hadoop.hbase.zookeeper.ZKUtil=TRACE
log4j.logger.org.apache.hadoop.hbase.HBaseConfiguration=TRACE