phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "金砖"<>
Subject Re: huge query result miss some fields
Date Thu, 24 Nov 2016 12:30:31 GMT
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.


发件人:Abel Ferná
发送时间:2016年11月24日(周四) 20:14
主题:Re: huge query result miss some fields

Hi Jinzhuan,

Have you tried to update the statistics of your table?

On Thu, 24 Nov 2016 at 11:46 金砖 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.

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


Un saludo - Best Regards.
View raw message