Hive建表指定JsonSerde：解析Json格式日志文件

徐凤年不是真无敌

于 2022-05-19 19:11:34 发布

阅读量1.2k

点赞数

文章标签： hive hadoop 数据仓库 json

本文链接：https://blog.youkuaiyun.com/AriesLY0411/article/details/124869073

版权

本文介绍了如何在Hive中利用JsonSerde解析Json格式的日志文件，通过建表语句和指定映射类将数据转换为二维表格格式，以便于查询和分析。

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

数据准备

{"student":{"name":"xiaowang","age":11,"sex":"M"},"class":{"book":"语文","level":2,"score":81},"teacher":{"name":"t1","class":"语文"}}
{"student":{"name":"xiaoming","age":12,"sex":"M"},"class":{"book":"语文","level":2,"score":82},"teacher":{"name":"t2","class":"语文"}}
{"student":{"name":"xiaolan","age":13,"sex":"M"},"class":{"book":"语文","level":2,"score":83},"teacher":{"name":"t3","class":"语文"}}
{"student":{"name":"xiaohei","age":14,"sex":"M"},"class":{"book":"语文","level":2,"score":84},