Support Questions
Find answers, ask questions, and share your expertise

phoenix query timeout

Solved Go to solution
Highlighted

phoenix query timeout

I am trying to run a phoenix query which has to fetch about 1.5 millions rows. the query times out.

Is there any config parameter, i need to set up. Any thoughts would be of great help

SELECT COUNT(1) FROM TABLE +------------------------------------------+ | COUNT(1) | +------------------------------------------+ java.lang.RuntimeException: java.sql.SQLTimeoutException: Operation timed out 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.begin(SqlLine.java:681) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:292)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: phoenix query timeout

@ARUNKUMAR RAMASAMY By default the query time out is 600000 (10mins) . You can increase phoenix.query.timeoutMs and re-run the query.

View solution in original post

3 REPLIES 3
Highlighted

Re: phoenix query timeout

@ARUNKUMAR RAMASAMY By default the query time out is 600000 (10mins) . You can increase phoenix.query.timeoutMs and re-run the query.

View solution in original post

Highlighted

Re: phoenix query timeout

Thanks @Sandeep Nemuri It seems by default the query timeout is 1.5 mins and i increased it to 5 mins and it worked fine.

Re: phoenix query timeout

@ARUNKUMAR RAMASAMY Glad it helped in resolving your issue. Please accept the answer to close this thread.