Ok - I think I found it: phoenix.query.timeoutMs M.
2015-04-07 11:46 GMT+02:00 Marek Wiewiorka <[email protected]>: > Hi All - I keep on getting operation timeout errors while running queries: > Error: Operation timed out (state=TIM01,code=6000) > java.sql.SQLTimeoutException: Operation timed out > at > org.apache.phoenix.exception.SQLExceptionCode$14.newException(SQLExceptionCode.java:313) > at > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:583) > at > org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50) > at > org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97) > at > org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117) > at > org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:679) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:280) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:272) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:270) > at > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1063) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:808) > at sqlline.SqlLine.begin(SqlLine.java:681) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) > > > I've already set the following properties in hbase-site: > > <property> > <name>zookeeper.session.timeout</name> > <value>90000000</value> > </property> > <property> > <name>hbase.rpc.timeout</name> > <value>90000000</value> > </property> > <property> > <name>hbase.client.scanner.timeout.period</name> > <value>90000000</value> > </property> > > But the problem still persists - could you please advise me what other > properties should I consider to set? > > Thanks! > Marek > >
