Hive建表语句

1、Hive建表语句

CREATE TABLE `app_order_city_d` (
`city_id` int COMMENT ‘城市id‘,
`cnt_ord_succ_d` int COMMENT ‘当日完成订单数‘,
`cnt_ord_cacel_d` int COMMENT ‘当日取消订单数‘,
`cnt_ord_d` int COMMENT ‘当日下单订单数‘,
`cnt_ord_user` int COMMENT ‘当日下单用户数‘
)COMMENT ‘每日完成订单数‘
PARTITIONED BY(dt STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ‘\t‘
STORED AS TEXTFILE;

Hive建表语句

原文：https://www.cnblogs.com/guoyu1/p/12091541.html