I am using hive from HDP 2.2 and need to create a Hive table to query
multilevel Json data in HDFS of the following format:
{
"timestamp": "1424100629409",
"head": {
"time": "2015-02-16T15:30:29.409Z",
"place": {
"url": null,
"country": "US"
},
"event_type": null,
"name": "hive_test",
"event_id": "1234",
"metadata": {
"scope": "search",
"context": "test",
"extra_info": null
}
},
"sourceType": "test_source",
"millisecond": null,
"sourceFile": "test_file"
}
I am currently using the json serde :
https://github.com/rcongiu/Hive-JSON-Serde
But this does not let me define a table of the above format where the
"head" key has a few "string:string" mappings and a few "string:maps".
Does anyone know of a serde to define a table in this format?
Any help will be appreciated.
Thanks,
Udit