Hive进阶篇（五）表生成函数

Hive进阶篇（五）表生成函数

 

生成表函数-explode()

1.首先删除原有的表

drop table if exists management;

2.创建新表

create table management (manager_name string, direct_reports array<string>);

3.插入数据

insert into table management select 'Harry', array('James', 'Lorren');

4.生成表和查询

SELECT manager_name, employee
FROM management
LATERAL VIEW explode(direct_reports) lateral_table AS employee;