409
社区成员
发帖
与我相关
我的任务
分享S3 copy时候总提示找不到该文件。急急急！！
An error occurred when executing the SQL command:
copy TR_BUYER_SELLER from 's3://awssampledbuswest2/xxl2/test2.csv'CREDENTIALS'aws_access_key_id=AKIAIXJXDM3WQLCESTUQ;aws_secret_access_key=YyUI+III03p...
ERROR: The specified S3 prefix 'xxl2/test2.csv' does not exist
Detail:
-----------------------------------------------
error: The specified S3 prefix 'xxl2/test2.csv' does not exist
code: 8001
context:
query: 17775
location: s3_utility.cpp:545
process: padbmaster [pid=22651]
----------------------------------------------- [SQL State=XX000]
Execution time: 0.37s
1 statement(s) failed.
copy TR_BUYER_SELLER from 's3://awssampledbuswest2/xxl2/test2.csv'CREDENTIALS'aws_access_key_id=AKIAIXJXDM3WQLCESTUQ;aws_secret_access_key=YyUI+III03p...
ERROR: The specified S3 prefix 'xxl2/test2.csv' does not exist
Detail:
-----------------------------------------------
error: The specified S3 prefix 'xxl2/test2.csv' does not exist
code: 8001
context:
query: 17775
location: s3_utility.cpp:545
process: padbmaster [pid=22651]
----------------------------------------------- [SQL State=XX000]
Execution time: 0.37s
1 statement(s) failed.
...全文
请发表友善的回复…
发表回复
sundunxxl 2014-08-11
- 打赏
- 举报
在SqlWorkbench中执行，copy命令 把数据从s3 copy到redshift 总提示找不到文件
發糞塗牆 2014-08-11
- 打赏
- 举报
我每次都用这个语句来传备份文件的：上传文件到S3：aws s3 cp 本地绝对路径\文件名 s3://remote_S3_bucket
sundunxxl 2014-08-11
- 打赏
- 举报
能否留下个联系方式，请教一下
sundunxxl 2014-08-11
- 打赏
- 举报
楼上的大哥，怎么执行list xxl2 ？用客户端工具？
RLib 2014-08-11
- 打赏
- 举报
你不妨先执行list xxl2确定文件是否存在？
