jqdXwFML

1"otherstuff" : "stuff",
2"ArrayofArrays" : {
3   "Array-1" : {
4      "type" : "sometype",
5      "is_enabled" : false,
6      "is_active" : false,
7      "version" : "version 1.1"
8   },
9   "Array-2" : {
10      "type" : "sometype",
11      "is_enabled" : false,
12      "is_active" : false,
13      "version" : "version 1.2"
14   }
15   ...
16}
17	
18CREATE EXTERNAL TABLE IF NOT EXISTS test2.table14 (
19`otherstuff` string,
20`ArrayofArrays` array<array<struct<version:string>>>
21) 
22ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
23WITH SERDEPROPERTIES (
24     'serialization.format' = '1' ) LOCATION 's3://bucket/folder/' TBLPROPERTIES ('has_encrypted_data'='false')