https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-query-call-from-java-on-larger-data-set-fails-with/m-p/217940#M84255 <P>"waitTime=60001, operationTimeout=60000 expired"</P><P>You need to include hbase-site.xml on the classpath for your application. It is obvious from the error that the hbase.rpc.timeout and phoenix.query.timeoutMs are not being respected from this error.</P> Thu, 11 Oct 2018 21:47:20 GMT elserj 2018-10-11T21:47:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-query-call-from-java-on-larger-data-set-fails-with/m-p/217939#M84254 <P>I have a table with billions of records. When I run the following query "select count(*) from table" via <STRONG>sqlline it is working fine</STRONG>. But when I am trying count <STRONG>query</STRONG><STRONG> from java class,</STRONG> I am getting timeout error. I am using <STRONG>phoenix JDBC thin driver </STRONG>to connect and run the query from a java class. For a small recordset, it is working fine. I have set the following configuration in connection properties and the same configuration are available on HBase.</P><PRE>phoenix.query.threadPoolSize = 500 phoenix.query.queueSize = 10000 hbase.client.scanner.timeout.period= 1800000 hbase.rpc.timeout = 1800000 phoenix.query.timeoutMs = 1800000 phoenix.query.keepAliveMs = 1800000 hbase.regionserver.lease.period =1800000 hbase.client.scanner.caching =1800000</PRE><P>java.util.concurrent.ExecutionException: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=6, exceptions: Wed Oct 10 14:21:38 EDT 2018, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=60302: Call to host_name failed on local exception: org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=156243, waitTime=60001, operationTimeout=60000 expired. row '13908?RB??D??%?=' on table 'Table_name' at region=Table_name,\x02\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1528398264217.4677856e7ec417f1e1f2f50d71b31d9c., hostname=host,16020,1538041266262, seqNum=5357</P> Thu, 11 Oct 2018 20:58:24 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-query-call-from-java-on-larger-data-set-fails-with/m-p/217939#M84254 paragpannase23 2018-10-11T20:58:24Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-query-call-from-java-on-larger-data-set-fails-with/m-p/217940#M84255 <P>"waitTime=60001, operationTimeout=60000 expired"</P><P>You need to include hbase-site.xml on the classpath for your application. It is obvious from the error that the hbase.rpc.timeout and phoenix.query.timeoutMs are not being respected from this error.</P> Thu, 11 Oct 2018 21:47:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Phoenix-query-call-from-java-on-larger-data-set-fails-with/m-p/217940#M84255 elserj 2018-10-11T21:47:20Z