在大数据计算MaxCompute使用dw的数据同步功能 同步到事务表报错,怎么解决?ODPS 目的表在提交时失败, uploadId=[2024061707451618e3db0b007fddfa]. 请联系 ODPS 管理员处理. - RequestId=2024061707542018e3db0b013aeb8d, ErrorCode=FlowExceeded, ErrorMessage=CommitUpsert QPS Quota exceeded
at com.aliyun.odps.tunnel.impl.SessionBase.httpRequest(SessionBase.java:54)
at com.aliyun.odps.tunnel.impl.UpsertSessionImpl.commit(UpsertSessionImpl.java:151)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsUtil.lambda$masterComplete$15(OdpsUtil.java:519)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsRetryUtil.doRetry(OdpsRetryUtil.java:107)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsRetryUtil.executeWithRetry(OdpsRetryUtil.java:58)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsUtil.masterComplete(OdpsUtil.java:518)
at com.alibaba.datax.plugin.writer.odpswriter.OdpsWriter$Task.post(OdpsWriter.java:1063)
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:114)
at java.lang.Thread.run(Thread.java:853)
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsUtil.masterComplete(OdpsUtil.java:523)
at com.alibaba.datax.plugin.writer.odpswriter.OdpsWriter$Task.post(OdpsWriter.java:1063)
at com.alibaba.datax.core.taskgroup.runner.WriterRunner.run(WriterRunner.java:114)
at java.lang.Thread.run(Thread.java:853)
Caused by: RequestId=2024061707542018e3db0b013aeb8d, ErrorCode=FlowExceeded, ErrorMessage=CommitUpsert QPS Quota exceeded
at com.aliyun.odps.tunnel.impl.SessionBase.httpRequest(SessionBase.java:54)
at com.aliyun.odps.tunnel.impl.UpsertSessionImpl.commit(UpsertSessionImpl.java:151)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsUtil.lambda$masterComplete$15(OdpsUtil.java:519)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsRetryUtil.doRetry(OdpsRetryUtil.java:107)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsRetryUtil.executeWithRetry(OdpsRetryUtil.java:58)
at com.alibaba.datax.plugin.writer.odpswriter.util.OdpsUtil.masterComplete(OdpsUtil.java:518)
... 3 more 但是我已经提交生产环境了
这里设置一下 delta table 有qps限制,如果同步任务的并发设置的超过1,就需要在这里设置同步完成后可见。如果并发设置成1,这里就无所谓了
此回答整理自钉群“MaxCompute开发者社区2群”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
MaxCompute(原ODPS)是一项面向分析的大数据计算服务,它以Serverless架构提供快速、全托管的在线数据仓库服务,消除传统数据平台在资源扩展性和弹性方面的限制,最小化用户运维投入,使您经济并高效的分析处理海量数据。