> MV has issues when create on constant column, dupicate columns and limit queries
> --------------------------------------------------------------------------------
>
> Key: CARBONDATA-3433
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-3433> Project: CarbonData
> Issue Type: Bug
> Reporter: Akash R Nilugal
> Priority: Major
> Fix For: 1.6.0
>
> Time Spent: 2.5h
> Remaining Estimate: 0h
>
> MV has issues when create on constant column, dupicate columns and limit queries
> test case to reproduce
> test("test mv with duplicate columns in query and constant column") {
> sql("drop table if exists maintable")
> sql("create table maintable(name string, age int, add string) stored by 'carbondata'")
> sql("create datamap dupli_mv using 'mv' as select name, sum(age),sum(age) from maintable group by name")
> sql("create datamap constant_mv using 'mv' as select name, sum(1) ex1 from maintable group by name")
> sql("insert into maintable select 'pheobe',31,'NY'")
> val df1 = sql("select sum(age),name from maintable group by name")
> val df2 = sql("select sum(age),sum(age),name from maintable group by name")
> val df3 = sql("select name, sum(1) ex1 from maintable group by name")
> val df4 = sql("select sum(1) ex1 from maintable group by name")
> val analyzed1 = df1.queryExecution.analyzed
> val analyzed2 = df2.queryExecution.analyzed
> val analyzed3 = df3.queryExecution.analyzed
> val analyzed4 = df4.queryExecution.analyzed
> assert(TestUtil.verifyMVDataMap(analyzed1, "dupli_mv"))
> assert(TestUtil.verifyMVDataMap(analyzed2, "dupli_mv"))
> assert(TestUtil.verifyMVDataMap(analyzed3, "constant_mv"))
> assert(TestUtil.verifyMVDataMap(analyzed4, "constant_mv"))
> }
Locked
