[jira] [Created] (CARBONDATA-2029) Query with expression is giving wrong result

[Akash R Nilugal (Jira)]

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)