I tried to use the streaming functionality to SELECT from a table on one side and write to another table. I applied the things learned in Issue 1552 and then switched to HANA. I knew I had some errors in the HANA views which allowed me to test the error handling.
The problem I encountered was that the HANA errors seem to throw beyond the standard try catch mechanism and in a lot of cases take down the whole server. I switched back to insert... from select for the moment without the stream but I have future cases where I want to use a streaming approach.
I don't know if we consider this a bug or a feature improvement but certainly want to caution you that the current implementation works well, if it is working, but seems uncontrollable if it runs into an error.
I tried to use the streaming functionality to SELECT from a table on one side and write to another table. I applied the things learned in Issue 1552 and then switched to HANA. I knew I had some errors in the HANA views which allowed me to test the error handling.
The problem I encountered was that the HANA errors seem to throw beyond the standard try catch mechanism and in a lot of cases take down the whole server. I switched back to insert... from select for the moment without the stream but I have future cases where I want to use a streaming approach.
I don't know if we consider this a bug or a feature improvement but certainly want to caution you that the current implementation works well, if it is working, but seems uncontrollable if it runs into an error.