[ https://issues.apache.org/jira/browse/CARBONDATA-2152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
anubhav tarar reassigned CARBONDATA-2152: ----------------------------------------- Assignee: anubhav tarar > 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 > Assignee: anubhav tarar > Priority: Major > > 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)