hive 子查询特别分析

Hive只支持在FROM子句中使用子查询，子查询必须有名字，并且列必须唯一：SELECT ... FROM(subquery) name ...

确认下是否一定要求列必须唯一？ 

   

建表语句：

create table  tb_in_base

(

   id  bigint,

   devid bigint,

    devname string

) partitioned by (job_time bigint) row format delimited fields terminated by ',';

create table  tb_in_up

(

   id  bigint,

   devid bigint,

   devname string

) partitioned by (job_time bigint) row format delimited fields terminated by ',';

场景一：单表子查询没有指定表别名

语句：select * from (select id,devid,job_time from tb_in_base) ;

执行过程：