Help Center/ Data Lake Insight/ FAQs/ Problems Related to SQL Jobs/ Job O&M Errors/ Why Is Error "There should be at least one partition pruning predicate on partitioned table XX.YYY" Reported When a Query Statement Is Executed?
Updated on 2023-05-19 GMT+08:00
View PDF
Share

Why Is Error "There should be at least one partition pruning predicate on partitioned table XX.YYY" Reported When a Query Statement Is Executed?

  • Cause Analysis

    When you query the partitioned table XX.YYY, the partition column is not specified in the search criteria.

    A partitioned table can be queried only when the query condition contains at least one partition column.

  • Solution

    Query a partitioned table by referring to the following example:

    Assume that partitionedTable is a partitioned table and partitionedColumn is a partition column. The query statement is as follows:

    SELECT * FROM partitionedTable WHERE partitionedColumn  = XXX

Parent topic: Job O&M Errors