好吧，这是你在Hive手册上找的东西。。
横向视图与用户定义的表生成函数（如explode（））结合使用。正如在内置表生成函数中所提到的，udtf为每个输入行生成零个或多个输出行。
例如

SELECT cust_id
FROM mytable LATERAL VIEW explode(cust_id) mytab AS cust_id;

完整示例：

drop table customer_tab;
create table customer_tab ( cust_id array<String>);

INSERT INTO table customer_tab select array('123','234','456','567');

INSERT INTO table customer_tab select array('345','457','67');

INSERT INTO table customer_tab select array('89','23','34');

select * from customer_tab;
--      customer_tab.cust_id
--      ["123","234","456","567"]
--      ["345","457","67"]
--      ["89","23","34"]

SELECT mytab.cust_id
FROM customer_tab LATERAL VIEW explode(cust_id) mytab AS cust_id;

mytab.cust_id
123
234
456
567
345
457
67
89
23
34