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
