[ https://issues.apache.org/jira/browse/CARBONDATA-2522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Prasanna updated CARBONDATA-2522: --------------------------------- Attachment: MV_joins.docx > MV dataset when created with Joins, then it is not pointing towards the MV, > while executing that join query. > ------------------------------------------------------------------------------------------------------------ > > Key: CARBONDATA-2522 > URL: https://issues.apache.org/jira/browse/CARBONDATA-2522 > Project: CarbonData > Issue Type: Bug > Environment: 3 Node Opensource ANT Cluster. > Reporter: Prasanna > Priority: Minor > Labels: MV, Materialistic_Views > Attachments: MV_joins.docx > > > When MV is created on Joining tables, then the explain of that join query > points to the maintable, instead of the created MV datamap. > Queries: > drop table if exists fact_table1; > CREATE TABLE fact_table1 (empno int, empname String, designation String, doj > Timestamp, > workgroupcategory int, workgroupcategoryname String, deptno int, deptname > String, > projectcode int, projectjoindate Timestamp, projectenddate > Timestamp,attendance int, > utilization int,salary int) > STORED BY 'org.apache.carbondata.format'; > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table1 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table1 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > drop table if exists fact_table2; > CREATE TABLE fact_table2 (empno int, empname String, designation String, doj > Timestamp, > workgroupcategory int, workgroupcategoryname String, deptno int, deptname > String, > projectcode int, projectjoindate Timestamp, projectenddate > Timestamp,attendance int, > utilization int,salary int) > STORED BY 'org.apache.carbondata.format'; > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table2 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table2 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > drop table if exists fact_table3; > CREATE TABLE fact_table3 (empno int, empname String, designation String, doj > Timestamp, > workgroupcategory int, workgroupcategoryname String, deptno int, deptname > String, > projectcode int, projectjoindate Timestamp, projectenddate > Timestamp,attendance int, > utilization int,salary int) > STORED BY 'org.apache.carbondata.format'; > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table2 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > LOAD DATA local inpath 'hdfs://hacluster/user/prasanna/data_mv.csv' INTO > TABLE fact_table2 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= > '"','timestampformat'='dd-MM-yyyy'); > create datamap datamap25 using 'mv' as select t1.empname as c1, > t2.designation from fact_table1 t1,fact_table2 t2,fact_table3 t3 where > t1.empname = t2.empname and t1.empname=t3.empname; > explain create datamap datamap25 using 'mv' as select t1.empname as c1, > t2.designation from fact_table1 t1,fact_table2 t2,fact_table3 t3 where > t1.empname = t2.empname and t1.empname=t3.empname; > -- This message was sent by Atlassian JIRA (v7.6.3#76005)