This topic describes how the compatibility between a job and the state data is affected after you modify a regular join, interval join, temporal join, or lookup join in an SQL statement for the job.
- Regular join
The state data of operators related to a regular join cannot be migrated. Therefore, if you modify a regular join attribute, such as the join type, join condition, or the schema in a join, in an SQL statement for a job, the job becomes incompatible with the state data.
- Interval join
The state data of operators related to an interval join cannot be migrated. Therefore, if you modify an interval join attribute, such as the join type, join condition, interval, or the schema in a join, in an SQL statement for a job, the job becomes incompatible with the state data.
- Temporal join
The state data of operators related to a temporal join cannot be migrated. Therefore, if you modify a temporal join attribute, such as the join type, join condition, or the schema in a join, in an SQL statement for a job, the job becomes incompatible with the state data.
- Lookup join
State data is not involved in a lookup join. Therefore, if you modify a lookup join, the state data compatibility of the operator of the lookup join is not affected but the state compatibility of its output operators is affected.