hive中get_json_object获取多个字典中同一个key的value

array里面包含多个json字典，获取多个字典中同一个key的value

select get_json_object('[{"ecode":"2023-07-01至2025-10-17","ename":"2023-09-01至2023-10-17","esort":0,"tcode":"dt","type":2},{"ecode":"17","ename":"xx","esort":0,"tcode":"cate_code10_list","type":4}]',"$[*].tcode")
1