Support for Recursive CTE
It would be great if you can add support for recursive CTEs for computing hierarchical data
Sahana
shared this idea
10 comments
-
Nitin Sharma
commented
this is really big issue for traversing and flattening ragged parent-child hierarchy (with no fixed level) in Synapse.
-
ARP
commented
Of course - it is a no-brainer.
-
Singhal, Himanshu
commented
it's a showstopper
-
JJ
commented
another BIG limitation or even show stopper if you want to migrate to synapse, please add this essential functionaliity we are used to from sql since many years
-
Ali Shashaani
commented
Our need is to traverse complex, unpredictable JSON objects and pull out all elements, not matter how deeply nested they are, into a table of key-value pairs. A recursive CTE with cross application of OPENJSON table-valued function would elegantly take care of this. Pretty, please.
-
Krunal G
commented
Work around we used that we get extreme child data or most parent data and run a While loop to get desired output, then we dump the output in Table so as to use in other query/ result set.
-
Vinodh Ramasubramanian
commented
Could you provide an update on this request ?
-
Chris Thompson
commented
wasn't this "completed" a moment ago??
-
Edward
commented
Without recursion we will have to process some of our data outside of Azure DW, which sort of defeats the purpose. Please consider adding this feature!
-
Chris Thompson
commented
hmm.. i really could do with this for large parent child issues!