phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: huge query result miss some fields
Date Thu, 24 Nov 2016 12:52:42 GMT
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, 金砖 <jinzhuan@wacai.com> 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<mevsmyself@gmail.com>
> *收件人:* user<user@phoenix.apache.org>
> *发送时间:* 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 金砖 <jinzhuan@wacai.com> 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
>

Mime
View raw message