You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by GitBox <gi...@apache.org> on 2019/05/03 10:46:02 UTC

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

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-489056275
 
 
   @qiuchenjian Basically when you provide `sum` and `count` we no need provide `avg` during the creation of datamap. So the following test case should work.
   ```
   sql("create datamap test_table_mv using 'mv' as select sum(height),count(age),name from test_table group by name")
   ```
   On the above datamap following query should hitthat datamap.
   ```
   sql("select avg(age),name from test_table group by name")
   ```
   The actual intention of the code was to derive `avg` from `sum` and `count` columns. So we no need to provide `avg` during datamap creation. Please add the above testcase fix it.
   

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services