【SQL】拼表法插入数据

实习过程中学到的一个SQL小技能，把它记录下来。

很多时候我们想要在公司的hive表里插入数据，但是没有办法直接导入文件怎么办？拼表法就能解决这个问题。

例如，我想要手动插入数据得到下图这样一张表：

可以用下面一段代码实现：

select *
from
(select 1 as aa,2 as ab,3 as ac,4 as ad,'拼表' as ae union all
select 1 as aa,2 as ab,3 as ac,4 as ad,'方法' as ae union all
select 1 as aa,2 as ab,3 as ac,4 as ad,'真的' as ae union all
select 1 as aa,2 as ab,3 as ac,4 as ad,'非常' as ae union all
select 1 as aa,2 as ab,3 as ac,4 as ad,'非常' as ae union all
select 1 as aa,2 as ab,3 as ac,4 as ad,'好用' as ae ) t

当数据量很大的时候可以借助excel拼字符来完成代码：