Hi,
We have something like this that we want to "translate" into Phoenix
(snippet):
RETURN QUERY WITH RECURSIVE first_level AS (
-- non-recursive term
(
SELECT a.id AS id FROM asset a
WHERE a.parent_id = p_id AND TYPE = 2
)
UNION
-- Recursive Term
SELECT a.id AS id FROM first_level fflf, asset a
WHERE a.parent_id = flf.id AND type = 2
)
Basically, let's consider we have millions of trees stored into HBase. For
any node, we want to get all the children recursively.
Is that something we can translate to Phoenix? If not, is it in the roadmap?
Thanks,
JM
