リクエストURIの部分をHTTPメソッド、ホスト名、パス、QueryStringに分割しました。 Athenaの?の認識が怪しかったので、\?ですむところをわざわざ[?]にしたりしています。 CREATE EXTERNAL TABLE IF NOT EXISTS table_name ( type string, request_timestamp string, elb_name string, client_addr string, client_port int, target_addrport string, target_addr string, target_port int, request_processing_time double, target_processing_time double, response_processing_time double, elb_s
![実用的なALBアクセスログ用のAthenaDDL - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/e61a0e1de6c05ef69c2015ff8596ef1415541fdf/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-9f5428127621718a910c8b63951390ad.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTkxNiZoPTMzNiZ0eHQ9JUU1JUFFJTlGJUU3JTk0JUE4JUU3JTlBJTg0JUUzJTgxJUFBQUxCJUUzJTgyJUEyJUUzJTgyJUFGJUUzJTgyJUJCJUUzJTgyJUI5JUUzJTgzJUFEJUUzJTgyJUIwJUU3JTk0JUE4JUUzJTgxJUFFQXRoZW5hRERMJnR4dC1jb2xvcj0lMjMyMTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmdHh0LWNsaXA9ZWxsaXBzaXMmdHh0LWFsaWduPWxlZnQlMkN0b3Amcz1mYzMzOGQ3NDAzYTk0MjNmMjc3MGRhYmI3MDgzZTI4YQ%26mark-x%3D142%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTYxNiZ0eHQ9JTQwc29ub2RhciZ0eHQtY29sb3I9JTIzMjEyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9M2Y4NWQ0NDFhZmZmMzJhODk5ODNjNDU5MWYxZDNkMDY%26blend-x%3D142%26blend-y%3D491%26blend-mode%3Dnormal%26s%3D41a1ef8d6aed40f7640a9833ee793403)