First confirm a simple query is working, select * limit 1. If you're getting data back, it means your installation is (probably, mostly) correct.
After that, take a long look at the explain plan of your desired query. If you've got any data at all and a full table scan, you can easily exceed the default timeout. Make sure you're using indices and skip scans where possible. Filters mean you're falling back to evaluating data. -n On Mon, Nov 13, 2017 at 11:56 AM Pavani Addanki <pavani.adda...@gmail.com> wrote: > Hi All, > > I am getting the below error while trying to query on Phoenix. > > org.apache.phoenix.exception.PhoenixIOException: Failed after > attempts=36,execptions: > java.net.SocketTimeoutException:callTimeout=60000,callDuration=60100. > > failed on local exception: > > org.apache.hadoop.hbase.ipc.CallTimeoutException:waitTime=60000,operationTimeout=59999 > expired. > > > I increased the value of phoenix.query.timeoutMs to 180000 and the file > hbase-site.xml is in the classpath. > > DId anyone face the same issue and resolve it. > > Pavani A >