Skip to content

Instantly share code, notes, and snippets.

@koheyamada

koheyamada/marathon.csv

Created May 2, 2018 13:21
Show Gist options
  • Save koheyamada/59830747a697b6cf38d80d5044c7336e to your computer and use it in GitHub Desktop.
Save koheyamada/59830747a697b6cf38d80d5044c7336e to your computer and use it in GitHub Desktop.
Download ZIP
Amazon S3 Select を使ってS3オブジェクトの特定データを抽出する。 ref: https://qiita.com/kooohei/items/bc180302cc98c01074d4
Raw
marathon.csv
marathon type m region
honolulu full 12 hawaii
shonann full 12 kanagawa
okayama full 11 okayama
fukkou full 10 miyagi
fuji5lake ultra 4 yamanashi
yokohama full 10 kanagawa
Raw
サンプルSQL
select * from s3object s where s.m = '10'
Raw
デフォルトSQL
select * from s3object s limit 5`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment