文档首页>
数据湖探索 DLI>
常见问题>
SQL作业相关问题>
作业运维报错>
执行查询语句报错：There should be at least one partition pruning predicate on partitioned table XX.YYY
更新时间：2022-09-29 GMT+08:00
执行查询语句报错：There should be at least one partition pruning predicate on partitioned table XX.YYY
父主题： 作业运维报错
作业运维报错 所有常见问题
- 用户导表到OBS报“path obs://xxx already exists”错误
- 对两个表进行join操作时，提示：SQL_ANALYSIS_ERROR: Reference 't.id' is ambiguous, could be: t.id, t.id.;
- 执行查询语句报错：The current account does not have permission to perform this operation,the current account was restricted. Restricted for no budget.
- 执行查询语句报错：There should be at least one partition pruning predicate on partitioned table XX.YYY
- LOAD数据到OBS外表报错：IllegalArgumentException: Buffer size too small. size
- SQL作业运行报错：DLI.0002 FileNotFoundException
- 用户通过CTAS创建hive表报schema解析异常错误
- 在DataArts Studio上运行DLI SQL脚本，执行结果报org.apache.hadoop.fs.obs.OBSIOException错误
- 使用CDM迁移数据到DLI，迁移作业日志上报UQUERY_CONNECTOR_0001:Invoke DLI service api failed错误
- SQL作业访问报错：File not Found
- SQL作业访问报错：DLI.0003: AccessControlException XXX
- SQL作业访问外表报错：DLI.0001: org.apache.hadoop.security.AccessControlException: verifyBucketExists on {{桶名}}: status [403]
- 执行SQL语句报错：The current account does not have permission to perform this operation,the current account was restricted. Restricted for no budget.
more
