举例
-- 创建一个外部表来映射 OSS 的分区表
CREATE EXTERNAL TABLE oss_data_table
(
column1 INT,
column2 STRING,
d_key STRING, -- 分区列
-- 根据实际文件中的列添加更多列
)
ENGINE=FILE
PROPERTIES (
"partition_key" = "d_key", --支持多个
"uri" = "http://example-bucket.oss-cn-beijing.aliyuncs.com/your-
folder",
"s3.access_key"= "ak",
"s3.secret_key" = "sk",
"s3.endpoint" = "oss-cn-beijing.aliyuncs.com",
"s3.region" = "oss-cn-beijing",
"format" = "parquet"
);