[ https://issues.apache.org/jira/browse/CARBONDATA-995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16068075#comment-16068075 ]
chenerlu commented on CARBONDATA-995: ------------------------------------- Hi, What is behave of same operation in hive ? > Incorrect result displays while using variance aggregate function in presto > integration > --------------------------------------------------------------------------------------- > > Key: CARBONDATA-995 > URL: https://issues.apache.org/jira/browse/CARBONDATA-995 > Project: CarbonData > Issue Type: Bug > Components: data-query, presto-integration > Affects Versions: 1.1.0 > Environment: spark 2.1 , presto 0.166 > Reporter: Vandana Yadav > Priority: Minor > Attachments: 2000_UniqData.csv > > > Incorrect result displays while using variance aggregate function in presto > integration > Steps to reproduce : > 1. In CarbonData: > a) Create table: > CREATE TABLE uniqdata (CUST_ID int,CUST_NAME String,ACTIVE_EMUI_VERSION > string, DOB timestamp, DOJ timestamp, BIGINT_COLUMN1 bigint,BIGINT_COLUMN2 > bigint,DECIMAL_COLUMN1 decimal(30,10), DECIMAL_COLUMN2 > decimal(36,10),Double_COLUMN1 double, Double_COLUMN2 double,INTEGER_COLUMN1 > int) STORED BY 'org.apache.carbondata.format' TBLPROPERTIES > ("TABLE_BLOCKSIZE"= "256 MB"); > b) Load data : > LOAD DATA INPATH 'hdfs://localhost:54310/2000_UniqData.csv' into table > uniqdata OPTIONS('DELIMITER'=',' , > 'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='CUST_ID,CUST_NAME,ACTIVE_EMUI_VERSION,DOB,DOJ,BIGINT_COLUMN1,BIGINT_COLUMN2,DECIMAL_COLUMN1,DECIMAL_COLUMN2,Double_COLUMN1,Double_COLUMN2,INTEGER_COLUMN1'); > 2. In presto > a) Execute the query: > select variance(DECIMAL_COLUMN1) as a from (select DECIMAL_COLUMN1 from > UNIQDATA order by DECIMAL_COLUMN1) t > Actual result : > In CarbonData : > "+--------------------+--+ > | a | > +--------------------+--+ > | 333832.4983039884 | > +--------------------+--+ > 1 row selected (0.695 seconds) > " > in presto: > " a > ------------------- > 333832.3010442859 > (1 row) > Query 20170420_082837_00062_hd7jy, FINISHED, 1 node > Splits: 35 total, 35 done (100.00%) > 0:00 [2.01K rows, 1.97KB] [8.09K rows/s, 7.91KB/s]" > Expected result: it should display the same result as showing in CarbonData. -- This message was sent by Atlassian JIRA (v6.4.14#64029)