create EXTERNAL table kccdata1 (
Response string,
data array<struct<
Season:STRING,
Sector:STRING,
Category:STRING,
Crop:STRING,
QueryType:STRING,
QueryText:string,
KCCAns:string,
StateName:string,
DistrictName:string,
BlockName:string,
SubmitDate:string>>)
row format serde "org.apache.hive.hcatalog.data.JsonSerDe"
location "/user/hduser/jsondata";

select data[0].querytype from kccdata1;

select data.season[1] from kccdata1;