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
jean-m...@spaggiari.org 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 maryann@gmail.com:
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
jean-m...@spaggiari.org 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