create view as select * from table_a where pt = "20230522",把分区后边改成create view as select * from table_a where pt = ${var1},然后调度配置那里配置参数值,MaxCompute即便我把to_double的字段给去掉,其实还是同样的问题,怎么办?{"version":"logview_2.0","currentEpochMilli":1684827473209,"basicModel":{"id":"20230523073254497gkfv1su3pcg","name":null,"taskName":"console_query_task_1684827174281","projectName":"caiyun_ods","userName":"chaosconst@aliyun.com","yunAccount":"ALIYUN$chaosconst@aliyun.com","taskType":"SQL","subType":"SQL","priority":"9","status":"Failed","subStatus":[{"code":1010,"description":"Waiting for scheduling","startTime":"2023-05-23 15:32:54.679999 +0800","reserved":null},{"code":1020,"description":"Waiting for execution","startTime":"2023-05-23 15:32:54.686685 +0800","reserved":null},{"code":1030,"description":"Preparing for execution","startTime":"2023-05-23 15:32:54.688388 +0800","reserved":null},{"code":1032,"description":"Task is executing","startTime":"2023-05-23 15:32:54.696052 +0800","reserved":null},{"code":1210,"description":"SQLTask is initializing","startTime":"2023-05-23 15:32:54.696225 +0800","reserved":null},{"code":1220,"description":"SQLTask is compiling query","startTime":"2023-05-23 15:32:54.782806 +0800","reserved":{"CODE":"1220"}},{"code":1230,"description":"SQLTask is optimizing query","startTime":"2023-05-23 15:32:54.886102 +0800","reserved":{"CODE":"1230"}},{"code":1235,"description":"SQLTask is splitting data sources","startTime":"2023-05-23 15:32:54.948359 +0800","reserved":{"CODE":"1235"}},{"code":1240,"description":"SQLTask is generating execution plan","startTime":"2023-05-23 15:32:54.997869 +0800","reserved":{"CODE":"1240","META_LATENCY":"102567.0","META_COUNT":"7.0"}},{"code":1250,"description":"SQLTask is submitting execution plan","startTime":"2023-05-23 15:32:55.037220 +0800","reserved":{"CODE":"1250"}},{"code":1040,"description":"Job has been submitted","startTime":"2023-05-23 15:32:55.058946 +0800","reserved":null},{"code":1052,"description":"Online Job is running","startTime":"2023-05-23 15:32:55.064443 +0800","reserved":null},{"code":1050,"description":"Task rerun","startTime":"2023-05-23 15:33:42.075971 +0800","reserved":{"ObjectStatus":"9"}},{"code":1010,"description":"Waiting for scheduling","startTime":"2023-05-23 15:33:42.076052 +0800","reserved":null},{"code":1020,"description":"Waiting for execution","startTime":"2023-05-23 15:33:42.082675 +0800","reserved":null},{"code":1030,"description":"Preparing for execution","startTime":"2023-05-23 15:33:42.084039 +0800","reserved":null},{"code":1032,"description":"Task is executing","startTime":"2023-05-23 15:33:42.745386 +0800","reserved":null},{"code":1210,"description":"SQLTask is initializing","startTime":"2023-05-23 15:33:42.745557 +0800","reserved":null},{"code":1220,"description":"SQLTask is compiling query","startTime":"2023-05-23 15:33:42.846776 +0800","reserved":{"CODE":"1220"}},{"code":1230,"description":"SQLTask is optimizing query","startTime":"2023-05-23 15:33:42.936960 +0800","reserved":{"CODE":"1230"}},{"code":1235,"description":"SQLTask is splitting data sources","startTime":"2023-05-23 15:33:42.993475 +0800","reserved":{"CODE":"1235"}},{"code":1240,"de
后边还有,不一定只在Calc1,如果要是一直报错的话应该后边还有,需要再找找,此回答整理自钉群“MaxCompute开发者社区2群”
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
MaxCompute(原ODPS)是一项面向分析的大数据计算服务,它以Serverless架构提供快速、全托管的在线数据仓库服务,消除传统数据平台在资源扩展性和弹性方面的限制,最小化用户运维投入,使您经济并高效的分析处理海量数据。