Amazon Athenaã§ELBã®ãƒã‚°ã‚’調査ã™ã‚‹ã¨ãã«ä½¿ã£ãŸSQL | DevelopersIOã¯ã˜ã‚㫠今ã¾ã§ã¯ãƒã‚°ã®èª¿æŸ»ã®éš›ã«ã¯S3ã«ã‚ã‚‹ELBã®ãƒã‚°ã‚’ãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦grepã—ãŸã‚Šã—ã¦ã¾ã—ãŒã€ Athenaを使ã£ã¦ãƒã‚°ã‚’解æžã—ã¦ã¿ã¾ã—ãŸã®ã§ä»Šå›žã¯èª¿æŸ»ã®ã¨ãã«ä½¿ã£ãŸSQLã‚’ã”紹介ã—ã¾ã™ã€‚ ã”紹介ã™ã‚‹SQLを使ãˆã°ã‚ã¨ã¯å°‘ã—変ãˆã‚‹ã ã‘ã§ã„ã‚ã„ã‚ãªèª¿æŸ»ãŒå¯èƒ½ã‹ã¨æ€ã„ã¾ã™ã€‚ Athenaデータベースã€ãƒ†ãƒ¼ãƒ–ルã®æº–å‚™ Athenaを使用ã™ã‚‹éš›ã®æ‰‹é †ã¯ä»¥ä¸‹ãƒ–ãƒã‚°ã‚’å‚考ã«ã—ã¦ãã ã•ã„。 Amazon Athenaã§ELBãƒã‚°ã‚’SQLã§è§£æžã™ã‚‹ #reinvent 調査ã«ä½¿ç”¨ã—ãŸSQL ELB毎ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã‚’調ã¹ã‚‹ SELECT elb_name, count(*) AS request_count FROM elb_logs GROUP BY elb_name ORDER BY request_count DESC; 特定ã®æ™‚間内ã§ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã‚’調ã¹ã‚‹ SELECT elb_name,
{{#tags}}- {{label}}
{{/tags}}