Hive: Concatenate two tables

KNIME Analytics Platform
1

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? 

2

Hi Jaako,

I once made a metanode for this, you can find it here: https://tech.knime.org/forum/knime-general/database-concatenate-node

Cheers, Iris  

1 Like