The Hadoop in Real World team looks at a pair of Hive functions:
Both get_json_object and json_tuple functions in Hive are meant to work with JSON data in Hive.
Let’s create a table with some JSON data to work with. We have created a table named hirw_courses and loaded the below JSON text into the table.
Click through for that script as well as seeing how you use each of get_json_object() and json_tuple() and which might be better-suited for your purposes.