Loading csv file to clickhouse database

AAlbakri1608123911 — Sat, 16 Nov 2024 00:56:39 GMT

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 .

Re: Loading csv file to clickhouse database

Anonymous — Thu, 17 Dec 2020 08:13:15 GMT

Hello,

Could you please activate the Die on error option in tDBOutput component to try to catch the rows on error?

Best regards

Sabrina

topic Loading csv file to clickhouse database in Data Quality

Loading csv file to clickhouse database

Re: Loading csv file to clickhouse database