phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: timestamp and pre-existing HBase tables
Date Wed, 18 Mar 2020 21:26:04 GMT
AFAIK, Phoenix cannot surface the cell level timestamps that hbase stores
for each cell. Row Timestamp in Phoenix not equivalent to hbase cell
timestamp. RowTimestamp is nothing but a numerical/date column being part
of composite Primary key of table that stores time component and allows
phoenix to do some filter optimizations.
However, we have written a udf to grab cell timestamp with Phoenix at my
current workplace. So, its doable with custom udf.

On Wed, Mar 18, 2020 at 8:23 AM Kupersanin, William <kupersanin@mitre.org>
wrote:

> Hello,
>
>
>
> I’m new to HBase/Phoenix and trying to reconcile the guidance for making a
> Phoenix view for a preexisting table in HBase (found in the FAQ), and the
> guidance for being able to search versions using the built-in HBase
> timestamp ( https://phoenix.apache.org/rowtimestamp.html)
>
>
>
> I can create a view in Phoenix where I can see my pre-existing data as
> follows.
>
> CREATE view   "dev_host_ip" (pk VARCHAR PRIMARY KEY, "f1"."ip" VARCHAR);
>
>
>
> If I create a table instead of a view, I can not access my data via
> Phoenix.
>
>
>
> However, if I try to add a timestamp with view, I get an error “Declaring
> a column as row_timestamp is not allowed for views"
>
>
>
> So is there a way to take advantage of built-in timestamps on preexisting
> HBase tables? If so, could someone please point me in the right direction?
>
>
>
> Thanks!
>
> --Willie
>
>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message