[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173481#comment-14173481 ] Lefty Leverenz commented on HIVE-2828: -- Doc note: This should be documented in the HBase Integration wikidoc, with version information, and a release note would be nice. * [HBase Integration | https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration] > 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 > Labels: TODOC15 > Fix For: 0.15.0 > > Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt, HIVE-2828.9.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173468#comment-14173468 ] Navis commented on HIVE-2828: - My bad. Some codes not in the patch is included by mistake, failing hbase_custom_key* tests. I'll merge patch for that with HIVE-8465. > 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 > Fix For: 0.15.0 > > Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt, HIVE-2828.9.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14173143#comment-14173143 ] Hive QA commented on HIVE-2828: --- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12674889/HIVE-2828.9.patch.txt {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 6559 tests executed *Failed tests:* {noformat} org.apache.hive.beeline.TestSchemaTool.testSchemaInit org.apache.hive.beeline.TestSchemaTool.testSchemaUpgrade {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1280/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1280/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-1280/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12674889 > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt, HIVE-2828.9.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14171887#comment-14171887 ] Navis commented on HIVE-2828: - Addressed comment. Rerunning test. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt, HIVE-2828.9.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14170937#comment-14170937 ] Swarnim Kulkarni commented on HIVE-2828: Thanks [~navis]. The patch looks great to me. Left a minor question on the review. +1 otherwise. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14170574#comment-14170574 ] Navis commented on HIVE-2828: - [~ndimiduk] It would be handled in HIVE-8267. (see https://issues.apache.org/jira/browse/HIVE-8267?focusedCommentId=14154347&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14154347) [~swarnim] Cannot find your comments in phabricator and the patch in it would have gone stale. Could you use RB (https://reviews.apache.org/r/25238/)? > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14167775#comment-14167775 ] Phabricator commented on HIVE-2828: --- ndimiduk added a subscriber: ndimiduk. ndimiduk accepted this revision. ndimiduk added a reviewer: ndimiduk. ndimiduk added a comment. This revision is now accepted and ready to land. +1 BRANCH DPAL-861 INLINE COMMENTS hbase-handler/src/java/org/apache/hadoop/hive/hbase/LazyHBaseRow.java:154 This is as good a decision as any. Maybe down the road someone will want to specify which cell's timestamp maps to which column? REVISION DETAIL https://reviews.facebook.net/D1989 To: navis, JIRA, ndimiduk Cc: ndimiduk > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14167773#comment-14167773 ] Nick Dimiduk commented on HIVE-2828: Left a comment on phabricator. +1 > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14166239#comment-14166239 ] Swarnim Kulkarni commented on HIVE-2828: Left comments on the phabricator review. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14165122#comment-14165122 ] Swarnim Kulkarni commented on HIVE-2828: Sure. I will take a look at it today. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164881#comment-14164881 ] Muhammad Ehsan ul Haque commented on HIVE-2828: --- [~sushanth], [~brocknoland], [~swarnim], [~serega_sheypak] Also, HIVE-8267 is the sequel feature request, with the ability to make timestamp of any cell available. So could you guys also look into that? > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164125#comment-14164125 ] Sergey commented on HIVE-2828: -- Ok,thanks! > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164122#comment-14164122 ] Brock Noland commented on HIVE-2828: [~swarnim] has worked on the hbase serde lately. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164108#comment-14164108 ] Sergey commented on HIVE-2828: -- Can you give a github link where to look at? > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164106#comment-14164106 ] Sushanth Sowmyan commented on HIVE-2828: Sorry, I've been swamped the last couple of days, and expect to be so for the next couple of days - this weekend is going to be the earliest I can look at it. I think [~brocknoland] and [~ndimiduk] also potentially have some context, so tagging them if they want to look at this before I do so. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14160981#comment-14160981 ] Sushanth Sowmyan commented on HIVE-2828: Sure, I'll try to look into this tonight. > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14159791#comment-14159791 ] Navis commented on HIVE-2828: - [~sushanth] I think there are some requests on this. Could you review this if time allows? > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14155061#comment-14155061 ] Hive QA commented on HIVE-2828: --- {color:green}Overall{color}: +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12672261/HIVE-2828.8.patch.txt {color:green}SUCCESS:{color} +1 6488 tests passed Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1072/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/1072/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-1072/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12672261 > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt, HIVE-2828.8.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14118041#comment-14118041 ] Hive QA commented on HIVE-2828: --- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12665849/HIVE-2828.7.patch.txt {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 6135 tests executed *Failed tests:* {noformat} org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.testImpersonation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/598/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/598/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-598/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12665849 > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt, > HIVE-2828.7.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14117904#comment-14117904 ] Hive QA commented on HIVE-2828: --- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12665836/HIVE-2828.6.patch.txt {color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 6134 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.hbase.TestLazyHBaseObject.testLazyHBaseRow1 org.apache.hadoop.hive.hbase.TestLazyHBaseObject.testLazyHBaseRow2 org.apache.hadoop.hive.hbase.TestLazyHBaseObject.testLazyHBaseRow3 org.apache.hive.service.TestHS2ImpersonationWithRemoteMS.testImpersonation {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/595/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/595/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-595/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 4 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12665836 > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.patch, HIVE-2828.6.patch.txt > > > 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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14117159#comment-14117159 ] Muhammad Ehsan ul Haque commented on HIVE-2828: --- What is the status of this ticket? Can someone tell me if this is going to be pushed? or any reason why its not pushed? This is a good feature and we have come to a couple of situations where this support is good to have. The current patch might not be applicable to the current version Hive 0.13, but I can work on it (in-fact I have a patch available with the current trunk but slightly different implementation). > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.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 was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13556862#comment-13556862 ] John Shields commented on HIVE-2828: What is the right process for applying these patches? Also, on which SVN paths would it be applicable? Obviously the code has changed since these were created so I'm trying to figure out how to apply them. We currently have a version of 0.8.0 that would be great to apply these patches against. I tried against branches/0.8.0 to no avail. Thanks! John > 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: ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.1.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.2.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.3.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.4.patch, > ASF.LICENSE.NOT.GRANTED--HIVE-2828.D1989.5.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 For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423554#comment-13423554 ] Navis commented on HIVE-2828: - If what you meant was is it possible to 'group by timestamp', it's possible. > 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, HIVE-2828.D1989.2.patch, > HIVE-2828.D1989.3.patch, HIVE-2828.D1989.4.patch, HIVE-2828.D1989.5.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
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423347#comment-13423347 ] Hans Uhlig commented on HIVE-2828: -- Would this allow aggregation across timestamps as well? > 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, HIVE-2828.D1989.2.patch, > HIVE-2828.D1989.3.patch, HIVE-2828.D1989.4.patch, HIVE-2828.D1989.5.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
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ https://issues.apache.org/jira/browse/HIVE-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13217894#comment-13217894 ] Navis commented on HIVE-2828: - No and no as far as I know, but might be implemented by modifying HiveHBaseTableInputFormat and HBaseStorageHandler. > 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
[jira] [Commented] (HIVE-2828) make timestamp accessible in the hbase KeyValue
[ 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