Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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
Attachments
Issue Links
- links to