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
MaxCompute即便我把to_double的字段给去掉,其实还是同样的问题,怎么办?[阿里云MaxCompute]
「点点赞赏,手留余香」
还没有人赞赏,快来当第一个赞赏的人吧!