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 <vbrakaus...@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. >
