You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2018/07/19 00:58:00 UTC

[jira] [Commented] (CALCITE-2420) Aggregate functions MIN/MAX does not work for Timestamp

    [ https://issues.apache.org/jira/browse/CALCITE-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16548631#comment-16548631 ] 

Julian Hyde commented on CALCITE-2420:
--------------------------------------

I see that you are trying to use the Java class java.sql.Timestamp. Calcite represents SQL {{TIMESTAMP}} values as primitive {{long}} values (or {{java.lang.Long}} instances if nullable), but does not use {{java.sql.Timestamp}} internally. Try {{createSqlType(TIMESTAMP)}} rather than {{createJavaType(Timestamp.class)}}.

> Aggregate functions MIN/MAX does not work for Timestamp
> -------------------------------------------------------
>
>                 Key: CALCITE-2420
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2420
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.17.0
>            Reporter: Piotr Bojko
>            Assignee: Julian Hyde
>            Priority: Major
>
> See https://github.com/ptrbojko/calcite/tree/CALCITE-2420 for reproduction.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)