You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Kunal Kapoor (JIRA)" <ji...@apache.org> on 2018/04/15 04:58:00 UTC
[jira] [Created] (CARBONDATA-2348) Data load failure for aggregate
table when avg and count functions are used together
Kunal Kapoor created CARBONDATA-2348:
----------------------------------------
Summary: Data load failure for aggregate table when avg and count functions are used together
Key: CARBONDATA-2348
URL: https://issues.apache.org/jira/browse/CARBONDATA-2348
Project: CarbonData
Issue Type: Bug
Reporter: Kunal Kapoor
Assignee: kumar vishal
CREATE TABLE IF NOT EXISTS updatetime_4 (countryid smallint ,hs_len smallint ,minstartdate string ,startdate string , newdate string , minnewdate string ) partitioned by (imex smallint) STORED by 'carbondata' TBLPROPERTIES('SORT_SCOPE'='GLOBAL_SORT','sort_columns'='countryid,imex,hs_len,minstartdate,startdate,newdate,minnewdate','table_blocksize'='256');
insert into updatetime_4 values (1,1,'k','k','k','k',1);
create datamap updatetime_agg5 ON TABLE updatetime_4 USING "preaggregate" as select sum(hs_len),avg(hs_len),count(hs_len),min(hs_len) from updatetime_4 group by imex;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)