[GitHub] [carbondata] ravipesala commented on issue #3080: [CARBONDATA-3256] Fix that MV datamap doesn't take effect using avg expression and count expression

[GitBox]

ravipesala commented on issue #3080: [CARBONDATA-3256] Fix that MV datamap doesn't take effect using avg expression and count expression
URL: https://github.com/apache/carbondata/pull/3080#issuecomment-490066812
 
 
   Usually while creating mv for avg aggregate we can split it to sum and count aggregate columns. Currently creating MV does not handle the splitting of avg column to sum and count but we should add that support. So if user creates the mn datamap as below
   ```
   create datamap test_table_mv using 'mv' as select sum(age),count(age),name from test_table group by name
   ```
   or
   ```
   "create datamap test_table_mv using 'mv' as select avg(age),name from test_table group by name
   ```
   
   In both above cases we should support below sql
   ```
   select avg(age),name from test_table group by name
   ```
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[hidden email]


With regards,
Apache Git Services