3703705 - How to implement the recursive query in HANA 2.0 ?

• A recursive query can be implemented as below in ORACLE, and it needs to be implemented in HANA database.
  • WITH RECURSIVE test(n) AS (
    SELECT 1
    FROM DUMMY
    UNION ALL
    SELECT n + 1
    FROM test
    WHERE n < 10
    )
    SELECT n AS A FROM test;
    
    
• The result of this query would be like below.
  
  
  

  Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP HANA, Platform Edition 2.0

HANA, recursive, recursive query, recursive sql , KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem