phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Subqueries: Missing "LPAREN"
Date Thu, 25 Sep 2014 15:44:26 GMT
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-marc@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.xue@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-marc@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

Mime
View raw message