You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2016/01/09 03:54:39 UTC

[jira] [Created] (HIVE-12825) select * may not work with ctas

Sergey Shelukhin created HIVE-12825:
---------------------------------------

             Summary: select * may not work with ctas
                 Key: HIVE-12825
                 URL: https://issues.apache.org/jira/browse/HIVE-12825
             Project: Hive
          Issue Type: Bug
            Reporter: Sergey Shelukhin


> create table foo3 as select * from foo2 f1 cross join foo2 f2;
Warning: Map Join MAPJOIN[7][bigTable=f1] in task 'Map 1' is a cross product
FAILED: SemanticException [Error 10036]: Duplicate column name: f

If the column names are not specified, ctas generates them; for select *, it should also generate them if there are collisions.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)