Re: Help with LIMIT clause

200K + records. > > Any help will be appreciated. > > Thanks, > Sumit > > -- > *From:* Sumit Nigam <sumit_o...@yahoo.com> > *To:* Users Mail List Phoenix <user@phoenix.apache.org> > *Sent:* Thursday, December 10, 2015 8:05 PM &

Re: Help with LIMIT clause

m');>> > *To:* Users Mail List Phoenix <user@phoenix.apache.org > <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>> > *Sent:* Thursday, December 10, 2015 8:05 PM > *Subject:* Help with LIMIT clause > > Hi, > > The link for salted tables http

Re: Help with LIMIT clause

org> To: user <user@phoenix.apache.org>; Sumit Nigam <sumit_o...@yahoo.com> Sent: Thursday, December 10, 2015 11:34 PM Subject: Re: Help with LIMIT clause Hi Sumit,I agree, these two queries should return the same result, as long as you have the ORDER BY clause. What version

Help with LIMIT clause

Hi, The link for salted tables https://phoenix.apache.org/salted.html mentions "Since salting table would not store the data sequentially, a strict sequential scan would not return all the data in the natural sorted fashion. Clauses that currently would force a sequential scan, for example,