hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1245) allow access to values stored as non-strings in HBase
Date Tue, 01 Jun 2010 19:38:40 GMT

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

John Sichi commented on HIVE-1245:
----------------------------------

As part of this, should also test and document the existing support for serializing arrays
and structs, and also expose the control over when to use JSON vs delimited for these and
maps.

hive> CREATE TABLE complex(
   key string, 
   a array<string>, 
   s struct<col1 : int, col2 : int>)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = "cf:a, cf:s"
);
OK
hive> 
INSERT OVERWRITE TABLE complex 
SELECT bar, array('x', 'y', 'z'), struct(100, 200)
FROM pokes
WHERE foo=497;
...
OK
hive> 
SELECT * FROM complex;
OK
val_497	["x","y","z"]	{"col1":100,"col2":200}

hbase(main):003:0> scan 'complex'
ROW                          COLUMN+CELL                                                 
                    
val_497                     column= cf:s, timestamp=1275419258650, value=100\x02200      
                   
val_497                     column=cf:a, timestamp=1275419258650, value=x\x02y\x02z      
                  
1 row(s) in 1.0250 seconds


> allow access to values stored as non-strings in HBase
> -----------------------------------------------------
>
>                 Key: HIVE-1245
>                 URL: https://issues.apache.org/jira/browse/HIVE-1245
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: HBase Handler
>    Affects Versions: 0.6.0
>            Reporter: John Sichi
>            Assignee: John Sichi
>             Fix For: 0.6.0
>
>
> See  test case in
> http://mail-archives.apache.org/mod_mbox/hadoop-hive-user/201003.mbox/browser

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message