phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@salesforce.com>
Subject Re: Phoenix view over existing HBase table - timestamps
Date Mon, 02 Nov 2015 21:36:26 GMT
Camelia

You can specify the “CurrentSCN” attribute to get values < timestamp.
See http://phoenix.apache.org/faq.html#Can_phoenix_work_on_tables_with_arbitrary_timestamp_as_flexible_as_HBase_API

-Thomas

On Sun, Nov 1, 2015 at 5:00 AM, Camelia Elena Ciolac
<camelia@chalmers.se> wrote:
> Hello,
>
> I created successfully a view over an existing HBase table, but I'd like to
> be able to have in it  the versioned cells as in the HBase table.
> Now, if I issue the command:
>
> CREATE VIEW "table_HBase" (pk VARCHAR PRIMARY
> KEY,"colfamily"."coldescriptor" VARCHAR);
>
> it's normal that I can't answer the query:
>
> SELECT "coldescriptor"  FROM "table_HBase" where "timestamp" < 1445934281566
> LIMIT 10;
>
> because timestamp column is not part of the view (Error: ERROR 504 (42703):
> Undefined column. columnName=timestamp (state=42703,code=504)), but it is
> part of the HBase table.
>
>
> So what would be the workaround to accessing versioned cells from a HBase
> table using Phoenix?
>
> Thanks and best regards!
> C.

Mime
View raw message