This is a bug. Can you please log a jira case? Julian
> On Oct 27, 2015, at 9:21 AM, CPC <[email protected]> wrote: > > Hi guys, > > I wrote simple program to learn calcite. I am using csv schema. But when i > run that query > > "select * from TEST.timeseries where tarih > ? and tarih < ? " > > where tarih column has type timestamp from csv like > > tarih:timestamp,sensor:string,temp:int > 2015-10-26 10:51:36,sensor67,88 > 2015-10-26 10:51:36,sensor89,96 > 2015-10-26 10:51:36,sensor91,88 > 2015-10-26 10:51:36,sensor35,80 > 2015-10-26 10:51:36,sensor37,84 > 2015-10-26 10:51:36,sensor15,96 > > it throws > > Caused by: java.lang.NoSuchMethodException: > org.apache.calcite.runtime.SqlFunctions.gt(java.sql.Timestamp, > java.sql.Timestamp) > at java.lang.Class.getMethod(Class.java:1773) > at org.apache.calcite.linq4j.tree.Types.lookupMethod(Types.java:337) > > Seems like gt function does not support Timestamps. I am using > 1.4.0-incubating by the way
