The State of Machine Intelligence – AI Landscape

In this blog, we will see how to parse Json data in hive and perform sql queries on top of this data.
Copy and paste below json data and save it as bloger.json:

Move data into hdfs using below command.

hdfs dfs -put bloger.json /tmp/sample/

Log into hive and create table blog


Load data into table blog from hdfs

load data inpath ‘/tmp/sample/’ into table blog;

Now, data is loaded into hive. Use below queries to access the json data in tabular format.

Share this post

Related Posts

Leave a Reply

Your email address will not be published.