Whenever I run a non-typical query (not filtered by the primary key), I get an
exception like this one.
I tried modifying each of the following in custom hbase-site to increase the
timeout:
Hbase.client.scanner.timeout.period
Hbase.regionserver.lease.period
Hbase.rpc.shortoperation.timeout
Hbase.rpc.timeout
Phoenix.query.timeoutMs
Zookeeper.timeout.session
I set each of these to 180000 ms, but I still get a timeout after 60 seconds.
Does anyone know the solution?
0: jdbc:phoenix:<my server>> select count(*) from <my table>;
+------------+
| COUNT(1) |
+------------+
java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException:
org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36,
exceptions:
Mon Jun 15 09:44:44 EDT 2015, null, java.net.SocketTimeoutException:
callTimeout=60000, callDuration=62368: row '' on table <my table>' at
region=<table>,,1433266684799.7461878881e30de657bd24287a9a0df3.,
hostname=<host>,60020,1434375522489, seqNum=62
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440)
at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074)
at sqlline.SqlLine.print(SqlLine.java:1735)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3683)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
