· 9 years ago · Jan 10, 2017, 01:18 AM
1[
2 {"name": "james", "id": 41},
3 {"name": "scott", "id": 62},
4 {"name": "abhi", "id": 16},
5 {"name": "kevin", "id": 53},
6 {"name": "beau", "id": 12},
7 {"name": "shally", "id": 35},
8 {"name": "jude", "id": 53},
9 {"name": "jason", "id": 77},
10 {"name": "hongjian", "id": 35},
11 {"name": "madhur", "id": 6}
12]
13
14["data":{"name": "james","id": 41"},{.....}]
15
16CREATE EXTERNAL TABLE IF NOT EXISTS test.test (
17 `data` array<struct<`name`:string,`id`:bigint>>
18)
19ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
20WITH SERDEPROPERTIES (
21 'serialization.format' = '1'
22) LOCATION 's3://test-bucket/';