on 03-16-2012 12:43 PM
Hi,
I have a use case where I have data stored as XML data type (BLOB) in a HANA table and we want to search specific nodes for specific values. One sample XML value would be
<?xml version="1.0" encoding="utf-8" ?>
<DocumentAttributes>
<LetterID>473</LetterID>
<DescriptionTexts>
<DescriptionText1>
<VersionNumber>493</VersionNumber>
<VersionDate>20120220</VersionDate>
<VersionTime>185412</VersionTime>
<User>ABC</User>
<LetterID>483</LetterID>
</DescriptionText1>
</DescriptionTexts>
</DocumentAttributes>
For example in SQL Server I'm able to use the following query to find out the desired result:
select * from dbo.XML_DATEN where XML_Data.value('(/DocumentAttributes/LetterID)[1]', 'int') = 473
In this example the query returns me all rows where under the node DocumentAttributes the LetterID is set to 473.
Is something similar also possible with HANA either over CE Functions or SQL Script? I searched the SQL reference without any success.
Thanks and Regards,
Daniel
Hello Daniel,
although SAP HANA can certainly store XML data (in a string or BLOB fields), the current release 1.0 SPS 3 does not support specific XML syntax or xPath expressions in SQL selects. I'm sure that we will add this functionality in a future release.
Regards,
Marc
SAP Customer Solution Adoption (CSA)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
we need this ability, too.
Looking forward to a workaround till it gets implemented. Or is it implemented now?
Best regards,
Manuel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot for the answer, Marc. We will see whether we can use workarrounds until the funcitionality is impletemended - however this is tricky because the relevant string might be under different nodes and not all of them are relevant. We will see...
Thank you!
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.