MySQL Connector

MySQL Connector

Key range partitioning

Key range partitioning

You can configure key range partitioning when you use a
mapping
task to read data from MySQL sources. With key range partitioning, the Secure Agent distributes rows of source data based on the fields that you define as partition keys. The Secure Agent compares the field value to the range values for each partition and sends rows to the appropriate partitions.
Use key range partitioning for columns that have an even distribution of data values. Otherwise, the partitions might have unequal size. For example, a column might have 10 rows between key values 1 and 1000 and the column might have 999 rows between key values 1001 and 2000. If the mapping includes multiple sources, use the same number of key ranges for each source.
When you define key range partitioning for a column, the Secure Agent reads the rows that are within the specified partition range. For example, if you configure two partitions for a column with the ranges as 10 through 20 and 30 through 40, the Secure Agent does not read the rows 20 through 30 because these rows are not within the specified partition range.
Consider the following rules when you configure partitioning:
  • You can configure a partition key for fields of the following data types:
    • String
    • Any type of number data type. However, you cannot use decimals in key range values.
    • Date/time type. Use the following format: MM/DD/YYYY HH24:MI:SS
  • You cannot use key range partitions when a mapping includes any of the following transformations:
    • Web Services
    • XML to Relational
  • When you specify the datetime and datetime2 columns with subseconds as the key range values in a partitioning, the records are not loaded to the target. You must delete the value in subseconds from the values specified in the partitioning and run the mapping.

0 COMMENTS

We’d like to hear from you!