· 7 years ago · Jan 22, 2019, 05:36 PM
1CREATE external TABLE IF NOT EXISTS counties
2 (
3 Name string,
4 BoundaryShape binary
5 )
6ROW FORMAT SERDE 'com.esri.hadoop.hive.serde.JsonSerde'
7STORED AS INPUTFORMAT 'com.esri.json.hadoop.EnclosedJsonInputFormat'
8OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
9LOCATION 's3://my-query-log/json/';