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