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
p1, p2, p3, and p4
are the names of partitions.- 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.
- Comparative operators include
>, >=, =, <, <=, <>
. - The
IN
operator is supported. - Logical operators include
AND and OR
. - Parentheses () are supported.