Apache Phoenix Current Time

Question

I am trying Apache Phoenix with Hbase. When I run try to get current time using select current_time(), its giving me some weird value. (292278994-08-17 07:12:55.807). Similarly for current_date() or now() query. I am not able to understand what does this mean, and how to get the current time (as we get from mysql now() function). Because of this I am unable to set the data type for view column as Date or Timestamp, as its doing some weird conversion.

Can anyone help me figure out a solution for this.

1. select current_date() 2. select current_time() 3. select now() All 3 give the same weird value — Ankit Agarwal, Jan 15 '16 at 16:28

kliew · Answer 1 · 2016-02-07T23:12:04.423

2

As a workaround, you can do select current_time() from any_table which will return the expected result

edited Feb 07 '16 at 23:12

answered Feb 03 '16 at 04:54

kliew

3,073
1
14
25

How to use same function `current_time()` with delete query to measure delete query execution time? – mihir6692 Apr 03 '17 at 06:12

score 0 · Answer 2 · answered Jan 21 '16 at 20:25

0

This is fixed in 4.6.1 and 4.7 version of phoenix. https://issues.apache.org/jira/browse/PHOENIX-2611

answered Jan 21 '16 at 20:25

Ankit Singhal

834
7
8

Where can I download the latest version (4.6.1 or 4.7). This page (http://www.eu.apache.org/dist/phoenix/) doesn't have the latest version. – Ankit Agarwal Jan 23 '16 at 06:32
You need to wait until 4.7 got released. It is expected to release soon. – Ankit Singhal Jan 27 '16 at 09:31

Apache Phoenix Current Time

2 Answers2