Hi Maryann, We have already spotted PHOENIX-1168 and tracking it ;) Thanks for the patch!
We have already downloaded it and will give it a try. JM 2014-09-24 15:39 GMT-04:00 Maryann Xue <[email protected]>: > Hi JM, > > Think this sub-query feature is covered by PHOENIX-1168, for which a > check-in is expected very soon. > > > Thanks, > Maryann > > On Wed, Sep 24, 2014 at 9:06 AM, Jean-Marc Spaggiari < > [email protected]> wrote: > >> Hi, >> >> Is it possible to run sub-queries with Phoenix? Something like this: >> >> select * from "metadata" n where L = 1 AND R = (select max(R) from >> "metadata" z where n.A = z.A); >> >> Goel is to get all lignes where L=1 and R=max. Field "A" is the key. >> >> Thanks, >> >> JM >> > > > > -- > Thanks, > Maryann >
