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

• Type: Bug
• Status: Open
• Priority: Blocker
• Resolution: Unresolved
• Component/s: sql
• Assignee: Unassigned
• Reporter: Chenjian Qiu
• Created: 17/Jan/19 09:22
• Updated: 15/May/19 01:21

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_tablename#33,age#34]

Issue Links

• links to: GitHub Pull Request #3080