How to analyze Json data in Hive | Step by steps to process Jsondata

In this video i have demonstrated How to analyze JSON data in hive?
bigdataanalyst.in
Please follow these steps:
How to analyze json data:

Download from files.cloudera.com/samples/hive-serdes-1.0-SNAP…
copy this file into hive/lib path.

start hadoop and hive


CREATE EXTERNAL TABLE originaldata (created_at STRING,
text STRING,
user STRUCT //place less then here its not accept in the description
screen_name:STRING,
name:STRING,
locations:STRING,
description:STRING,
created_at:STRING,
followers_count:INT,
url:STRING //place greater then here its not accept in the description
) ROW FORMAT SERDE 'com.cloudera.hive.serde.JSONSerDe' location '/home/hadoop/work/warehouse/bigsql.db/raw_tables';


create table desiretable as select * from originaldata;

add jar /home/hadoop/work/hive-0.10.0/lib/hive-serdes-1.0-SNAPSHOT.jar;


select * from tablename;
select * from desiretable where user.locations like "%USA%";
select user.name, user.url from desiretable where user.description like "%bigdata%";

If you have any doubt comment below.
Thanks
Your Venu