hive sql优化
–一、json优化
–1.使用json_tuple
–优化前
select
create_time as model_time,
to_date(create_time) as model_dt,
uid as user_id,
is_old_user,
app_name,
model as model_name,
get_json_object(get_json_object(regexp_replace(result, ‘NaN’, ‘""’), ‘.savevariables′),′.save_var
原创
2020-12-11 17:40:51 ·
110 阅读 ·
0 评论