Adjusting logging configuration in Advanced Settings

You can customize the logging configurations for the SQL Stream Builder (SSB) job on the Streaming SQL Console in per-job mode or session mode. Adjusting the log configuration enables you to control the log levels of all the underlying libraries: Flink, Hadoop, Kafka, Zookeeper, other common libraries, and connectors to get more or less information in your job’s log.

The customization of the log configuration works differently based on the job deployment mode:
Session mode
The execution.target is set to yarn-session mode, this is the default execution mode.
The log configuration is set at the start time if the Flink YARN session is applied to every job execution. For example, the current log configuration is applied if and only if the Flink YARN session is not set on the Session tab of the Compose page.
Per-job mode
The execution.target is set to yarn-per-job mode.
When you change the default execution mode to per-job, the currently applied log configuration is going to be used for the job. To configure the execution mode, you need to start the SQL query with the following line:
SET 'execution.target'='yarn-per-job';
  1. Select Console on the main menu.
  2. Select Settings from the Compose page.
  3. Click Advanced Settings.
    The Custom Log Configuration window appears.
  4. Click into the configuration window or click Edit.
  5. Modify the settings based on your requirements.
  6. Click Apply.
  7. Add and execute a SQL statement.
  8. Click SQL Jobs.
  9. Search for the job you have executed previously.
  10. Click Flink Dashboard.
    The Flink Dashboard opens in a new window.
  11. Click Task Managers > Logs.
    The log information appears in the log window based on your custom configurations.