Sorry to be dense, is the Phoenix client application the Phoenix Query Server, or my own application.
I'm using the Phoenix thin client jar, so do I need a copy of the server hbase-site.xml in my own app classpath? Cheers S ________________________________ From: Istvan Toth <st...@cloudera.com> Sent: 12 May 2021 11:45 PM To: user@phoenix.apache.org <user@phoenix.apache.org> Cc: Simon Mottram <simon.mott...@cucumber.co.nz> Subject: Re: Setting hbase.rpc.timeout for Phoenix queries on AWS EMR The client XML file is the hbase-site.xml that is on the classpath of the Phoenix client application. You have to add it to the client classpath, and keep the hbase-site.xml on the server/AWS side and the hbase-site.xml in sync. I have no experience with Phoenix on AWS, but the above is generally true for Phoenix. On Wed, May 12, 2021 at 4:18 AM RAISINGHANI Manish <manish.raisingh...@thalesgroup.com<mailto:manish.raisingh...@thalesgroup.com>> wrote: Hi Simon, You need to update the following three parameters: * hbase.rpc.timeout=300000 * hbase.client.scanner.timeout.period=300000 * phoenix.query.timeoutMs=300000 - Manish From: Simon Mottram <simon.mott...@cucumber.co.nz<mailto:simon.mott...@cucumber.co.nz>> Sent: Wednesday, May 12, 2021 4:23 AM To: user <user@phoenix.apache.org<mailto:user@phoenix.apache.org>> Subject: Setting hbase.rpc.timeout for Phoenix queries on AWS EMR Has anyone had experience of this? We have the issue that queries that run longer than a minute are cut off. I presume this is the hbase.rpc.timeout setting. Our admin used the following to configure EMR, but it seems to have had no effect. The posts I can find mention setting this timeout value in the client xml file. I'm not sure that's what this configuration is doing or if it's setting the base Hbase value which is not used by Phoenix? Any assistance/tip gratefully received Cheers Simon [ { "InstanceGroupId":"ig-3FOHTY8X6RDNC", "Configurations":[ { "Classification":"hbase-site", "Properties":{ "hbase.rpc.timeout":"300000" }, "Configurations":[] } ] } ] -- István Tóth | Staff Software Engineer st...@cloudera.com<https://www.cloudera.com> [Cloudera]<https://www.cloudera.com/> [Cloudera on Twitter]<https://twitter.com/cloudera> [Cloudera on Facebook] <https://www.facebook.com/cloudera> [Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> [https://www.cloudera.com/content/dam/www/marketing/brand/email-signature/ent-cloud-co-emailsig-gray.png]<https://www.cloudera.com/> ________________________________
