Hi,
I am running into below exception when I run a select query on a table with
10 million rows (using sqlline.py)
I added the parameter phoenix.query.timeoutMs to the hbase-site.xml present
in the bin directory where sqlline.py is located, but for some reason its
doesn't seem to be taking effect.
* <property> <name>phoenix.query.timeoutMs</name>
<value>6000000</value> </property>*
java.lang.RuntimeException:
org.apache.phoenix.exception.PhoenixIOException: 71793ms passed since the
last invocation, timeout is currently set to 60000
at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
at sqlline.SqlLine.print(SqlLine.java:1653)
at sqlline.Commands.execute(Commands.java:833)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.runCommands(SqlLine.java:1711)
at sqlline.Commands.run(Commands.java:1285)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:804)
at sqlline.SqlLine.initArgs(SqlLine.java:613)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Aborting command set because "force" is false and command failed: "select
articleid from poc1;"
--
Twitter:http://twitter.com/Baahu
