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