Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-3758

The total number of load data is not correct when use preaggregate datamap

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 1.5.4
    • None
    • data-query
    • None
    • centos 7 spark2.3.3 jdk8 carbondata-1.5.5

    Description

      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 

      Attachments

        Activity

          People

            Unassigned Unassigned
            hgs19921112 hgs
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: