STREAMING_UNRESUMABLE_CONTROL_BATCH_DETECTED error condition

SQLSTATE: 55019

Unfinished control batch <batchId> cannot be resumed.

REPARTITION

Repartition batch has <unfinishedNumPartition> state partitions but the current query is requesting <requestedNumPartition>.

Set spark.sql.streaming.stateStore.partitions to <unfinishedNumPartition>, and rerun the query. Once that repartition finishes successfully, then you can change it to <requestedNumPartition>

SET_CHECKPOINT_PROPERTIES

Session conf <confKey> does not match the value <confValue> required by the pending batch for query <queryId>.