phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abel Fernández <mevsmys...@gmail.com>
Subject Re: huge query result miss some fields
Date Thu, 24 Nov 2016 12:14:57 GMT
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