[jira] [Updated] (PHOENIX-2751) Wrong filtering for VARCHAR with null

["Thomas D'Silva (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-2751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas D'Silva updated PHOENIX-2751:
------------------------------------
    Fix Version/s:     (was: 4.15.0)

> 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%25ashu@hortonworks.com%3E.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)