t02e03BH

1CREATE EXTERNAL TABLE IF NOT EXISTS sify_cvs_output.json(
2data:Array <
3  candidatedob bigint,
4  candidateemail string,
5  candidateid string,
6  candidatename string,
7  candidatephone string,
8  candidatephoto string,
9  createdby string,
10  createdtime bigint,
11  deleted boolean,
12  eventref string,
13  examdate bigint,
14  fingerprintdata struct<fingerprints:array<struct<enrolledTime:bigint, fingerid:bigint, isotemplate:string, sessionkey:string>>, userid:string>,
15  id string,
16  labname string,
17  locationname string,
18  locationref string,
19  registeredby string,
20  registereddate bigint,
21  seatno string,
22  updatedby string,
23  updatedtime bigint,
24  walkincandidate boolean)
25PARTITIONED BY (event String,dt String,centercode String)
26ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
27WITH SERDEPROPERTIES ( "ignore.malformed.json" = "true","input.regex" ="*.json")
28LOCATION 'hdfs://172.16.2.191:8020/tmp/candidatelist/';