After we changed the default to 900000, the error remained the same: Query couldn't be completed in the alloted time: 600000 ms
Is there a way to force sqllite to use the hbase-site.xml? We have it located in the bin folder where sqllite is started from, but is that all we need to do? Online I’ve see suggestions to set the PHOENIX_LIB_DIR, but that has not helped: export PHOENIX_LIB_DIR=/phoenix/bin/
Thanks for your help,
I think that should be work cause this parameter is a client-side config. After you change the default
to 900000, did you see that the exception info changed accordingly?
I am running an upsert query against Phoenix 4.2.2 on Hbase 0.98.6-cdh5.2.0 and the query times out after 10 minutes, with the following error: Error: ERROR 6000 (TIM01): Operation timed out . Query couldn't be completed in the alloted time: 600000 ms (state=TIM01,code=6000)
I’ve update the bin/hbase-site.xml file with the following property:
However, even with the phoenix.query.timeoutMs set at 900000, the query still fails. How can I make sure that sqllite is using this hbase-site.xml?
The upsert query is running against 24 million rows. There are six HBase RegionServers in the HBase cluster. How can the timeout be increased?