· 9 years ago · Dec 18, 2016, 01:10 AM
1{'oldname':'mau'}
2
3CREATE EXTERNAL TABLE IF NOT EXISTS stats_json.t (
4 `oldname` string
5)
6ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
7WITH SERDEPROPERTIES (
8 'serialization.format' = '1'
9) LOCATION 's3://mybucket/stats/';
10
11select * from t limit 10;