Question about DB Connection Table Writer

[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 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...