Hive: Concatenate two tables

Hi all,

I'm trying to set up a way to concatenate two tables using Hive Connector and database nodes. By concatenating I mean the same functionality as the 'Concatenate' node does normally in KNIME, so essentially a union. 

I have this working normally when I'm reading the data from SAP HANA, but it doesn't seem to work with Hive Connector from Hadoop. I have attached the example workflow.

Any suggestions on how to fix this? 

Hi Jaako,

I once made a metanode for this, you can find it here:

Cheers, Iris  

1 Like