You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Mark Thomas (JIRA)" <ji...@apache.org> on 2015/10/12 09:58:05 UTC
[jira] [Updated] (PHOENIX-590) Provide multiple versions support in
external HBase tables
[ https://issues.apache.org/jira/browse/PHOENIX-590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Thomas updated PHOENIX-590:
--------------------------------
Priority: Blocker
Reporter: Vladimir Rodionov (was: VladRodionov)
> Provide multiple versions support in external HBase tables
> ----------------------------------------------------------
>
> Key: PHOENIX-590
> URL: https://issues.apache.org/jira/browse/PHOENIX-590
> Project: Phoenix
> Issue Type: Task
> Reporter: Vladimir Rodionov
> Priority: Blocker
> Attachments: PHOENIX-590_3_0.patch
>
>
> This was from user group mailing list:
> I have a table, which has MAX_VERSIONS > 1. Is it possible in Phoenix to get all the versions of a particular cell?
> Example (HBase table):
> rowkey:cf:col:ts1 -> value1
> rowkey:cf:col:ts2 -> value2
> rowkey:cf:col:ts3 -> value2
> I want to get all values for: rowkey:cf:col?
> Its a mapping:
> rowkey -> ID
> cf:col -> PROFILE
> I want execute:
> select PROFILE from TABLE where ID= x and get all 3 profiles
> James response:
> That'd be a good contribution. The simplest way I can see that done would be:
> - support a new MAX_VERSIONS connection property where you can specify how many version of a row you want to get back. In the PhoenixConnection constructor, you'd grab this in the same way we do for CURRENT_SCN and store it in a member variable. Then from BasicQueryPlan.newScanner, you'd set scan.setMaxVersions(<n>) just like we're setting scan.setTimeRange().
> - add a built-in function like ROW_TIME() that returns the DATE of the first KeyValue in the Tuple (see my blog here for an example on how to add a new built-in function). Slightly fancier would be ROW_TIME(<column reference>) that would return the DATE representing the timestamp of the KeyValue in Tuple representing the <column reference> passed in.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)