语法对比hive稍有不同,直接上代码:
select d,v from (select '04046884_20240805090332_82535' as d)T1, lateral table(string_split(d, '_')) as T(v);
-- 待补充
京公网安备 11010502049817号