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

Posted to user@phoenix.apache.org by Thomas Grayson <tg...@bluemetal.com> on 2014/12/09 21:16:12 UTC

Retrieve the internal HBase timestamp for a row

Is there a way to return the internal HBase timestamp for a row in a Phoenix table?  An HBase column family can include a time to live (TTL).  I'd like to be able to determine how long each row in a table has to live via a Phoenix query.

Thanks,
Thomas Grayson

Re: Retrieve the internal HBase timestamp for a row

Posted by James Taylor <ja...@apache.org>.

The timestamp of a Cell is not surfaced directly in Phoenix. See
PHOENIX-914 for some related discussion. You could create a new
built-in function that would return the remaining TTL for a given row.
For a guide on how to create a new built-in function, see
http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Thanks,
James

On Tue, Dec 9, 2014 at 12:16 PM, Thomas Grayson <tg...@bluemetal.com> wrote:
> Is there a way to return the internal HBase timestamp for a row in a Phoenix
> table?  An HBase column family can include a time to live (TTL).  I’d like
> to be able to determine how long each row in a table has to live via a
> Phoenix query.
>
>
>
> Thanks,
>
> Thomas Grayson
>
>