You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Naresh P R (Jira)" <ji...@apache.org> on 2021/05/14 19:58:00 UTC
[jira] [Created] (HIVE-25118) CTAS accepts column's with dot(.) if
CBO fails
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)