You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "hgs (Jira)" <ji...@apache.org> on 2020/03/29 08:52:00 UTC

[jira] [Created] (CARBONDATA-3758) The total number of load data is not correct when use preaggregate datamap

hgs created CARBONDATA-3758:
-------------------------------

             Summary: The total number of load data is not correct when use preaggregate datamap
                 Key: CARBONDATA-3758
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3758
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 1.5.4
         Environment: centos 7  spark2.3.3 jdk8 carbondata-1.5.5
            Reporter: hgs


For exmaple:

   a query like 'select sex, count(sex) from carbon_test grou by sex;', the query return two rows like this :

----------------------------

sex       |   count(sex)    |

------------------------------

male    |  374521458    |

-----------------------------

female |  225478542    |

-----------------------------------

male   + female= 600000000 

total is 600000000 

another query is select count(\*) from carbon_test  ,the result is 

------------------------------

count(\*)         |

----------------------------

500000000     |

--------------------------------

 

male   + female > count(\*)

so it is wrong 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)