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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-2029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Manish Gupta resolved CARBONDATA-2029.
--------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.3.0

> 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
>            Priority: Major
>             Fix For: 1.3.0
>
>          Time Spent: 50m
>  Remaining Estimate: 0h
>
> 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)