Do you have bigger rows? if yes , it may be similar to https://issues.apache.org/jira/browse/PHOENIX-3112 and increasing hbase.client.scanner.max.result.size can help.
On Thu, Nov 24, 2016 at 6:00 PM, 金砖 <[email protected]> wrote: > thanks Abel. > > > I tried update statistics, it did not work. > > > But after some retries, I found something interesting: > > I add 'limit 100000000' after my sql. > > Even actual size of result is the same(since there’s only 100000 rows in > table), but the missing problem is solved. > > ---------------------------------------------------------------- > *金砖* > 挖财网络技术有限公司 > 地址：杭州市西湖区古翠路80号浙江科技产业大厦12楼 > 手机：15558015995 > > 原始邮件 > *发件人:* Abel Fernández<[email protected]> > *收件人:* user<[email protected]> > *发送时间:* 2016年11月24日(周四) 20:14 > *主题:* Re: huge query result miss some fields > > Hi Jinzhuan, > > Have you tried to update the statistics of your table? > > https://phoenix.apache.org/update_statistics.html > > > On Thu, 24 Nov 2016 at 11:46 金砖 <[email protected]> wrote: > >> hi, all: >> >> I’m using phoenix-4.8.0-hbase-1.1 with hbase 1.1.3. >> >> When query a lot of rows(ex: 100,000), some fileds of rows does not >> exists in result set. >> >> >> steps >> >> 1. I created a table test(pk varchar primary key, id bigint, name >> varchar, age bigint). >> >> 2. then populated with 100000 rows, with key prefix 'prefix', and rows >> will be 'prefix1' - 'prefix100000'. >> >> 3. then query with select * from test; >> >> >> occasionally some fields with be lost in rows, >> >> sometimes 2 rows missing id and age, >> >> some times 3 rows missing name. >> >> >> Can anyone be helpful? Is there some settings should be done ? >> >> ---------------------------------------------------------------- >> *jinzhuan* >> > -- > Un saludo - Best Regards. > Abel >
