-- 导出 EXPORT TABLE test TO "s3://bucketName/目录/表名/" WITH S3 ( "AWS_ENDPOINT" = "http://endpoint", "AWS_ACCESS_KEY" = "***", "AWS_SECRET_KEY"="***", "AWS_REGION" = "endpoint" ); -- 查看导出状态 show EXPORT; -- 按照原有表创建新表,用于对比 create table test_new like test; -- 导入 LOAD LABEL tablespase.test_new ( DATA INFILE("s3://bucketName/目录/表名/分片名") INTO TABLE test_new COLUMNS TERMINATED BY "\t" ) WITH S3 ( "AWS_ENDPOINT" = "http://endpoint", "AWS_ACCESS_KEY" = "***", "AWS_SECRET_KEY"="***", "AWS_REGION" = "endpoint" ) PROPERTIES ( "timeout" = "3600" );
Doris通过阿里云OSS导出导入
于 2023-05-23 14:54:40 首次发布