You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/12/02 01:35:11 UTC
[jira] [Commented] (PHOENIX-2475) Support timestamp and date
arithmetic
[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15034976#comment-15034976 ]
James Taylor commented on PHOENIX-2475:
---------------------------------------
Looks like an issue specific to time and timestamp types as date type seems ok. We have some tests in ClientTimeArithmeticQueryIT, but we clearly need more.
[~Dumindux] - are cycles to spare to help fix this?
> Support timestamp and date arithmetic
> -------------------------------------
>
> Key: PHOENIX-2475
> URL: https://issues.apache.org/jira/browse/PHOENIX-2475
> Project: Phoenix
> Issue Type: New Feature
> Affects Versions: 4.6.0
> Reporter: Kevin Liew
> Priority: Minor
> Labels: date, newbie, phoenix, timestamp
>
> Create a timestamp table and insert a timestamp
> {noformat}create table timestamp_table (ts timestamp primary key)upsert into timestamp_table values ('1995-05-02 01:01:01'){noformat}
> Example test case
> {noformat}select ts + 1 from timestamp_table{noformat}
> Expected result:
> The timestamp with one day added to it
> {noformat}1995-05-03 01:01:01{noformat}
> Actual result:
> the unmodified timestamp
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)