CREATE TABLE `table_name` (
`col1` string COMMENT '字段1',
`col2` string COMMENT '字段2'
) COMMENT '表注释'
partitioned by (dt string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ("field.delim"="$:|")
STORED AS TEXTFILE;
指定字段分隔符为多个的hive建表语句
最新推荐文章于 2021-10-19 00:21:27 发布