Hi, Drill does not push the LIMIT queries to external databases and I assume it could be more related to Calcite. This leads to out of memory situations while querying large table to view few records. Is there something that could be improved here? One solutions would be to push filters down to the DB and/or combined with some JDBC batch size limit to flush a part as parquet.
Regards, Rahul -- _*** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you are not the named addressee then you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and delete this e-mail from your system.***_
