adonis-lau opened a new issue, #5554:
URL: https://github.com/apache/seatunnel/issues/5554

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22)
 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
   
   ```conf
   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
   
   ```shell
   ./bin/start-seatunnel-spark.sh --config 
jobs/spark.batch.test_seatunnel_file.conf -e client -m 'local[*]'
   ```
   
   
   ### Error Exception
   
   ```log
   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, p
 arenthesized 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](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to