I figured this out, there was an old HBASE_CONF_PATH that pointed to a non-existent path, so the hbase-site.xml file was not being used. Setting this value corrected the problem. Simply point to the folder where the hbase-site.xml file is located: export HBASE_CONF_PATH=/phoenix/bin/
Kevin From: Kevin Verhoeven Sent: Thursday, February 5, 2015 8:51 AM To: user Subject: RE: sqllite: Upsert query times out after 10 minutes 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, Kevin From: [email protected]<mailto:[email protected]> [mailto:[email protected]] Sent: Wednesday, February 4, 2015 5:27 PM To: user Subject: Re: sqllite: Upsert query times out after 10 minutes Hi, Kevin, 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? Thanks, Sun. ________________________________ ________________________________ CertusNet From: Kevin Verhoeven<mailto:[email protected]> Date: 2015-02-05 09:10 To: [email protected]<mailto:[email protected]> Subject: sqllite: Upsert query times out after 10 minutes 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: <property> <name>phoenix.query.timeoutMs</name> <value>900000</value> </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? Thank you, Kevin Verhoeven
