Question about DB Connection Table Writer

[GhinaF]

Hello,

I have a problem while running DB Connection Table Writer node in Knime AP.
I am writing in Impala database with this node and when I run it, I have an error message without precising the cause of the error. Anyone has seen this before and knows how to solve it?
Thank you

[AlexanderFillbrunn]

Hi,
Can you tell us the error message? Do you see anything meaningful in the KNIME Log unter View → Open KNIME Log…?
Kind regards,
Alexander

[mlauber71]

@GhinaF welcome to the KNIME forum. With Hive and Impala tables you will have to create them first (empty) before initially fill them. Once they exist you can append data:

Create Hive table from csv file

@galihbahtera welcome to the KNIME forum. You can import the data via the DB/hive loader. If the hive table already exists you could append it, the DB Connection Table Writer – KNIME Community Hub has this option. [image] Another option is to upload the CSV file (or better use parquet or ORC) to the HDFS and use it in an external table: If you want to learn more about KNIME and Hive you can take a look here:

---

School of Hive - with KNIME's local Big Data environment (SQL for Big Data) –...

Create HIVE table and show the way it was created and describe the structure...