hive常用的命令（一）

**

1、hive string类型数组转数组在炸开

**
LATERAL VIEW EXPLODE(
split(
regexp_replace(
regexp_extract(string_array, ‘^\[(.+)\]$’, 1),
‘\}\,\{’,
‘\}\|\|\{’
),
‘\|\|’
)
) disp_result AS disp_result_tpye

LATERAL VIEW explode (from_json (string_array, “array”)) table_tags as tag_data
LATERAL VIEW explode (from_json(context, ‘array<array>’)) table_tags as tag_data

2、hive map转map string函数to_json, string转map函数from_json

这是啥to_json(struct())？
to_json(named_struct(‘id’, message_id, ‘query’, query, ‘history_qa’, context, ‘response’, response, ‘create_time’, create_time, ‘session_id’, session_id)) AS mes

3、hive拼接map类型字段STR_TO_MAP

select
STR_TO_MAP(concat(‘appid#&:&#’,appid,‘#&&&#baiduid#&:&#’,baiduid,‘#&&&#duan_flag#&:&#’,duan_flag,‘#&&&#event_ip#&:&#’,event_ip,‘#&&&#event_city#&:&#’,event_city),‘#&&&#’,‘#&:&#’) as map_2,
appid,
baiduid,
duan_flag,
event_city,
event_ip
from
yiyan_maidian_log.default.yiyan_ods_maidian_client_hi
where event_day = ‘20231115’
and event_hour = ‘04’
limit