phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jesse <chat2je...@gmail.com>
Subject Re: A strange question about Phoenix
Date Thu, 20 Jun 2019 22:08:12 GMT
I manually did update system.stat. No help.

We are running amazon EMR.



On Thu, Jun 20, 2019, 2:29 PM Josh Elser <elserj@apache.org> wrote:

> Make sure you have updated statistics for your table. Depending on the
> last time you created the stats, you may have to manually delete the
> stats from SYSTEM.STATS (as there are safeguards to prevent re-creating
> statistics too frequently).
>
> There have been some bugs in the past that results from invalid stats
> guideposts.
>
> On 6/19/19 3:25 PM, jesse wrote:
> > 1) hbase clone-snapshot into my_table
> > 2) sqlline.py zk:port console  to create my_table.
> >
> > Very straight forward.
> >
> >
> >
> > On Wed, Jun 19, 2019, 11:40 AM anil gupta <anilgupta84@gmail.com
> > <mailto:anilgupta84@gmail.com>> wrote:
> >
> >     Sounds strange.
> >     What steps you followed to restore snapshot of Phoenix table?
> >
> >     On Tue, Jun 18, 2019 at 9:34 PM jesse <chat2jesse@gmail.com
> >     <mailto:chat2jesse@gmail.com>> wrote:
> >
> >         hi:
> >
> >           When my table is restored via hbase clone-snapshot,
> >
> >         1) sqlline.py console shows the proper number of records:
> >         select count(*) from my_table.
> >         2) select my_column from my_table limit 1 works fine.
> >
> >           However, select * from my_table limit 1; returns no row.
> >
> >           Do I need to perform some extra operations?
> >
> >           thanks
> >
> >
> >
> >
> >
> >
> >
> >
> >     --
> >     Thanks & Regards,
> >     Anil Gupta
> >
>

Mime
View raw message