question getting NULL value while using get_json_object instead of real value in Support Questions

question getting NULL value while using get_json_object instead of real value in Support Questions https://community.cloudera.com/t5/Support-Questions/getting-NULL-value-while-using-get-json-object-instead-of/m-p/136763#M99412 I am new to hive and playing around a nested JSON file and trying to capture a particular field(ID) from it. So I am trying to use get_json_object function as its only one field which is needed from the JSON file. The structure of my JSON file is :- <PRE>Object.resource.Object.entries.Array.Object.payload.Object.Id </PRE> <A href="http://object.resource.object.entries.array.object.payload.object.id/"></A><A href="http://object.resource.object.entries.array.object.payload.object.id/"> I am using the following query to capture the "ID" field from the JSON File :-</A><PRE>>SELECT GET_JSON_OBJECT(Id.json,'$.Object.resource.Object.entries.Array.Object.payload.Object.Id') FROM Id; OK NULL Time taken: 0.341 seconds, Fetched: 1 row(s) hive> </PRE><PRE>I also tried :- </PRE><PRE>>SELECT GET_JSON_OBJECT(Id.json,'$') FROM Id; OK NULL Time taken: 0.886 seconds, Fetched: 1 row(s) hive> </PRE><PRE>Tried my best to understand but not able to understand why getting this NULL value? Should I be using JSON SerDe instead? </PRE>My JSON data looks like :-<PRE>"httpStatus": 10807, "resource": { "feed": { "id": "planning.planning-service.ID", "name": "ID", "description": "Publish events on create and updates of ID" }, "entries": [{ "eventId": "9668383e-ec96-4d6a-b873-2312dd008e7b", "eventType": "ID", "publishedDate": "2016-05-31T18:52:29.219Z", "payload": { "ID": "e9301a6e-7ccf-4c89-bd05-19c1b9067a61" }, "_links": { "self": { "href": "http://lynsys.access:8080" }, "source": { "href": "http://lynsys.access:8080" } } }, { "eventId": "422a39cf-388d-4bbf-9a58-cd5aa8a17fc0", "eventType": "ID", "publishedDate": "2016-05-31T18:52:35.507Z", "payload": { "ID": "ecb761d2-fd22-401a-97b2-6e982705cc03" }, "_links": { "self": { "href": "http://lynsys.access:8080" }, "source": { "href": "http://lynsys.access:8080" } } },</PRE>Need to capture ID from the JSON file. Tue, 14 Jun 2016 13:03:28 GMT vijaysinghparma 2016-06-14T13:03:28Z