Hello Hana Experts,
Is it possible to achieve below scenario in SAP Hana?
Scenario: We are able to insert the .csv file(data size is huge) into SAP HANA with column type : BLOB is successful as shown in below image:
After this we want to read the content of the .csv and split the data into smaller parts with help of delimiter(like , or / etc) or other conditions and put the data into another table and display as column based on the result.
1. How to read the content of the BLOB data which is unknown. Is it achieve by writing the SQL procedure language or any other techniques.
2. Please suggest us the better solutions how we can achieve such scenario in SAP HANA.