phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Recursive queries?
Date Wed, 24 Sep 2014 20:08:14 GMT
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

Mime
View raw message