You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/03/05 05:21:44 UTC
[jira] [Commented] (PHOENIX-3) TRUNC method doesn't work on column
of datatype timestamp
[ https://issues.apache.org/jira/browse/PHOENIX-3?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13920474#comment-13920474 ]
Hudson commented on PHOENIX-3:
------------------------------
SUCCESS: Integrated in Apache Phoenix - Branch:master #109 (See [https://builds.apache.org/job/Phoenix/109/])
Add test case for PHOENIX-3 TRUNC method doesn't work on column of datatype timestamp (maryannxue: rev b36daea7f6408cf249a25663803f9ed1b8db608c)
* phoenix-core/src/test/java/org/apache/phoenix/end2end/TruncateFunctionTest.java
> TRUNC method doesn't work on column of datatype timestamp
> ---------------------------------------------------------
>
> Key: PHOENIX-3
> URL: https://issues.apache.org/jira/browse/PHOENIX-3
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 2.2.3
> Reporter: Harshit Bapna
>
> On executing, select TRUNC(DATELOGGED, 'second', 30) from A, following error is observed :
> Type mismatch. expected: [TIME] but was: TIMESTAMP at TRUNC argument.
> The datatype of DATELOGGED column is timestamp.
> According to the doc at http://phoenix.incubator.apache.org/language/functions.html#/truncate
> It should ideally work on timestamp and date datatypes
--
This message was sent by Atlassian JIRA
(v6.2#6252)