我无法将嵌套的json数据加载到配置单元表中。有人能帮我吗？下面是我尝试过的：
样本输入：

{"DocId":"ABC","User1":{"Id":1234,"Username":"sam1234","Name":"Sam","ShippingAddress":{"Address1":"123 Main St.","Address2":null,"City":"Durham","State":"NC"},"Orders":[{"ItemId":6789,"OrderDate":"11/11/2012"},{"ItemId":4352,"OrderDate":"12/12/2012"}]}}

在Hive（cdh3）上：

ADD JAR /usr/lib/hive/lib/hive-serdes-1.0-SNAPSHOT.jar;
CREATE TABLE json_tab(
    DocId string,
    user1 struct<Id: int, Username: string, Name:string,ShippingAddress:struct<address1:string,address2:string,city:string,state:string>,orders:array<struct<ItemId:int,orderdate:string>>>
)
ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe'
STORED AS TEXTFILE;  
hive> select * from json_tab;
OK
NULL    null

我要走了 NULL 他在这儿。
还尝试了hcatalog jar：

ADD JAR /home/training/Desktop/hcatalog-core-0.11.0.jar;
 CREATE TABLE json_tab(
    DocId string,
    user1 struct<Id: int, Username: string, Name:string,ShippingAddress:struct<address1:string,address2:string,city:string,state:string>,orders:array<struct<ItemId:int,orderdate:string>>>
)
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe';

但面对我的错误 create table 声明：
失败：元数据错误：无法验证serde:org.apache.hive.hcatalog.data.jsonserde失败：执行错误，从org.apache.hadoop.hive.ql.exec.ddltask返回代码1
有人能帮我吗？提前谢谢你的帮助。