aws athena创建表

CREATE EXTERNAL TABLE lavalog.test_log(

date string,

log string)

PARTITIONED BY (year int,month int,day int)

ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'

WITH SERDEPROPERTIES ('ignore.malformed.json'='true')

LOCATION 's3://fluent-bit-s3-gj/testlog/';

修复分区表

MSCK REPAIR TABLE  lavalog.log;