lateral view的使用(炸开函数):
使用示例:
select
ChargeName,
regexp_replace(regexp_replace(sub, '\\{', ''), '\\}', '') managebranch,
StartDate
FROM (
SELECT
*
FROM
ods_aimsen_base_regionhistories lateral VIEW explode(split(ManageBranchNos,'\\}\\{')) tmp
AS sub
) tmp_a
炸开后效果:
示例1:
row_number() 函数打行号: