phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@salesforce.com>
Subject Re: Strange query results
Date Wed, 13 Feb 2019 01:10:01 GMT
This looks like a bug, can you please file a JIRA with the repro steps ?

On Tue, Feb 12, 2019 at 4:56 PM Victor Brakauskas <vbrakauskas@23andme.com>
wrote:

> Hello all,
> Running into some strange query results on a cluster I have that's running
> phoenix 4.14.0 and hbase 1.3.1.
> I've got a table that's defined as such.
>
> create table if not exists TEST_TABLE(    col_1 integer not null,    col_2 integer not
null,
>     col_3 bigint,
>     col_4 float,
>     col_5 date,
>     col_6 date,
>     col_7 varchar,
>     col_8 varchar[],
>     col_9 date,
>     col_10 boolean
>     constraint ind_attr_pk primary key (col_1, col_2)
> )column_encoded_bytes = 0,data_block_encoding = 'FAST_DIFF',versions = 1,compression
= 'GZ',salt_buckets = 120,filesize = 10737418240;
>
>
> and insert a row like this
>
> upsert into TEST_TABLE VALUES(55, 4444, 42, 42.42, current_date(),
> current_time(),'hi', ARRAY['hi','hello','sup'], current_date(), true);
>
> Then, when querying the table, there are some weird query results
>  0: jdbc:phoenix:localhost> select count(*) from test_table where col_1 =
> 55 and col_2 = 4444;
>
> *+-----------+*
>
> *| **COUNT(1) ** |*
>
> *+-----------+*
>
> *| *1        * |*
>
> *+-----------+*
>
> 1 row selected (0.012 seconds)
>
> 0: jdbc:phoenix:localhost> select count(*) from test_table where col_1 =
> 55;
>
> *+-----------+*
>
> *| **COUNT(1) ** |*
>
> *+-----------+*
>
> *| *0        * |*
>
> *+-----------+*
>
> 1 row selected (0.025 seconds)
>
> Do you guys have any idea what mind be causing these results?
>
>
> <https://inboxwhenready.org/?utm_campaign=signature&utm_medium=email&utm_source=signature>
> I'm using Inbox When Ready
> <https://inboxwhenready.org/?utm_campaign=signature&utm_medium=email&utm_source=signature>
> to protect my focus.
>

Mime
View raw message