[jira] [Created] (CARBONDATA-3433) MV has issues when create on constant column, dupicate columns and limit queries

[Akash R Nilugal (Jira)]

Akash R Nilugal created CARBONDATA-3433:
-------------------------------------------

             Summary: 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


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"))
  }



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