[jira] [Created] (CARBONDATA-2152) Min function working incorrectly for string type with dictionary include in presto.

["Sangeeta Gulia (JIRA)" <ji...@apache.org>]

Sangeeta Gulia created CARBONDATA-2152:
------------------------------------------

             Summary: Min function working incorrectly for string type with dictionary include in presto.
                 Key: CARBONDATA-2152
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2152
             Project: CarbonData
          Issue Type: Bug
          Components: presto-integration
    Affects Versions: 1.3.0
         Environment: Spark2.1
Presto0.187
            Reporter: Sangeeta Gulia


Steps to reproduce:

1) Create and Load in carbondata.

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');
 
 0: jdbc:hive2://localhost:10000> select min(l_shipmode) from lineitem_carbon1;
+------------------+--+
| min(l_shipmode)  |
+------------------+--+
| AIR              |
+------------------+--+
2) Connect to carbondata store from presto and perform the below query from presto-cli:

presto:performance> select min(l_shipmode) from lineitem_carbon1;

_col0 
----------
@NU#LL$! 
(1 row)

 

Expected: On presto also, it should give the correct output as shown on carbondata.

 



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