calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hongbin ma <mahong...@apache.org>
Subject how to get EXTRACT function working in CSVTest
Date Wed, 08 Feb 2017 07:02:39 GMT
hi experts,

According to this doc https://calcite.apache.org/docs/reference.html the
EXTRACT function should work in Calcite. So I'm trying a query with EXTRACT
in CSVTest:

@Test public void testSelectx() throws SQLException {
  checkSql("model", "select extract(year from JOINEDAT) from EMPS ");
}

the query failed due to:

java.lang.ClassCastException: java.sql.Date cannot be cast to
java.lang.Integer

I also tried to change column JOINDAT's type to timestamp and datetime, but
end up with similar exceptions.

Can you please help here? thx


-- 
Regards,

*Bin Mahone | 马洪宾*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message