[
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)
