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/07/28 21:41:41 UTC
[jira] [Commented] (PHOENIX-788) Support cast from/to
DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG
[ https://issues.apache.org/jira/browse/PHOENIX-788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14076677#comment-14076677 ]
Hudson commented on PHOENIX-788:
--------------------------------
SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #160 (See [https://builds.apache.org/job/Phoenix-3.0-hadoop1/160/])
PHOENIX-788 Support cast from/to DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG (jtaylor: rev 9c85887af4d48a7bac45171ddd2a33fbd310a440)
* phoenix-core/src/test/java/org/apache/phoenix/expression/RoundFloorCeilExpressionsUnitTests.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/BaseQueryIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ClientTimeArithmeticQueryIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ScanQueryIT.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/FloorParseNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/CastParseNode.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/CeilParseNode.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/GroupByIT.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/RoundDecimalExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/parse/RoundParseNode.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/CastAndCoerceIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/NotQueryIT.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/FloorDecimalExpression.java
* phoenix-core/src/main/java/org/apache/phoenix/expression/function/CeilDecimalExpression.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/CaseStatementIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/QueryIT.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/PDataType.java
> Support cast from/to DATE/TIME/TIMESTAMP to/from LONG/UNSIGNED_LONG
> -------------------------------------------------------------------
>
> Key: PHOENIX-788
> URL: https://issues.apache.org/jira/browse/PHOENIX-788
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0-Release
> Reporter: James Taylor
> Assignee: James Taylor
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
>
> We should support a manual cast between LONG and DATE/TIME/TIMESTAMP, for example:
> SELECT CAST(epoch_value AS DATE) FROM t;
> SELECT CAST(date AS BIGINT) FROM t;
> Requested by Tagged on the mailing list.
--
This message was sent by Atlassian JIRA
(v6.2#6252)