[ https://issues.apache.org/jira/browse/PHOENIX-2751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nick Hryhoriev updated PHOENIX-2751: ------------------------------------ Priority: Critical (was: Major) > Wrong filtering for VARCHAR with null > ------------------------------------- > > Key: PHOENIX-2751 > URL: https://issues.apache.org/jira/browse/PHOENIX-2751 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.5.1 > Reporter: Nick Hryhoriev > Priority: Critical > Attachments: test_data.csv > > > I ve got table > CREATE TABLE integration_tests.connector_test( > cf1.date_full timestamp, > cf1.date_empty timestamp, > cf1.date_with_null timestamp, > cf1.date_milliseconds bigint, > cf1.date_milliseconds_empty bigint, > cf1.date_milliseconds_with_null bigint, > cf1.date_seconds bigint, > cf1.date_seconds_empty bigint, > cf1.date_seconds_with_null bigint, > cf1.date_year bigint, > cf2.date_year_with_null bigint, > cf2.double_full DOUBLE, > cf2.double_with_null DOUBLE, > cf2.double_empty DOUBLE, > cf2.integer_full bigint, > cf3.integer_with_null bigint, > cf3.integer_empty bigint, > cf3.string_with_null varchar, > cf3.string_empty varchar, > cf3.string_full varchar, > id bigint, > CONSTRAINT pk PRIMARY KEY (id)) > SALT_BUCKETS=3, > STORE_NULLS=true, > DEFAULT_COLUMN_FAMILY='cf4', > COMPRESSION='GZ' > where in with_null column 30% null values. > When i run > Select ds.double_full, ds.string_with_null from > integration_tests.connector_test ds -> i ve got all my nulls. > When i run > Select ds.double_full, ds.string_with_null from > integration_tests.connector_test ds where ds.string_with_null is NULL-> ive > got empty result. > is not NULL work well. and also i ve find issue in mail list that a really > close to this one > https://mail-archives.apache.org/mod_mbox/phoenix-user/201505.mbox/%3cd18383cd.7f6d%25a...@hortonworks.com%3E. -- This message was sent by Atlassian JIRA (v6.3.4#6332)