Skip to Content
0
Former Member
May 12, 2016 at 08:05 AM

SAP HANA Flowgraphs map operation delete rows

484 Views

Hi everybody,

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!

Kind Regards,

Simon