phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Istvan Toth <st...@apache.org>
Subject Re: timestamp and pre-existing HBase tables
Date Thu, 19 Mar 2020 06:06:11 GMT
Hi!

Look into PHOENIX-5629 <https://issues.apache.org/jira/browse/PHOENIX-5629>
 .
Note that is not available in any released version yet.

Istvan

On Wed, Mar 18, 2020 at 10:26 PM anil gupta <anilgupta84@gmail.com> wrote:

> 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