carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "anubhav tarar (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (CARBONDATA-2152) Min function working incorrectly for string type with dictionary include in presto.
Date Fri, 09 Feb 2018 09:32:00 GMT

     [ 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)

Mime
View raw message