Database Writer Node in Hive

KNIME Analytics Platform
1

Has anyone ever used the database writer node for creating a table in Hive?

Whenever I try to use it I get the error message saying “selected database does not support insert operations”

I can create tables and insert data via an SQL editor, so I know the error message can’t be true.

Any help would be appreciated

2

With Hive I think there are these possibilities to get data there from KNIME

  • The Hive Loader. Be careful with dropping existing table or appendix to it
  • or you upload a CSV file and create an external table *1)

For an already existing connection you could use the
Database Connection Table Writer. But the result would have to come in via Database connections. I do not think it is possible to use the ‘normal’ Database writer.

*1)

1 Like
3

Thank you. I will the Hive loader option.

1 Like