All Products
Search
Document Center

MaxCompute:Partition filter expressions

Last Updated:Mar 08, 2024

This topic describes the partition filter expressions that are used when you configure parameters for data migration.

Example

p1 >= '2022-03-04' and (p2 = 10 or p3 > 20) and p4 in ('abc', 'cde')

Description

  1. p1, p2, p3, and p4 are the names of partitions.
  2. Partition values can be strings and numbers. Strings must be enclosed in double quotation marks (") or single quotation marks ("). All partition values, except the values of partition key columns of the INT or BIGINT type, must be strings.
  3. Comparative operators include >, >=, =, <, <=, <>.
  4. The IN operator is supported.
  5. Logical operators include AND and OR.
  6. Parentheses () are supported.