Re: Issue in upgrading phoenix : java.lang.ArrayIndexOutOfBoundsException: SYSTEM:CATALOG 63

Did you check system.stats,. If it us empty, needs to be rebuilt by running major compact on hbasr On Tue, Sep 11, 2018, 11:33 AM Tanvi Bhandari wrote: > Hi, > > > > I am trying to upgrade the phoenix binaries in my setup from phoenix-4.6 > (had optional concept of schema) to phoenix-4.14

Phoenix 4.10 onwards phoenix view reurning empty result

Hi, From 4.10 onwards select query on phoenix view returning empty results though underlying hbase table has the data. Same select query with with lower phoenix veriosns (4.9 and below) is able to return the results. Please let me know any configuration is needed to get the data from view

Phoenix view returning empty results

Hi, Phoenix 4.10 client returning empty results on view. Where as lower version client able to return proper results. Appreciate response Thanks Venkat

Re: Phoenix shows incorrect count as compared to Hbase count

Delete system.stat entries. It should fix the issue. On Mar 1, 2018 3:04 AM, "Azharuddin Shaikh" wrote: > We are using phoenix(4.8-Version) to perform read operation on our > Hbase(1.2.3 - Version) table but suddenly after 7 months from deployment we > are stuck

Re: How to recover SYSTEM.STATS?

Running major compact will build stats to some extent, and as you keep using tables this will get populated On Jul 22, 2017 7:40 PM, "Batyrshin Alexander" <0x62...@gmail.com> wrote: > Hello, > We accidentally lost SYSTEM.STATS. How to recover/recreate it? >

Phoenix 4.8.1 client returns multiple records for single record in table

Hi, Phoenix 4.8.1 client SELECT is returning multiple records when non primary key is used in where clause. where are returning only one record when primary key is used in where clause. Please find the details *Table Description* 0: jdbc:phoenix:localhost> !describe

Re: phoenix upgrade issue

ements. > See https://phoenix.apache.org/faq.html#Can_phoenix_work_ > on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API for more info > on the CURRENT_SCN property. > > Thanks, > James > > On Tue, Dec 6, 2016 at 9:50 AM, venk sham <shamv...@gmail.com> wrote: > >> while upgrading phoenix from 4.6.1 to 4.8.1.