phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bahubali Jain <bahub...@gmail.com>
Subject Re: Limitation with limit?
Date Mon, 20 Jul 2015 08:31:20 GMT
Hi Maryann,
I was running into this problem only when the the two tables were big (say
few millions of rows).
I did not come across this issue when the tables were small.

Thanks,
Baahu

On Sun, Jun 21, 2015 at 3:12 AM, Maryann Xue <maryann.xue@gmail.com> wrote:

> Hi Bahubali,
>
> Thanks for reporting the issue! Could you please file a JIRA and add some
> details? I'll verify and fix it as soon as I can.
>
>
> Thanks,
> Maryann
>
> On Fri, Jun 19, 2015 at 3:53 AM, Bahubali Jain <bahubali@gmail.com> wrote:
>
>> Hi,
>> Is there any issue related to usage of limit ?
>> select table1.x1,count(table.x2) from table1
>> join
>> table2 on table1.x1 = table2.x1
>> group by x1 limit 20;
>>
>> This query always picks the first 20 rows from joined table for the group
>> by computation
>>
>> Thanks,
>> Baahu
>> --
>> Twitter:http://twitter.com/Baahu
>>
>>
>


-- 
Twitter:http://twitter.com/Baahu

Mime
View raw message