drill-user mailing list archives

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