Thanks for the update Maryann. Subscribed to PHOENIX-945 too. Will wait to hear back from you.
JM 2014-09-25 11:44 GMT-04:00 Maryann Xue <[email protected]>: > Hi JM, > > Sorry that I made a mistake earlier. Your query should be covered by > https://issues.apache.org/jira/browse/PHOENIX-945. Will keep you updated > on the progress of that issue. > > > Thanks, > Maryann > > > On Wed, Sep 24, 2014 at 3:41 PM, Jean-Marc Spaggiari < > [email protected]> wrote: > >> 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 >>> >> >> > > > -- > Thanks, > Maryann >
