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

最新推荐文章于 2024-11-13 11:50:06 发布

徐凤年不是真无敌

最新推荐文章于 2024-11-13 11:50:06 发布

阅读量1.1k

点赞数

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

本文链接：https://blog.csdn.net/AriesLY0411/article/details/124869073

版权

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

摘要由CSDN通过智能技术生成

数据准备

{"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},