Hive supports a couple of ways to read JSON data, however, I think the easiest way is to use custom JsonSerDe library. The article illustrated how to use this library to query JSON data stored in HDFS using Hive. 1. Download binary jar file based on your CDH version at: …
Reading JSON data in Hive is super easy, you can simply use the custom JSON SerDe library that has been created by someone else and load it into Hive and you are ready to go. No UDFs or UDAFs are required. Just follow the steps below: 1. Assuming you have …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!