[CARBONDATA-2348] Data load failure for aggregate table when avg and count functions are used together

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Kumar Vishal
• Reporter: Kunal Kapoor
• Created: 15/Apr/18 04:57
• Updated: 15/Apr/18 04:57

Description

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;