[Bug] [ClickHouseFile] Nonzero exit code: 62

[adonis-lau]

Search before asking

• [X] I had searched in the issues and found no similar issues.

What happened

Code: 62. DB::Exception: Syntax error: failed at position 114 (','):

java.lang.RuntimeException: Nonzero exit code: 62

SeaTunnel Version

2.1.3

SeaTunnel Config

sink {
    Console{}
    ClickhouseFile {
        host = "hostname:8123"
        database = "test"
        table = "test_seatunnel_file"
        fields = ["id", "rule_id", "rule_input_entry_id", "values_map", "index", "create_time", "update_time"]
        username = ""
        password = ""
        clickhouse_local_path = "/usr/bin/clickhouse-local"
        node_free_password = false
        node_pass = [
            {
                node_address = "hostname"
                password = "pawd"
            }
        ]
    }
}

Running Command

./bin/start-seatunnel-spark.sh --config jobs/spark.batch.test_seatunnel_file.conf -e client -m 'local[*]'

Error Exception

Code: 62. DB::Exception: Syntax error: failed at position 114 (','): ,create_time String,update_time String) ENGINE = File(TSV, stdin);CREATE TABLE t_ds_relation_rule_input_entry_seatunnel_file (id Int32, rule_id Int32, rule_inpu. Expected one of: lambda expression, token, OpeningRoundBracket, list of elements, identifier, Arrow, expression with ternary operator, logical-OR expression, list, delimited by operator of variable arity, logical-AND expression, logical-NOT expression, expression with prefix unary operator, NOT, nullity checking, comparison expression, list, delimited by binary operators, BETWEEN expression, string concatenation expression, additive expression, INTERVAL operator expression, INTERVAL, TIMESTAMP operator expression, TIMESTAMP, DATE operator expression, DATE, multiplicative expression, unary expression, tuple element expression, array element expression, CAST expression, element of expression, SELECT subquery, CAST operator, tuple, collection of literals, parenthesized expression, array, literal, NULL, number, Bool, true, false, string literal, CAST AS expression, CAST, EXTRACT expression, EXTRACT, DATE_ADD expression, DATEADD, DATE_ADD, TIMESTAMPADD, TIMESTAMP_ADD, DATESUB, DATE_SUB, TIMESTAMPSUB, TIMESTAMP_SUB, DATE_DIFF expression, DATEDIFF, DATE_DIFF, TIMESTAMPDIFF, TIMESTAMP_DIFF, SUBSTRING expression, SUBSTRING, TRIM expression, LTRIM, RTRIM, TRIM, LEFT expression, LEFT, RIGHT expression, RIGHT, case, CASE, COLUMNS matcher, COLUMNS, function, qualified asterisk, compound identifier, asterisk, exists expression, EXISTS, substitution, MySQL-style global variable. (SYNTAX_ERROR)

Zeta or Flink or Spark Version

Spark 2.3

Java or Scala Version

jdk 1.8

Screenshots

No response

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

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

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions[bot]]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.