[jira] [Created] (HIVE-25118) CTAS accepts column's with dot(.) if CBO fails

[Naresh P R (Jira)]

Naresh P R created HIVE-25118:
---------------------------------

             Summary: CTAS accepts column's with dot(.) if CBO fails
                 Key: HIVE-25118
                 URL: https://issues.apache.org/jira/browse/HIVE-25118
             Project: Hive
          Issue Type: Bug
            Reporter: Naresh P R


create table t1(id int);

create table t2(id int);

create table t3 as select t1.id, t2.id from t1 join t2;

CBO fails if "hive.stats.column.autogather=true" with "SemanticException 
Ambiguous column reference: id" & CTAS passes with following table schema
{code:java}
desc t3;
+-----------+------------+----------+
| col_name  | data_type  | comment  |
+-----------+------------+----------+
| t1.id     | int        |          |
| t2.id     | int        |          |
+-----------+------------+----------+{code}
create table t3(`t1.id` int, `t2.id` int); will fail for dot(.) in column name.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)