Re: phoenix upsert select query fails with : java.util.concurrent.ExecutionException: java.lang.ArrayIndexOutOfBoundsException

2016-12-12 Thread venkata subbarayudu
) at java.lang.Thread.run(Thread.java:745) On Mon, Dec 12, 2016 at 1:43 AM, Josh Elser <josh.el...@gmail.com> wrote: > What's the rest of the stacktrace? You cut off the cause. > > venkata subbarayudu wrote: > >> >> I faced a strange issue, that, Phoenix hbase upsert query fails

phoenix upsert select query fails with : java.util.concurrent.ExecutionException: java.lang.ArrayIndexOutOfBoundsException

2016-12-11 Thread venkata subbarayudu
by: java.lang.ArrayIndexOutOfBoundsException But re-trying the same query, it got succeded. I'm trying to understand the root cause of the problem and how to resolve the same any help is much appreciated. -- *Venkata Subbarayudu Amanchi.*

Re: using index with "or" query

2017-09-25 Thread venkata subbarayudu
r, or if any >>> problems occur with transmission, please contact sender. Thank you. >>> >> >> -- >> >> PRIVILEGED AND CONFIDENTIAL >> PLEASE NOTE: The information contained in this message is privileged and >> confidential, and is intended only for the use of the individual to whom it >> is addressed and others who have been specifically authorized to receive >> it. If you are not the intended recipient, you are hereby notified that any >> dissemination, distribution or copying of this communication is strictly >> prohibited. If you have received this communication in error, or if any >> problems occur with transmission, please contact sender. Thank you. >> > -- *Venkata Subbarayudu Amanchi.*

Re: Why the bulkload does not support update index data?

2018-01-19 Thread venkata subbarayudu
is phoenix bulk loader not updating the index all the times, or , are during any specific scenarios On Thu, Jan 18, 2018 at 7:51 AM, cloud.pos...@gmail.com < cloud.pos...@gmail.com> wrote: > The index data will be dirty if bulkload can not update index data. > -- *Venkata Subbarayudu Amanchi.*

Phoenix Metrics - How to understand

2018-10-21 Thread venkata subbarayudu
PHOENIX_CONNECTIONS_COUNTER = 11" , "OPEN_PHOENIX_CONNECTIONS_COUNTER = 21 " etc.,though there were no other noticeable logs indicating some error, what does this mean, is it like multiple attempts tried internally, and all the open connections by this are not cleared ? -- *Venkata Subbarayudu Amanchi.*

Phoenix Delete Query - Hbase rpc timeout relation

2018-10-21 Thread venkata subbarayudu
for a large table delete and if the delete is expected to take increasing time as the table grows (trying with secondary indexing is one option to keep the timeouts lower, but assuming the delete-time grows even with secondary indexes) Thank you for your support -- *Venkata Subbarayudu Amanchi.*

Phoenix Metrics - How to understand

2018-09-24 Thread venkata subbarayudu
PEN_PHOENIX_CONNECTIONS_COUNTER = 11" , "OPEN_PHOENIX_CONNECTIONS_COUNTER = 21 " etc. ,though there were no other noticeable logs indicating some error, what does this mean? -- *Venkata Subbarayudu Amanchi.*

Re: split count for mapreduce jobs with PhoenixInputFormat

2019-01-30 Thread venkata subbarayudu
You may recreate the table with salt_bucket table option to have reasonable regions and you may try having a secondary index to make the query run faster incase if your Mapreduce job performing specific filters On Thu 31 Jan, 2019, 12:09 AM Thomas D'Silva If stats are enabled PhoenixInputFormat

Re: Buckets VS regions

2019-08-19 Thread venkata subbarayudu
Did you try with updating table statistics, it may be because some times table guideposts are out of sync Below is the SQL to update table stats Update statistics table By default above executes asynchronously, hence it may take some time to update depending on table size On Tue 20 Aug,

Re: Buckets VS regions

2019-08-20 Thread venkata subbarayudu
: > Yes, that seems to be a trick, the issue is only associated a region. > > What could be the causes of guidposts not updated? > > > On Mon, Aug 19, 2019, 6:40 PM venkata subbarayudu > wrote: > >> Did you try with updating table statistics, it may be because