JSON documents using Hive

JSON, is a minimal readable format for structuring data. It is used primarily to transmit data between a server and web application as an alternative to XML. JSON is built on two structures:

• A collection of name/value pairs. In various languages, this is realized as an object, record, struct, dictionary, hash table, keyed list, or associative array.
• An ordered list of values. In most languages, this is realized as an array, vector, list, or sequence.

Please read more on JSON at the following URL: http://www.json.org/.

Example 1 – Accessing simple JSON documents with Hive (Hive 0.14 and later versions)

In this example, we will see how to query simple JSON documents using HiveQL. Let's...