Athena recursive cte NOT_SUPPORTED: Recursion depth limit exceeded (10). Use 'max_recursion_depth'

0

Hi, Trying to use a recursive cte with Athena and I get this error :

NOT_SUPPORTED: Recursion depth limit exceeded (10). Use 'max_recursion_depth' session property to modify the limit.

How would I set this session property from the console ? Thanks!

asked a year ago1188 views
2 Answers
0

Using the WITH clause to create recursive queries is not supported.

https://docs.aws.amazon.com/athena/latest/ug/select.html#select-parameters

Please share your SQL if you are not using WITH clause.

profile pictureAWS
answered a year ago
0

Athena engine v3 supports recursive query per the doc link above.

Using the WITH clause to create recursive queries is supported starting in Athena engine version 3. The maximum recursion depth is 10.

I too would like to know how to set the the limit in the console. Is there a hard limit?

AWS
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions