Does Presto SQL support recursive query using CTE just like SQL Server? e.g. employee hierarchy level

Question

I want to write a recursive query using CTE in Presto to find Employee Hierarchy. Do Presto support recursive query? When I write simple recursion as

with cte as(select 1 n union all select cte.n+1 from cte where n<50) select * from cte

It gives error that

Error running query: line 3:32: Table cte does not exist

Answer 1

Current answer

Recursive queries are supported in Trino, but not PrestoDB implementations of Presto.

Old answer

Presto grammar supports WITH RECURSIVE name AS ..., but recursive WITH queries are not implemented.

This is tracked as a feature request: https://github.com/trinodb/trino/issues/1122

Answer 2

WITH RECURSIVE cte(n) AS (
    SELECT 1
    UNION ALL
    SELECT n + 1 FROM cte WHERE n < 50)
SELECT * from cte

Error : Recursion depth limit exceeded (10)

adjust max_recursion_depth