DataWorks创建表失败:please check ram config or
DataWorks创建表失败:please check ram config or into access id, key into location property of DDL (not recommanded). DDL execute error, OdpsException: ODPS-0130071:[1,1] Semantic analysis exception - external table checking failure, error message: java.lang.RuntimeException: {"RequestId":"0FB1876E-A768-5CCE-B2FB-EC084C6BC346","HostId":"sts.aliyuncs.com","Code":"EntityNotExist.Role","Message":"The role not exists: acs:ram::1267257612131350:role/aliyunodpsdefaultrole. ","Recommend":"https://next.api.aliyun.com/troubleshoot?q=EntityNotExist.Role&product=Sts"} at com.aliyun.odps.meta2.util.StsClient.assumeRoleWithServiceIdentityNoRetry(StsClient.java:122) at com.aliyun.odps.meta2.util.StsClient.assumeRoleWithServiceIdentity(StsClient.java:84) at com.aliyun.odps.compiler.ExternalTableChecker$LocationChecker.annotateLocationWithSTSToken(ExternalTableChecker.java:616) at com.aliyun.odps.compiler.ExternalTableChecker$LocationChecker.create(ExternalTableChecker.java:580) at com.aliyun.odps.compiler.ExternalTableChecker.checkLocation(ExternalTableChecker.java:531) at com.aliyun.odps.compiler.ExternalTableChecker.check(ExternalTableChecker.java:109) at com.aliyun.odps.compiler.TypeChecker.checkExternalTable(TypeChecker.java:1389) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:1277) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CreateTableStatement.accept(CreateTableStatement.java:268) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:2536) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CompoundStatement.accept(CompoundStatement.java:52) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:2536) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CompoundStatement.accept(CompoundStatement.java:52) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:420) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.Script.accept(Script.java:117) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.check(TypeChecker.java:376) at com.aliyun.odps.compiler.OdpsQlCompiler.compile(OdpsQlCompiler.java:199) at com.aliyun.odps.compiler.OdpsQlCompiler.compile(OdpsQlCompiler.java:113) at com.aliyun.odps.sqltask.OdpsCompilerWrapper.parse(OdpsCompilerWrapper.java:199) at com.aliyun.odps.sqltask.OdpsCompilerWrapper.parse(OdpsCompilerWrapper.java:150) at com.aliyun.odps.sqltask.task.SqlTaskBase.doCompile(SqlTaskBase.java:117) at com.aliyun.odps.sqltask.task.SqlTaskBase.compile(SqlTaskBase.java:104) at com.aliyun.odps.sqltask.task.DDLTask.handleInternal(DDLTask.java:46) at com.aliyun.odps.sqltask.task.SqlTaskBase.handle(SqlTaskBase.java:77) at com.aliyun.odps.sqltask.SqlTaskDriver.execute(SqlTaskDriver.java:137) at com.aliyun.odps.sqltask.SqlTaskDriver.run(SqlTaskDriver.java:202) Direct error message: 执行SQL失败:SQL:create external table ds_229244678675550959_1681879847202_external 创建外部表报错创建表失败:please check ram config or into access id, key into location property of DDL (not recommanded). DDL execute error, OdpsException: ODPS-0130071:[1,1] Semantic analysis exception - external table checking failure, error message: java.lang.RuntimeException: {"RequestId":"0FB1876E-A768-5CCE-B2FB-EC084C6BC346","HostId":"sts.aliyuncs.com","Code":"EntityNotExist.Role","Message":"The role not exists: acs:ram::1267257612131350:role/aliyunodpsdefaultrole. ","Recommend":"https://next.api.aliyun.com/troubleshoot?q=EntityNotExist.Role&product=Sts"} at com.aliyun.odps.meta2.util.StsClient.assumeRoleWithServiceIdentityNoRetry(StsClient.java:122) at com.aliyun.odps.meta2.util.StsClient.assumeRoleWithServiceIdentity(StsClient.java:84) at com.aliyun.odps.compiler.ExternalTableChecker$LocationChecker.annotateLocationWithSTSToken(ExternalTableChecker.java:616) at com.aliyun.odps.compiler.ExternalTableChecker$LocationChecker.create(ExternalTableChecker.java:580) at com.aliyun.odps.compiler.ExternalTableChecker.checkLocation(ExternalTableChecker.java:531) at com.aliyun.odps.compiler.ExternalTableChecker.check(ExternalTableChecker.java:109) at com.aliyun.odps.compiler.TypeChecker.checkExternalTable(TypeChecker.java:1389) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:1277) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CreateTableStatement.accept(CreateTableStatement.java:268) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:2536) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CompoundStatement.accept(CompoundStatement.java:52) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:2536) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.CompoundStatement.accept(CompoundStatement.java:52) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:420) at com.aliyun.odps.compiler.TypeChecker.visit(TypeChecker.java:157) at com.aliyun.odps.compiler.Script.accept(Script.java:117) at com.aliyun.odps.compiler.TreeScanner.scan(TreeScanner.java:1601) at com.aliyun.odps.compiler.TypeChecker.check(TypeChecker.java:376) at com.aliyun.odps.compiler.OdpsQlCompiler.compile(OdpsQlCompiler.java:199) at com.aliyun.odps.compiler.OdpsQlCompiler.compile(OdpsQlCompiler.java:113) at com.aliyun.odps.sqltask.OdpsCompilerWrapper.parse(OdpsCompilerWrapper.java:199) at com.aliyun.odps.sqltask.OdpsCompilerWrapper.parse(OdpsCompilerWrapper.java:150) at com.aliyun.odps.sqltask.task.SqlTaskBase.doCompile(SqlTaskBase.java:117) at com.aliyun.odps.sqltask.task.SqlTaskBase.compile(SqlTaskBase.java:104) at com.aliyun.odps.sqltask.task.DDLTask.handleInternal(DDLTask.java:46) at com.aliyun.odps.sqltask.task.SqlTaskBase.handle(SqlTaskBase.java:77) at com.aliyun.odps.sqltask.SqlTaskDriver.execute(SqlTaskDriver.java:137) at com.aliyun.odps.sqltask.SqlTaskDriver.run(SqlTaskDriver.java:202) Direct error message: 执行SQL失败:SQL:create external table ds_229244678675550959_1681879847202_external
写回答
-
是角色模式登录dataworks操作的吗 还是登录的odpscmd ，看报错是执行的role已经不存在 The role not exists: acs:ram::1267257612131350:role/aliyunodpsdefaultrole. ，此回答整理自钉群“DataWorks交流群(答疑@机器人)”
2023-04-27 13:22:03赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
热门讨论
热门文章
相关文章
相关电子书
更多
