hive中牛逼的映射
CREATE TABLE IF NOT EXISTS jsontest(
date STRING,
channel STRING,
machine STRING,
resolution STRING,
display STRING,
ip STRING,
lat STRING,
lng STRING,
device_key STRING,
os_name STRING,
os_version STRING,
app_name STRING,
app_version STRING,
carradio_version STRING,
carradio_mac STRING,
property STRING,
crate_date STRING,
page STRING,
user_key STRING,
event STRING
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
"date"="$.date",
"channel"="$.data.channel",
"machine"="$.data.machine",
"resolution"="$.data.resolution",
"display"="$.data.display",
"ip"="$.data.ip",
"lat"="$.data.lat",
"lng"="$.data.lng",
"device_key"="$.data.device_key",
"os_name"="$.data.os_name",
"os_version"="$.data.os_version",
"app_version"="$.data.app_version",
"carradio_version"="$.data.carradio_version",
"carradio_mac"="$.data.carradio_mac",
"property"="$.data.property",
"crate_date"="$.data.date",
"page"="$.data.page",
"user_key"="$.data.user_key",
"event"="$.data.event",
"ignore.malformed.json"="true"
)
STORED AS TEXTFILE;
本文来自博客园,作者:硅谷工具人,转载请注明原文链接:https://www.cnblogs.com/30go/p/17216063.html
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步