drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Markhasin <minimi...@gmail.com>
Subject LIMIT pushdown to JDBC
Date Mon, 26 Sep 2016 08:06:24 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message