I manually did update system.stat. No help. We are running amazon EMR.
On Thu, Jun 20, 2019, 2:29 PM Josh Elser <els...@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 <anilgupt...@gmail.com > > <mailto:anilgupt...@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 <chat2je...@gmail.com > > <mailto:chat2je...@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 > > >