Hi Devs,
I am currently working on implementing (or extending) a JDBC driver for my backend storage system using Apache Calcite. I've implemented the FilterableTable interface, which allows pushing down WHERE clause filters to the backend using the scan(DataContext ctx, List<RexNode> filters) method. However, I'm struggling to push down the LIMIT clause to ensure that only the required number of records are retrieved from the backend. I cannot figure out how to access the LIMIT clause within the scan method. Could you please guide me on how to retrieve or implement the LIMIT clause in this context? Thanks for your assistance! Best regards, Vishal Kore
