The JDBC interface for Spark SQL does not support pushing down limits today.
On Mon, May 4, 2015 at 8:06 AM, Robin East <robin.e...@xense.co.uk> wrote: > and a further question - have you tried running this query in pqsl? what’s > the performance like there? > > On 4 May 2015, at 16:04, Robin East <robin.e...@xense.co.uk> wrote: > > What query are you running. It may be the case that your query requires > PosgreSQL to do a large amount of work before identifying the first n rows > > On 4 May 2015, at 15:52, Yi Zhang <zhangy...@yahoo.com.INVALID> wrote: > > I am trying to query PostgreSQL using LIMIT(n) to reduce memory size and > improve query performance, but I found it took long time as same as > querying not using LIMIT. It let me confused. Anybody know why? > > Thanks. > > Regards, > Yi > > > >