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
> >
>
|