This might be related to https://issues.apache.org/jira/browse/CALCITE-1054 <https://issues.apache.org/jira/browse/CALCITE-1054> or https://issues.apache.org/jira/browse/CALCITE-1075 <https://issues.apache.org/jira/browse/CALCITE-1075>. I think the problem is that Calcite uses Integer (or int) internally to represent dates, and forgets to convert java.sql.Date values coming from a custom table.
Try my patch to 1054. If might just work. Julian > On Apr 4, 2016, at 9:36 PM, Sanjay Prasad <[email protected]> wrote: > > java.lang.ClassCastException: java.sql.Date cannot be cast to > java.lang.Integer
