How hierarchical queries are constructed in MEMSQL

[rjsv]

How hierarchical queries are constructed in MEMSQL?

[ankit.aryson]

I am also unable to find the hierarchical queries for MEMSQL. If anyone has the answer then please suggest.

Thank you.

[hanson]

Hi! Please see the answer here:

Hierarchical Queries

We don’t have a built-in feature in our SQL dialect for hierarchical queries yet. I expect us to support recursive common table expressions (CTEs) in the future. For the time being, you can use a stored procedure and do a recursive expansion in a loop. See this page for an example: