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

Reply via email to