Quick BI使用Maxcompute数据源创建sql数据集时报错

问题描述

使用Maxcompute创建sql数据集时报错,报错信息如下:

报错: null : INTERNAL: java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: execute sql [SELECT ALL_T_1_.`business_serial_number` AS T_A94_2_, ALL_T_1_.`balance` AS T_AF9_3_, ALL_T_1_.`business_basic_order_number` AS T_AED_4_, ALL_T_1_.`business_order_number` AS T_A13_5_, ALL_T_1_.`expense` AS T_AF1_6_, ALL_T_1_.`product_name` AS T_A25_7_, ALL_T_1_.`k3_shop_name` AS T_A4D_8_, ALL_T_1_.`remark` AS T_A99_9_, ALL_T_1_.`merchant_order_number` AS T_A6D_10_, ALL_T_1_.`business_description` AS T_AF9_11_, ALL_T_1_.`trading_channel` AS T_ACA_12_, ALL_T_1_.`id` AS T_AF9_13_, ALL_T_1_.`business_bill_source` AS T_A32_14_, ALL_T_1_.`code` AS T_A51_15_, ALL_T_1_.`income` AS T_AC2_16_, ALL_T_1_.`business_type` AS T_AC5_17_, ALL_T_1_.`time` AS T_AED_18_, ALL_T_1_.`account_serial_number` AS T_A49_19_, ALL_T_1_.`pid` AS T_AF1_20_, ALL_T_1_.`accounts` AS T_ACE_21_, ALL_T_1_.`pt` AS T_A80_22_ FROM `unq_dataanalysis`.`ali_pay_bill` ALL_T_1_ LIMIT 200;] instance:[20210906060809321ghotkta2] failed: RequestId=20210906140809a3baca0b10fa3842, ErrorCode=TaskFailed, ErrorMessage=ODPS-0130071:[0,0] Semantic analysis exception - physical plan generation failed: java.lang.RuntimeException: Table(unq_dataanalysis,ali_pay_bill) is full scan with all partitions, please specify partition predicates.##

问题原因

由于是分区表,因参数设置,不支持全表扫描。

解决方案

在编写sql的时候要加上分区条件限制。

适用于

  • Quick BI