[ 
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)

Reply via email to