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

["Naresh P R (Jira)" <ji...@apache.org>]

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

Naresh P R updated HIVE-25118:
------------------------------
    Description: 
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}
disabling column stats will fail the query
{code:java}
set hive.stats.column.autogather=false;
create table t3 as select t1.id, t2.id from t1 join t2;
Error: Error while compiling statement: FAILED: SemanticException [Error 10036]: Duplicate column name: id (state=42000,code=10036)
{code}
PS : create table t3(`t1.id` int, `t2.id` int); will fail for dot(.) in column name.

  was:
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.


> 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
>            Priority: Major
>
> 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}
> disabling column stats will fail the query
> {code:java}
> set hive.stats.column.autogather=false;
> create table t3 as select t1.id, t2.id from t1 join t2;
> Error: Error while compiling statement: FAILED: SemanticException [Error 10036]: Duplicate column name: id (state=42000,code=10036)
> {code}
> PS : 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)