Bahubali, hbase-site.xml needs to be on the client's CLASSPATH in order to get picked up or else it will use the default timeout. When using sqlline it sets the CLASSPATH to the HBASE_CONF_PATH environment variable which default to the current directory. Try running sqlline directly from the bin directory.
-Thomas On Tue, Jun 16, 2015 at 5:00 AM, Bahubali Jain <[email protected]> wrote: > > 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 >
