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

[Akash R Nilugal (Jira)]

Babulal created CARBONDATA-2564:
-----------------------------------

             Summary: [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: Bug
            Reporter: Babulal


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)