我的json如下所示：

[
  {
  "blocked": 1,
  "object": {
  "ip": "abc",
  "src_ip": "abc",
  "lan_initiated": true,
  "detection": "abc",
  "src_port": ,
  "src_mac": "abc",
  "dst_mac": "abc",
  "dst_ip": "abc",
  "dst_port": "abc"
},
"object_type": "url",
"threat": "",
"threat_type": "abc",
"device_id": "abc",
"app_id": "abc",
"user_id": "abc",
"timestamp": 1520268249657,
"date": {
  "$date": "Mon Mar 05 2018 16:44:09 GMT+0000 (UTC)"
},
"expire": {
  "$date": "Fri May 04 2018 16:44:09 GMT+0000 (UTC)"
},
"_id": "abc"
  }
]

我试过：

CREATE EXTERNAL TABLE `table_name`(
  reports array<struct<
  user_id: string ,
  device_id: string ,
  app_id: string ,
  blocked: string ,
  object: struct<ip:string,src_ip:string,lan_initiated:string,detection:string,src_port:string,src_mac:string,dst_mac:string,dstp_ip:string,dst_port:string> ,
  object_type: string ,
  threat: string ,
  threat_type: string ,
  servertime:string,
  date_t: struct<dat:string>,
  expire: struct<dat:string>,
  id: string >>)
ROW FORMAT SERDE
  'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES (
  'ignore.malformed.json'='false','mapping.dat'='$date', 'mapping.servertime'='timestamp','mapping.date'='date_t','mapping._id'='id')
STORED AS INPUTFORMAT
  'org.apache.hadoop.mapred.TextInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'abc'

之后呢

SELECT * FROM table_name
LATERAL VIEW outer explode(reports) exploded_table as rep;

但是我得到：由于自己的任务失败，vertex没有成功-被杀死/失败原因：null。
我已经读过了，因为json以“[”开头，所以无法解析它。有什么想法吗？json的结构必须改变吗？