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 Re: Subqueries: Missing "LPAREN"
Date Thu, 25 Sep 2014 15:49:24 GMT
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 <maryann.xue@gmail.com>:

> 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