phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Victor Brakauskas <vbrakaus...@23andme.com>
Subject Strange query results
Date Wed, 13 Feb 2019 00:55:37 GMT
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