how can I extract single column from Array in HIVE???

Question

I have to extract timeStamp column from this Array in HIVE? [{"timeStamp":1506411499989,"status":"BROADCASTED"}]

Answer 1

Use explode function and then select the timestamp from the exploded table/view

Answer 2

Use lateral view+explode and get_json_object:

select s.*, get_json_object(a.your_json,'$.timeStamp') as timeStamp
  from your_table s
       lateral view outer explode (your_Array) a;