简单解析json

# json
{"id":1,"age":18}
# hive建表语句
create table json(name string);
# 加载数据进 json 表
load data local inpath "/root/data/hive/a.txt" into table json;
# 数据展示
+--------------------+
|     json.name      |
+--------------------+
| {"id":1,"age":18}  |
+--------------------+
# hql 语句解析json字符串
select name,
 b.* 
from json
lateral view json_tuple(name, 'id', 'age') b as f1, f2;
# 解析结果
+--------------------+-------+-------+
|       a.name       | b.f1  | b.f2  |
+--------------------+-------+-------+
| {"id":1,"age":18}  | 1     | 18    |
+--------------------+-------+-------+

**只能处理简单的，json 里面只能有一个 花括号 **