question Re: phoenix logs in Support Questions

phoenix logs

arunpoy — Thu, 12 May 2016 11:40:10 GMT

I am using phoenix to create a table in hbase and insert some rows. If the insert is successful, i dont see any message on the console. But if i do see some error, i do see the error in the console. I just want to know where should i look for the logs so that i can check whether any operation through phoenix is failure or success. Is there any place where i could look for phoenix logs.

I am usign HDP 2.4

Re: phoenix logs

asinghal — Thu, 12 May 2016 13:42:57 GMT

Modify PHOENIX_HOME/bin/log4j.properties to log DEBUG/INFO in logs or console. It will log in current_path/psql.log

psql.root.logger=DEBUG,console,DRFA

log4j.threshold=DEBUG

And, sqlline.py expects log4j.properties in current path (from where you are running the sqlline)

Re: phoenix logs

arunpoy — Thu, 12 May 2016 14:31:33 GMT

Thanks @asinghal, but how can we log when it is a used by a remote client like squirrel or dbvisualizer. How to tracke those logs?

Re: phoenix logs

asinghal — Thu, 12 May 2016 14:45:03 GMT

It seems , we can do in same way for squirrel.

http://stackoverflow.com/questions/23770235/squirrel-sql-exception-logging

JFYI , sqlline can also be used as a remote client.

Re: phoenix logs

aervits — Fri, 13 May 2016 16:52:08 GMT

Accepting your own answer is only valid if your own solution corrected your issue and nobody else provided the right answer. I unaccepted your answer as it is a response to the other person and moved it to comment. Community is only as good as the value we provide, please respect the rules and give credit where it's due.