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.
