数据湖探索 DLI-DLI Delta常见问题:执行sql报错DLI.0005: There should be at least one partition pruning predicate on partitioned table `777dd`.`test_delta_parts1`

时间:2025-02-12 15:00:27

执行sql报错 DLI .0005: There should be at least one partition pruning predicate on partitioned table `777dd`.`test_delta_parts1`

解决方案:在console页面设置中添加参数spark.sql.forcePartitionPredicatesOnPartitionedTable.enabled值为false。

support.huaweicloud.com/sqlref-delta-dli/dli_delta_0035.html