[CARBONDATA-4035] MV table is not hit when sum() is applied on decimal column.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.1.0
• Assignee: Akash R Nilugal
• Reporter: Akash R Nilugal
• Created: 16/Oct/20 10:37
• Updated: 23/Oct/20 09:06
• Resolved: 23/Oct/20 09:06

Description

MV table is not hit when sum() is applied on decimal column.

sql("drop table if exists sum_agg_decimal")
sql("create table sum_agg_decimal(salary1 decimal(7,2),salary2 decimal(7,2),salary3 decimal(7,2),salary4 decimal(7,2),empname string) stored as carbondata")
sql("drop materialized view if exists decimal_mv")
sql("create materialized view decimal_mv as select empname, sum(salary1 - salary2) from sum_agg_decimal group by empname")
sql("explain select empname, sum( salary1 - salary2) from sum_agg_decimal group by empname").show(false)