Hive学习笔记 --- Hive创建分区表

来源:互联网 发布:历史 知乎 编辑:程序博客网 时间:2024/05/16 04:49

此处是一个较完整的建hive表的语句。

create table if not exists `sdm_risk_flow`(`ID` string, `STATES` string, `ENABLED` string, `EVENT_ID` string) 
partitioned by (dt string) row format delimited fields terminated by "        " STORED AS ORC