[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue

["Anoop Sam John (Commented) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13217873#comment-13217873 ] 

Anoop Sam John commented on HIVE-2828:
--------------------------------------

Does HBase integration in Hive allows retrieval of multiple versions ( diff time stamp ) of the same cell?
Also whether allows specifying the time range while select such that the cell value versions within this time range will be retrieved?
                
> make timestamp accessible in the hbase KeyValue 
> ------------------------------------------------
>
>                 Key: HIVE-2828
>                 URL: https://issues.apache.org/jira/browse/HIVE-2828
>             Project: Hive
>          Issue Type: Improvement
>          Components: HBase Handler
>            Reporter: Navis
>            Assignee: Navis
>            Priority: Trivial
>         Attachments: HIVE-2828.D1989.1.patch
>
>
> Originated from HIVE-2781 and not accepted, but I think this could be helpful to someone.
> By using special column notation ':timestamp' in HBASE_COLUMNS_MAPPING, user might access timestamp value in hbase KeyValue.
> {code}
> CREATE TABLE hbase_table (key int, value string, time timestamp)
>   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
>   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira