WATERMARK_ADVANCEMENT_STRATEGY error condition

SQLSTATE: 0A000

Streaming watermark advancement strategy has the following limitation:

MAX_NOT_SUPPORTED_IN_RTM

The MAX watermark advancement strategy is not supported in Streaming Real-Time Mode.

To proceed with real-time mode, set spark session configuration "spark.databricks.streaming.watermarkAdvancementStrategy" to "min".

MIN_NOT_SUPPORTED_IN_MBM

The MIN watermark advancement strategy is not supported in Streaming Micro-Batch Mode.

To proceed with micro-batch mode, set spark session configuration "spark.databricks.streaming.watermarkAdvancementStrategy" to "max".