Skip to Content
0

How to traverse hierarchical data in SAP HANA

Dec 19, 2016 at 02:04 PM

22

avatar image

Hello,

We are storing hierarchical data in a table called ENTITY(ENTITY_ID, ENTITY_NAME, PARENT_ENTITY_ID). In SQL server, we are using the recursive CTE to select all the childs/parents records. Refer the attachment 'Entity Table'. entity-table.png. However this is not supported in SAP HANA.

Could you please let me know the equivalent for this?

Also, Is there any better way to traverse the hierarchy in SAP HANA?

Thanks

entity-table.png (5.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers