> IS NULL not working correctly on string datatype with dictionary_include in presto integration
> ----------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-2155
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-2155> Project: CarbonData
> Issue Type: Bug
> Components: presto-integration
> Affects Versions: 1.3.0
> Environment: Spark-2.1
> Presto 0.187
> Reporter: Sangeeta Gulia
> Assignee: anubhav tarar
> Priority: Minor
> Fix For: 1.4.0
>
> Attachments: lineitem.csv
>
> Time Spent: 4h 20m
> Remaining Estimate: 0h
>
> Steps to reproduce:
> 1) Create table on carbondata and load data to it.
> create table if not exists lineitem_carbon1(
> L_SHIPDATE date,
> L_SHIPMODE string,
> L_SHIPINSTRUCT string,
> L_RETURNFLAG string,
> L_RECEIPTDATE date,
> L_ORDERKEY string,
> L_PARTKEY string,
> L_SUPPKEY string,
> L_LINENUMBER int,
> L_QUANTITY double,
> L_EXTENDEDPRICE double,
> L_DISCOUNT double,
> L_TAX double,
> L_LINESTATUS string,
> L_COMMITDATE date,
> L_COMMENT string
> ) STORED BY 'carbondata'
> TBLPROPERTIES ('DICTIONARY_INCLUDE'='L_SHIPMODE,L_SHIPINSTRUCT,L_RETURNFLAG,L_LINESTATUS', 'table_blocksize'='300', 'no_inverted_index'='L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_COMMENT');
> load data inpath "hdfs://localhost:54310/user/hduser/input-files/lineitem.csv" into table lineitem_carbon1 options('DATEFORMAT' = 'yyyy-MM-dd','DELIMITER'='|','FILEHEADER'='L_ORDERKEY,L_PARTKEY,L_SUPPKEY,L_LINENUMBER,L_QUANTITY,L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT','BAD_RECORDS_LOGGER_ENABLE'='true', 'BAD_RECORDS_ACTION'='FORCE');
> 1: jdbc:hive2://localhost:10000> select l_shipmode from lineitem_carbon1 where l_shipmode is NULL;
> +-------------+--+
> | l_shipmode |
> +-------------+--+
> | NULL |
> +-------------+–+
> 2) Access the same table from presto-cli and try to run select query form there:
> presto:performance> select l_shipmode from lineitem_carbon1 where l_shipmode is NULL;
> l_shipmode
> ------------
> (0 rows)
> Expected Result: It should be same as result from carbon.
Locked
