calcite-dev mailing list archives

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

According to this doc 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

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


*Bin Mahone | 马洪宾*

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