Connect by / hierarchical quieries


#1

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?

Thanks,

Joerg


#2

@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.


#3

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.