My application runs on Tomcat server. The phoenix-client-4.4.0-HBase-1.1.jar is
deployed to $CATALINA_HOME/lib folder for the application to access HBase
tables via Phoenix. Tomcat's catalina.out shows a lot of Phoenix debugging
message. How to change Phoenix's log level from DEBUG to INFO?
9:52:53.585 [phoenix-1-thread-0] DEBUG o.a.p.iterate.BaseResultIterators -
Guideposts: ]
19:52:53.589 [phoenix-1-thread-0] DEBUG o.a.p.iterate.BaseResultIterators -
Getting iterators for ResultIterators
[name=PARALLEL,id=846567fb-66b2-4eac-9de5-4e55b8e31c7e,scans=[[{"timeRange":[0,1455069173375],"batch":-1,"startRow":"204-MBB-097\\x80\\x00\\x00e\\x80\\x00\\x01R\\xA5Iu\\xE9","stopRow":"204-MBB-097\\x80\\x00\\x00e\\x80\\x00\\x01R\\xBF\\x09A\\xE9","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":-1,"maxVersions":1,"filter":"FilterList
AND (2/2): [FirstKeyOnlyFilter, ]","caching":2147483647}]]]
19:52:53.706 [phoenix-1-thread-1] DEBUG o.a.p.iterate.ParallelIterators - Id:
846567fb-66b2-4eac-9de5-4e55b8e31c7e, Time: 114ms, Scan:
{"timeRange":[0,1455069173375],"batch":-1,"startRow":"204-MBB-097\\x80\\x00\\x00e\\x80\\x00\\x01R\\xA5Iu\\xE9","stopRow":"204-MBB-097\\x80\\x00\\x00e\\x80\\x00\\x01R\\xBF\\x09A\\xE9","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":2097152,"maxVersions":1,"filter":"FilterList
AND (2/2): [FirstKeyOnlyFilter, ]","caching":2147483647}
...
19:52:53.718 [http-bio-8080-exec-2] DEBUG o.a.phoenix.jdbc.PhoenixStatement -
Explain plan:
19:52:53.904 [http-bio-8080-exec-2] DEBUG o.a.phoenix.jdbc.PhoenixStatement -
Execute query: SELECT ...