get_json_object不能解析json里面中文的key

最新推荐文章于 2025-03-15 14:55:10 发布

原创最新推荐文章于 2025-03-15 14:55:10 发布 · 5.3k 阅读

2 ·

CC 4.0 BY-SA版权

hive 专栏收录该内容

9 篇文章

订阅专栏

本文探讨了在Hive中使用json_tuple函数替代get_json_object函数，以更高效地解析包含中文key的JSON字符串。通过实际案例对比，展示了如何利用json_tuple进行多字段同时解析，从而提升查询效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

get_json_object不能解析json里面中文的key

一般来说不会把json中的key定义为中文，但是如果是中文的话可以用 hive 的json_tuple

json_tuple

A new json_tuple() UDTF is introduced in Hive 0.7. It takes a set of names (keys) and a JSON string, and returns a tuple of values using one function. This is much more efficient than calling GET_JSON_OBJECT to retrieve more than one key from a single JSON string. In any case where a single JSON string would be parsed more than once, your query will be more efficient if you parse it once, which is what JSON_TUPLE is for. As JSON_TUPLE is a UDTF, you will need to use the LATERAL VIEW syntax in order to achieve the same goal.

For example,

select a.timestamp, get_json_object(a.appevents, '$.eventid'), get_json_object(a.appenvets, '$.eventname') from log a;

should be changed to:

select a.timestamp, b.*

from log a lateral view json_tuple(a.appevent, 'eventid', 'eventname') b as f1, f2;