OSS表属性
- auto_create_location
再DLA上自动创建OSS 对应的目录，并创建表。
CREATE EXTERNAL TABLE person (
`id` int,
`name` string,
`age` int
)
STORED AS TEXTFILE
LOCATION 'oss://bucket001/dir001/'
TBLPROPERTIES (
'auto.create.location'='true'
);
- compression_type
手动指定压缩格式，写入oss默认是snappy。（目前只支持snappy，gzip，不压缩）
CREATE EXTERNAL TABLE person (
`id` int,
`name` string,
`age` int
)
STORED AS TEXTFILE
LOCATION 'oss://bucket001/dir001/'
TBLPROPERTIES (
'compression.type'='gzip'
);