OSS半结构化数据导入MaxCompute
1)确保网络连通和访问权限开通
2)创建外部表(External Table)
DROP TABLE IF EXISTS table_name_external;
CREATE EXTERNAL TABLE IF NOT EXISTS table_name_external
(
shipdate STRING,
linestatus STRING,
shipmode STRING,
comment STRING
) COMMENT '表备注'
-- 存储方式
STORED BY TEXTFILE
-- 分隔符
row format delimited fields terminated by '|'
-- 数据路径
LOCATION 'oss://${endpoint}/${bucket}/${userPath}/'
-- 生命周期
lifecycle 30;