| CREATE TABLE cities (Name string, CoOrdinate binary) | |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.udf.esri.serde.EsriJsonSerDe' | |
| STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.esriJson.UnenclosedEsriJsonInputFormat' | |
| OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'; | |
| load data local inpath "../../data/files/geo-json.json" OVERWRITE INTO TABLE cities; | |
| select name, ST_AsText(coordinate) from cities; |