Query execution failed

[Pavani Addanki <pa...@gmail.com>]

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

Re: Query execution failed

[Nick Dimiduk <nd...@gmail.com>]

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 <pa...@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
>