解决：org.codehaus.jackson.JsonParseException:Unexpected end-of-input: expected close marker for OBJEC

解决：org.codehaus.jackson.JsonParseException:Unexpected end-of-input: expected close marker for OBJECT

今天将json文件导到Hive表中，出现 org.codehaus.jackson.JsonParseException:Unexpected end-of-input: expected close marker for OBJECT错误，不能解析json文件。

创建Hive表使用row format serde 'org.apache.hadoop.hive.serde2.JsonSerDe'来解析json文件。

表如下：

create external table json_learn
(
    name string comment'名字',
    friends array<string> comment'朋友',
    students map<string,int> comment'学生信息',
    address struct<street:string,city:string,postal_code:int>
) comment'老师信息'
row format serde 'org.apache.hadoop.hive.serde2.JsonSerDe'
;

数据如下：

{
    "name": "xiaozhang",
    "friends": [
        "bingbing"
    ],
    "students": {
        "haihai": 18,
        "yangyang": 16
    },
    "address": {
        "street": "hui long guan",
        "city": "beijing",
        "postal_code": 10010
    }
}

错误原因：json sered不能解析格式化的json文件，需要保障每一行json字符串数据处于一行中。row format也是每次序列化一行数据

解决办法：将json字符串放一行即可

{"name":"dasongsong","friends":["bingbing","lili"],"students":{"xiaohaihai":18,"xiaoyangyang":16},"address":{"street":"hui long guan","city":"beijing","postal_code":10010}}