[jira] [Commented] (CARBONDATA-2531) [MV] MV not hit when alias is in use

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-2531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16523402#comment-16523402 ]

xubo245 commented on CARBONDATA-2531:
-------------------------------------

where is data?

> [MV] MV not hit when alias is in use
> ------------------------------------
>
>                 Key: CARBONDATA-2531
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2531
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Babulal
>            Assignee: xubo245
>            Priority: Major
>
> #testcase class  
> MVCreateTestCase 
>  
> CREATE TABLE fact5 (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 '/tmp/babu/data_big.csv' INTO TABLE fact5 OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '"','timestampformat'='dd-MM-yyyy');
> create datamap datamap53 using 'mv' as select deptname, sum(salary) from fact4 group by deptname
>  
> 0: jdbc:hive2://10.18.222.231:23040> explain select deptname, sum(salary) from fact4 as tt group by deptname;
> +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
> | plan |
> +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
> | == Physical Plan ==
> *BatchedScan CarbonDatasourceHadoopRelation [ Database name :default, Table name :{color:#14892c}datamap53_table{color}, Schema :Some(StructType(StructField(fact4_deptname,StringType,true), StructField(sum_salary,LongType,true))) ] default.datamap53_table[fact4_deptname#1539,sum_salary#5961L] |
> +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+–+
>  
>  
> Now use alias for column name 
> 0: jdbc:hive2://10.18.222.231:23040> explain select deptname as babu, sum(salary) from fact4 as tt group by deptname;
> | plan |
> +------------------------------------------------------------------------------------------------------------------+--+
> |
> | == Physical Plan ==
> *HashAggregate(keys=[deptname#1539], functions=[sum(cast(salary#1545 as bigint))])
> +- Exchange hashpartitioning(deptname#1539, 200)
>  +- *HashAggregate(keys=[deptname#1539], functions=[partial_sum(cast(salary#1545 as bigint))])
>  +- *BatchedScan CarbonDatasourceHadoopRelation [ Database name :default, Table name {color:#FF0000}:*fact4*,{color} Schema :Some(StructType(StructField(empname,StringType,true), StructField(designation,StringType,true), StructField(doj,TimestampType,true), StructField(workgroupcategory,IntegerType,true), StructField(workgroupcategoryname,StringType,true), StructField(deptno,IntegerType,true), StructField(deptname,StringType,true), StructField(projectcode,IntegerType,true), StructField(projectjoindate,TimestampType,true), StructField(projectenddate,TimestampType,true), StructField(attendance,IntegerType,true), StructField(utilization,IntegerType,true), StructField(salary,IntegerType,true))) ] default.fact4[deptname#1539,salary#1545] |
> +-----------------------------------------------------------------------------------------------------------------
>  
> Alias should be ignored data data should be fetched from MV table datamap53_table.
>  

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