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.
