[Bug][Audit] SQL file executed error for ClickHouse in Audit

[healchow]

What happened

Execute the apache_inlong_audit_clickhouse.sql error:

5b142b25d12d :) SET NAMES utf8mb4;

Syntax error: failed at position 11 ('utf8mb4'):

SET NAMES utf8mb4;

Expected one of: token, Dot, Equals

5b142b25d12d :) SET FOREIGN_KEY_CHECKS = 0;

SET FOREIGN_KEY_CHECKS = 0

Query id: a79b41c4-f65e-44cf-a76d-bd49de02c293

0 rows in set. Elapsed: 0.001 sec. 

Received exception from server (version 22.1.3):
Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: Unknown setting FOREIGN_KEY_CHECKS. (UNKNOWN_SETTING)

5b142b25d12d :) SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

Syntax error: failed at position 16 ('"NO_AUTO_VALUE_ON_ZERO"'):

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

Expected one of: TRUE, FALSE, literal, NULL, number, Bool, true, false, string literal

5b142b25d12d :) SET time_zone = "+00:00";

Syntax error: failed at position 17 ('"+00:00"'):

SET time_zone = "+00:00";

Expected one of: TRUE, FALSE, literal, NULL, number, Bool, true, false, string literal

What you expected to happen

Can execute successfully.

How to reproduce

Just execute the apache_inlong_audit_clickhouse.sql.

Environment

No response

InLong version

master

InLong Component

InLong Audit

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[ciscozhou]

I want to fix this issue.