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)

Reply via email to