phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2475) Date arithmetic broken for time and timestamp
Date Fri, 25 Dec 2015 17:26:49 GMT

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

James Taylor commented on PHOENIX-2475:
---------------------------------------

Don't use {{rs.getTimestamp(1).toString()}}, but instead use rs.getTimestamp(1).getTime()
and ensure that the millisecond value was increased by one. Otherwise, yes, adding one day
to a Time gets you the same time in the next day. However, Phoenix stores the entire date,
not just the time part, so you should see the millisecond value increase (which is non standard,
but that's the way it works).

> Date arithmetic broken for time and timestamp
> ---------------------------------------------
>
>                 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
>            Assignee: ramkrishna.s.vasudevan
>            Priority: Minor
>              Labels: date, newbie, phoenix, timestamp
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2475_1_master.patch, PHOENIX-2475_master.patch
>
>
> 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)

Mime
View raw message