我正在尝试使用Data Pipeline在Redshift中运行每日迁移脚本。 当我使用SQL Workbench / J直接运行脚本时,脚本按预期工作,但在通过Data Pipeline触发时失败。
我用这个简单的代码重现了这个问题:
drop table if exists image_stg; create table image_stg (like image_full); select * from image_stg;当我在Data Pipeline中运行它时,我收到此错误:
[亚马逊](500310)操作无效:关系“image_stg”不存在;
我也有一次这个错误,对于完全相同的代码,没有改变任何东西:
[亚马逊](500310)操作无效:与OID 108425的关系不存在。
这是两个错误消息的屏幕截图:
我在AWS论坛上发现了这个帖子,但它没有帮助: 管道开始在简单的Redshift SqlActivity和临时表上失败
导致此错误的原因是什么? 有解决方法吗?
I'm trying to run a daily migration script in Redshift using Data Pipeline. The script works as expected when I run it directly using SQL Workbench/J, but fails when triggered through Data Pipeline.
I have reproduced the problem with this simple code:
drop table if exists image_stg; create table image_stg (like image_full); select * from image_stg;When I run it in Data Pipeline, I get this error:
[Amazon](500310) Invalid operation: relation "image_stg" does not exist;
I also got this error once, for the exact same code, without changing anything:
[Amazon](500310) Invalid operation: Relation with OID 108425 does not exist.;
Here's a screenshot of the two error messages:
I've found this thread on the AWS forums, but it didn't help: Pipeline started failing on simple Redshift SqlActivity and temp table
What is causing this error? Is there a workaround?
最满意答案
我已经联系了亚马逊,它看起来像数据管道中的一个问题。 他们确实提出了一个似乎在我的情况下工作的解决方法:将JDBC连接字符串从jdbc: redshift ://…更改为jdbc: postgresql ://…
I've contacted Amazon, and it looks like a problem in Data Pipeline. They did suggest a workaround that seems to work in my case: Change the JDBC connection string from jdbc:redshift://… to jdbc:postgresql://… .
更多推荐
发布评论