Re: A strange question about Phoenix

2019-06-20 Thread jesse
I manually did update system.stat. No help. We are running amazon EMR. On Thu, Jun 20, 2019, 2:29 PM Josh Elser 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

Re: A strange question about Phoenix

2019-06-20 Thread Josh Elser
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

Re: A strange question about Phoenix

2019-06-19 Thread jesse
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 wrote: > Sounds strange. > What steps you followed to restore snapshot of Phoenix table? > > On Tue, Jun 18, 2019 at 9:34 PM jesse wrote:

Re: A strange question about Phoenix

2019-06-19 Thread anil gupta
Sounds strange. What steps you followed to restore snapshot of Phoenix table? On Tue, Jun 18, 2019 at 9:34 PM jesse 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

A strange question about Phoenix

2019-06-18 Thread jesse
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