Also, there's a new 4.6.0 feature available to declare a column in your primary key as mapping to the Cell timestamp: https://phoenix.apache.org/rowtimestamp.html
Thanks, James On Mon, Nov 2, 2015 at 1:36 PM, Thomas D'Silva <[email protected]> wrote: > 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 > <[email protected]> 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. >
