Partition Processing Requirements

To perform multithreaded partition processing for a table, the table must meet the following requirements:
Single key or offset column
The table must have a single primary key or user-defined offset column. Performing multithreaded partition processing on a table with composite keys generates an error and stops the pipeline.
If a table does not have a primary key column, you can use the Override Offset Columns property to specify a valid offset column to use. Having an ascending index on the offset column is strongly encouraged since the underlying query uses an ORDER BY and inequality operators on this column.
Numeric data type
To use partition processing, the primary key or user-defined offset column must have a numeric data type that allows arithmetic partitioning.
The key or offset column must be one of the following data types:
  • Integer-based: Integer, Smallint, Tinyint
  • Long-based: Bigint, Date, Time, Timestamp.

    The Oracle data type Timestamp with time zone is also supported, as long as each row has the same time zone.

  • Float-based: Float, Real
  • Double-based: Double
  • Precision-based: Decimal, Numeric