代码:
create external table if not exists ods_nshop_203.ods_nshop_01_useractlog(
action string comment ‘行为类型:install安装|launch启动|interactive交互|page_enter_h5页面曝光|page_enter_native页面进入|exit退出’,
event_type string comment ‘行为类型:click点击|view浏览|slide滑动|input输入’,
customer_id string comment ‘用户id’,
device_num string comment ‘设备号’,
device_type string comment ‘设备类型’,
os string comment ‘手机系统’,
os_version string comment ‘手机系统版本’,
manufacturer string comment ‘手机制造商’,
carrier string comment ‘电信运营商’,
network_type string comment ‘网络类型’,
area_code string comment ‘地区编码’,
longitude string comment ‘经度’,
latitude string comment ‘纬度’,
extinfo string comment ‘扩展信息(json格式)’,
duration string comment ‘停留时长’,
ct bigint comment ‘创建时间’
) partitioned by (bdp_day string)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe’
STORED AS TEXTFILE
location ‘/data20
hive建表错误
最新推荐文章于 2024-05-20 13:09:00 发布