For testing purposes I'm trying to create a flowgraph in SAP HANA Studio making use of data provisioning nodes.
I created a simple table like this:
What I'm trying to accomplish is deleting, for example, the row with ID=5 with a map operation.
This is what my Flowgraph looks like:
I'm using a data source node as source (with the table above in it) and a data sink (Template table) as target. Inside the map operation I'm using a SQL statement to try and delete the row with an ID of 5:
Everytime I try to activate the flowgraph I get the following error:
"Target Node cannot be empty". To my knowledge the target node is not empty in my flowgraph? Or am I doing something wrong?
Documentation and information seems to be very scarce on this subject. Can someone please help me on how to perform a delete with a map operation?
Thanks in advance and have a nice day!