CREATE EXTERNAL TABLE xxx
(
url
string COMMENT ‘当前访问url’,
refer_url
string COMMENT ‘检索请求httpreferer’)
COMMENT ‘列式存储测试’
PARTITIONED BY (
dt
string COMMENT ‘日期分区’)
ROW FORMAT SERDE
‘org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe’
STORED AS INPUTFORMAT
‘org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat’
OUTPUTFORMAT
‘org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat’
列式存储外部表创建
最新推荐文章于 2024-08-21 21:52:49 发布