Prasanna created CARBONDATA-2522:
------------------------------------
Summary: 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
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)
