You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Dan Markhasin <mi...@gmail.com> on 2016/09/26 08:06:24 UTC

LIMIT pushdown to JDBC

Hi,

I'm trying to use Drill to query a JDBC source (SQL Server, with
Microsoft's JDBC driver), and I noticed that it doesn't push down the LIMIT
clause, making it *extremely* infefficient to the point it is practically
unusable for querying large tables.

My query is select * from <table> limit 1;
But in the query profile (and in the DB) I see that it is running the query
without the limit clause.

Is there any way to force it to use the clause?

Thanks,
Dan