kumar vishal created CARBONDATA-2029:
----------------------------------------

             Summary: Query with expression is giving wrong result 
                 Key: CARBONDATA-2029
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2029
             Project: CarbonData
          Issue Type: Bug
            Reporter: kumar vishal
            Assignee: kumar vishal


Create Maintable:

CREATE TABLE mainTable(id int, name string, city string, age string) STORED BY 
'org.apache.carbondata.format

 

Create datamap
create datamap agg1 on table mainTable using 'preaggregate' as select 
name,sum(id) from mainTable group by name

Load data 

Run query :select sum(id)+count(id) from maintable is giving wrong result

Problem: When query has expression it is not checking which aggregate function 
is applied on table and based on table it is selecting aggregate table

Solution: While extracting the aggregate expression from query plan in case if 
any expression is present extract which aggregate function applied on column to 
select the aggregate table 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to