HI,
I have set up below properties in hbase-site.xml but I stil get error with
timeout.
/usr/lib/phoenix/bin/sqlline-thin.py ip-10-120-1-129.qa.i-edo.net
I have set this in hbase-site.xml of phoenix and hbase too.
<property>
<name>phoenix.query.timeoutMs</name>
<value>18000000</value>
</property>
<property>
<name>phoenix.query.timeoutMs</name>
<value>18000000</value>
</property>
<property>
<name>hbase.rpc.timeout</name>
<value>18000000</value>
</property>
<property>
<name>hbase.client.scanner.timeout.period"</name>
<value>18000000</value>
</property>
-> SocketTimeoutException: callTimeout=60000, callDuration=60109: Call to
ip-10-120-1-227.qa.i-edo.net/10.120.1.227:16020 failed on local exception:
org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000 row '' on table 'prewards_event' at
region=prewards_event,,1464725388671.1a93bb2902ee8d2e08f1b08ab084c7d3.,
hostname=ip-10-120-1-227.qa.i-edo.net,16020,1663694862836, seqNum=4738591
-> IOException: Call to ip-10-120-1-227.qa.i-edo.net/10.120.1.227:16020
failed on local exception:
org.apache.hadoop.hbase.ipc.CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000 -> CallTimeoutException: Call id=2991,
waitTime=60009, rpcTimetout=60000
at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:54)
at
org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163)
at
org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:813)
at sqlline.SqlLine.begin(SqlLine.java:686)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291)
at
org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93)
Thanks,
Asmath
