Here is the code based on the specification provided:

How to Optimize HiveQL Syntax for Performance with LLAP vs Default Connections

Extracting Data from Nested JSON with HiveQL: A Step-by-Step Guide