How would you transform a table column that contains rows of json data in it into individual columns using hiveql

Ex:

People { "name":"John", "age":31, "city":"New York" }{ "name":"Joan", "age":29, "city":"New York" }{ "name":"Ray", "age":51, "city":"New York" }

To:

name age city John 31 New York Joan 29 New York Ray 51 New York

Thanks!