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

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.

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?