[jira] [Updated] (CARBONDATA-3256) MV datamap doesn't affect using avg expression and count expression

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chenjian Qiu updated CARBONDATA-3256:
-------------------------------------
    Description:
test case:
create table test_table(name string, age int, height int,weight int) stored by 'carbondata'
create datamap test_table_mv using 'mv' as select sum(height),count(age),avg(age),name from test_table group by name
explain select avg(age),name from test_table group by name

[== Physical Plan ==
*HashAggregate(keys=[name#33], functions=[count(age#34), avg(cast(age#34 as bigint))])
+- Exchange hashpartitioning(name#33, 200)
   +- *HashAggregate(keys=[name#33], functions=[partial_count(age#34), partial_avg(cast(age#34 as bigint))])
      +- *FileScan carbondata default.test_table[name#33,age#34]]

  was:
test case:
create table test_table(name string, age int, height int,weight int) stored by 'carbondata'
create datamap test_table_mv using 'mv' as select sum(height),count(age),avg(age),name from test_table group by name
explain select avg(age),name from test_table group by name

> MV datamap doesn't affect using avg expression and count expression
> -------------------------------------------------------------------
>
>                 Key: CARBONDATA-3256
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3256
>             Project: CarbonData
>          Issue Type: Bug
>          Components: sql
>            Reporter: Chenjian Qiu
>            Priority: Blocker
>
> test case:
> create table test_table(name string, age int, height int,weight int) stored by 'carbondata'
> create datamap test_table_mv using 'mv' as select sum(height),count(age),avg(age),name from test_table group by name
> explain select avg(age),name from test_table group by name
> [== Physical Plan ==
> *HashAggregate(keys=[name#33], functions=[count(age#34), avg(cast(age#34 as bigint))])
> +- Exchange hashpartitioning(name#33, 200)
>    +- *HashAggregate(keys=[name#33], functions=[partial_count(age#34), partial_avg(cast(age#34 as bigint))])
>       +- *FileScan carbondata default.test_table[name#33,age#34]]

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)