You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by CPC <ac...@gmail.com> on 2015/10/27 17:21:37 UTC

timestamp gt operator

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

Re: timestamp gt operator

Posted by Julian Hyde <jh...@apache.org>.
This is a bug. Can you please log a jira case?

Julian


> On Oct 27, 2015, at 9:21 AM, CPC <ac...@gmail.com> 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