随笔分类 -  hive

hive时间函数
摘要：select times -- 2021-08-30 17:46:01,to_date(times) -- 2021-08-30,hour(times) -- 17,day(times) -- 30,weekofyear(times) -- 35,minute(times) -- 46,second 阅读全文
posted @ 2021-08-30 11:21 MrTang88 阅读(193) 评论(0) 推荐(0)
hive解析json数组数据
摘要：/*样本数据60862 2227577 CN020004021585629448991 oe8GejqY8gkJwP8FX0149SltKi94 1585584000 [{"key":"key1","value":"营养健康"},{"key":"key2","value":null},{"key": 阅读全文
posted @ 2020-04-03 12:38 MrTang88 阅读(7835) 评论(1) 推荐(0)