carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kumar vishal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-2029) Query with expression is giving wrong result
Date Mon, 15 Jan 2018 12:51:03 GMT
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)

Mime
View raw message