You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by "alexander.scherbatiy@yandex.com" <al...@yandex.com> on 2018/03/29 08:14:15 UTC

Timestamp retreiving in Phoenix

Hello,

Link [1] describes how to set a timestamp during connection creation in Phoenix.

Is it possible to use SQL query to get the timestamp value or made some filtering?

Thanks,
Alexander.


[1] https://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API

Re: Timestamp retreiving in Phoenix

Posted by Sergey Soldatov <se...@gmail.com>.

The general answer is no. In some cases, row timestamp feature
https://phoenix.apache.org/rowtimestamp.html may be useful. But still, you
should have timestamp column in your table DDL in that case.

Thanks,
Sergey

On Thu, Mar 29, 2018 at 1:14 AM, alexander.scherbatiy@yandex.com <
alexander.scherbatiy@yandex.com> wrote:

> Hello,
>
> Link [1] describes how to set a timestamp during connection creation in
> Phoenix.
>
> Is it possible to use SQL query to get the timestamp value or made some
> filtering?
>
> Thanks,
> Alexander.
>
>
> [1] https://phoenix.apache.org/faq.html#Can_phoenix_work_on_
> tables_with_arbitrary_timestamp_as_flexible_as_HBase_API
>
>