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 <[email protected]> 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 <[email protected]> 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
