present HANA releases have no exposed capability for handling unstructured data. We are presently integrating text search/analysis capabilities, including backend capabilities and a UI component, expected with the next support package.
Hi, I was able to upload PDF files to a BLOB column in a column table in HANA db with the help from Juergen Schmerder. What you need is to create a simple script using any programming language that can establish a connection thru ODBC or JDBC, like .NET, Java, etc...Here's a sample of the script that I used to upload the files, as you can see, is quite simple...
con = dbapi.connect(‘hanahost', 30015, 'SYSTEM', '********') #Open connection to SAP HANA cur = con.cursor() #Open a cursor
file = open('doc.pdf', 'rb') #Open file in read-only and binary content = file.read() #Save the content of the file in a variable
cur.execute("INSERT INTO BLOBTEST VALUES(?,?)", (2,content)) #Save the content to a table
file.close() #Close the file cur.close() #Close the cursor con.close() #Close the connection
Now, to be able to search within the content of the files you will need to use Fuzzy Search. Here's an example of a query that looks for the word "march" in the content of the files. The score that you will get back is a TF/IDF score (Term Frequency/Inverse Document Frequency), which means that the score will be calculated based on the number of times the word "march" is found in the content of the file, the file with the most number of matches will have the highest score.
One function is that when user select the PDF file and click the upload button in the webpage, the program will upload the content of the PDF into a column of the HANA table.
I have read your blog before. Now I am trying to follow the steps described in your blog and comments.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.