Isn't limit stored in an order by clause, with potentially an empty list of fields to sort on? ________________________________ From: Vishal Kore <[email protected]> Sent: Tuesday, September 17, 2024 1:17:15 AM To: [email protected] <[email protected]> Cc: Harshit Dwivedi <[email protected]>; Dipesh Sachdev <[email protected]>; Thomas Keller <[email protected]> Subject: Questions Regarding Implementing LIMIT Clause Pushdown in Apache Calcite JDBC Driver
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
