i am trying to load the content of cs file into a clickhouse database . i have created the table in the clickhouse db and defined the columns and their types . and i added the connection to the database and it was successful the issue is when the job is completed , the data is not added to the database table and i get the folllowing error :
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.talend.components.api.component.runtime.JarRuntimeInfo (file:/C:/talend/TOS_DI-Win32-20200219_1130-V7.3.1/configuration/.m2/repository/org/talend/components/components-api/0.28.2/components-api-0.28.2.jar) to field java.net.URL.factory
WARNING: Please consider reporting this to the maintainers of org.talend.components.api.component.runtime.JarRuntimeInfo
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
[WARN ] 15:57:22 org.talend.components.jdbc.runtime.writer.JDBCOutputWriter- ClickHouse exception, code: 62, host: 10.1.5.225, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 14 (line 1, col 14): (Code,Name,Abbreviation) FORMAT TabSeparated
19031 Mackey International Inc. MAC
19032 Munz Northern Airlines Inc. XY
19033 Cochise Airlines Inc. COC
19034 . Expected one of: identifier, TABLE, FUNCTION (version 20.3.12.112)
i saw the answers in the community one of them suggested that i check java compatibility , so i downloaded the jdk from zulu and im still facing the same issue . another answer suggested that the error i got was due to a bug but the version that im using it said that it solved that bug . be noted that im using talend version 7.3 and jdk 11 . i have attached an image of the job that im initializing .
