Connect by / hierarchical quieries


Hi *,

I am knew to mapd, and would like to know if there is any support for hierarchical queries, e.g. using CONNECT BY … PRIOR?




@jhb welcome to the MapD experience! I hope you’re enjoying it.

Unfortunately, we don’t have support recursive CTEs. If you decide to try and build your own additional functionality, we would love to hear the results.


Any chance --enable-loop-joins flag with a self join would do the trick?
Looks like WITH…AS syntax is supported as per DML documentation.