ORC文件--包含snappy、zlib两种压缩格式,不需要配置compress参数
CREATE EXTERNAL TABLE tbl_orc_snappy_comma
(
str
string,
int1
string)
ROW FORMAT delimited fields terminated by ','
stored as orc tblproperties("orc.compress"="SNAPPY")
ORC文件--包含snappy、zlib两种压缩格式,不需要配置compress参数
CREATE EXTERNAL TABLE tbl_orc_snappy_comma
(
str
string,
int1
string)
ROW FORMAT delimited fields terminated by ','
stored as orc tblproperties("orc.compress"="SNAPPY")
本文标题:hive建表-指定文件类型和压缩类型以及字段分隔符
本文链接:https://www.haomeiwen.com/subject/ntkgqktx.html
网友评论