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
· 全网最简单!3分钟用满血DeepSeek R1开发一款AI智能客服,零代码轻松接入微信、公众号、小程
· .NET 10 首个预览版发布,跨平台开发与性能全面提升
· 《HelloGitHub》第 107 期
· 全程使用 AI 从 0 到 1 写了个小工具
· 从文本到图像:SSE 如何助力 AI 内容实时呈现?(Typescript篇)
2022-03-14 frp将内网网站映射到外网记录