[ https://issues.apache.org/jira/browse/CARBONDATA-4330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Indhumathi resolved CARBONDATA-4330. ------------------------------------ Fix Version/s: 2.3.1 Resolution: Fixed > Incremental Dataload of Average aggregate in MV > ------------------------------------------------------- > > Key: CARBONDATA-4330 > URL: https://issues.apache.org/jira/browse/CARBONDATA-4330 > Project: CarbonData > Issue Type: Improvement > Reporter: SHREELEKHYA GAMPA > Priority: Major > Fix For: 2.3.1 > > Time Spent: 6h 40m > Remaining Estimate: 0h > > Currently, whenever MV is created with average aggregate, a full refresh is > done meaning it reloads the whole MV for any newly added segments. This will > slow down the loading. With incremental data load, only the segments that are > newly added can be loaded to the MV. > If avg is present, rewrite the query with the sum and count of the columns to > create MV and use them to derive avg. > Refer: > https://docs.google.com/document/d/1kPEMCX50FLZcmyzm6kcIQtUH9KXWDIqh-Hco7NkTp80/edit -- This message was sent by Atlassian Jira (v8.20.7#820007)