Hive Example Queries by Use Case
The following links collect sample Hive queries that solve several of our common use cases:
Parsing nested JSON records
Nested JSON records can be parsed by using Hive’s get_json_object UDF function. However, we recommend that you maintain a flat JSON structure to avoid additional CPU performance overhead.