Hive Table Error loading json data
<p>json file:</p>

<pre><code>{
    "DocId":"ABC",
    "User":{
        "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"
            }
        ]
    }
}}
</code></pre>

<p>schema:</p>

<pre><code>create external table sample_json(DocId string,User struct&lt;Id:int,Username:string,Name:string,ShippingAddress:struct&lt;Address1:string,Address2:string,City:string,State:string&gt;,Orders:array&lt;struct&lt;ItemId:int,OrderDate:string&gt;&gt;&gt;)ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe' location '/user/babu/sample_json';
</code></pre>

<p>--loading data to the hive table</p>

<p>load data inpath '/user/samplejson/samplejson.json' into table sample_json;</p>

<p>Error:</p>

<p>when I am firing the select query like </p>

<pre><code>select * from sample_json;
</code></pre>

<p>Exception:</p>

<blockquote>
  <p>Failed with exception
  java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException:
  org.codehaus.jackson.JsonParseException: Unexpected end-of-input:
  expected close marker for OBJECT (from [Source:
  java.io.StringReader@8c3770; line: 1, column: 0])  at [Source:
  java.io.StringReader@8c3770; line: 1, column: 3]</p>
</blockquote>