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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
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)