大数据之Hive:get_json_object函数使用
目录1.数据2.取出第一个json对象3.取出第一个json的age字段的值4.取出嵌套的json的city的值5.复杂案例1.数据
with temp_1 as (select 水浒传 as book, 大郎 as name , 男 as sex,25 as ageunion all select 水浒传 as book, 西门庆 as name , 男 as sex,47 as age
)select
…
2026/8/6 17:31:59