Skip to content

Instantly share code, notes, and snippets.

@aki-lua87

aki-lua87/LineJsonAthena.sql

Last active July 6, 2017 15:20
Show Gist options
  • Save aki-lua87/a52e7e4b0fb341ae0a8b3ee4939045e3 to your computer and use it in GitHub Desktop.
Save aki-lua87/a52e7e4b0fb341ae0a8b3ee4939045e3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
LineJsonAthena.sql
CREATE EXTERNAL TABLE IF NOT EXISTS line
(
timestamp timestamp,
replyToken string,
message struct < type:string, id:string, text:string>,
type string,
source struct < userId:string, type:string >
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://hoge';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment