[jira] [Updated] (CARBONDATA-2564) [MV] Query Failed when MV created when same name column used in both table

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-2564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

xubo245 updated CARBONDATA-2564:
--------------------------------
    Issue Type: Sub-task  (was: Bug)
        Parent: CARBONDATA-2628

> [MV]  Query Failed when MV created when same name column used in both table
> ----------------------------------------------------------------------------
>
>                 Key: CARBONDATA-2564
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2564
>             Project: CarbonData
>          Issue Type: Sub-task
>            Reporter: Babulal
>            Assignee: xubo245
>            Priority: Major
>
> create table mvtest8( name string,age int,salary int) stored by 'carbondata';
> create table mvtest9( name string,age int,salary int) stored by 'carbondata';
> insert into mvtest9 select 'a',12,12;
> insert into mvtest8 select 'a',12,12;
>  
> 0: jdbc:hive2://10.18.222.231:23040> select * from mvtest8 join mvtest9 on mvtest8.name=mvtest9.name;
> +-------+------+---------+-------+------+---------+--+
> | name | age | salary | name | age | salary |
> +-------+------+---------+-------+------+---------+--+
> | a | 12 | 12 | a | 12 | 12 |
> +-------+------+---------+-------+------+---------+--+
>  
> 0: jdbc:hive2://10.18.222.231:23040> create datamap mv8andmv9map using 'mv' as select * from mvtest8 join mvtest9 on mvtest8.name=mvtest9.name;
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.52 seconds)
> 0: jdbc:hive2://10.18.222.231:23040> rebuild datamap mv8andmv9map;
> +---------+--+
> | Result |
> +---------+--+
> +---------+–+
> 0: jdbc:hive2://10.18.222.231:23040> explain select * from mvtest8 join mvtest9 on mvtest8.name=mvtest9.name;
> Error: org.apache.spark.sql.AnalysisException: Reference 'name' is ambiguous, could be: name#1888, name#2412.; line 1 pos 28 (state=,code=0)
> 0: jdbc:hive2://10.18.222.231:23040>
>  
>  
> 0: jdbc:hive2://10.18.222.231:23040> desc formatted mv8andmv9map_table;
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | col_name | data_type | comment |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> | mvtest8_name | string | KEY COLUMN,null |
> | mvtest8_age | int | MEASURE,null |
> | mvtest8_salary | int | MEASURE,null |
> | mvtest9_name | string | KEY COLUMN,null |
> | mvtest9_age | int | MEASURE,null |
> | mvtest9_salary | int | MEASURE,null |
> | | | |
> | ##Detailed Table Information | | |
> | Database Name | default | |
> | Table Name | mv8andmv9map_table | |
> | CARBON Store Path | hdfs://hacluster/user/hive/warehouse/carbon.store/default/mv8andmv9map_table | |
> | Comment | | |
> | Table Block Size | 1024 MB | |
> | Table Data Size | 1484 | |
> | Table Index Size | 940 | |
> | Last Update Time | 1527610493258 | |
> | SORT_SCOPE | LOCAL_SORT | LOCAL_SORT |
> | Streaming | false | |
> | | | |
> | ##Detailed Column property | | |
> | ADAPTIVE | | |
> | SORT_COLUMNS | mvtest8_name,mvtest9_name | |
> +---------------------------------------+-----------------------------------------------------------------------------------+---------------------------------------------------------------------------+--+
> 22 rows selected (0.19 seconds)
>  
>  
> 0: jdbc:hive2://10.18.222.231:23040> select mvtest8.name from mvtest8 join mvtest9 on mvtest8.name=mvtest9.name;
> Error: org.apache.spark.sql.AnalysisException: Reference 'name' is ambiguous, could be: name#1888, name#2412.; line 3 pos 10 (state=,code=0)
>  

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