Amazon Athenaã§ã„ã‚ã„ã‚ãªSELECTを実行ã—ã¦ã¿ã‚‹ | DevelopersIOã¯ã˜ã‚ã« re:Invent 2016ã§ç™ºè¡¨ã•ã‚ŒãŸAthenaã«ã¤ã„ã¦ã¯å¼Šç¤¾ã§ã‚‚æ—¢ã«æ§˜ã€…ãªè¨˜äº‹ãŒå‡ºã¦ãŠã‚Šã¾ã™ã€‚å…¬å¼ã‚µã‚¤ãƒˆã«ã‚ˆã‚‹ã¨ã„ã‚ã„ã‚ãªSQLを使ã†äº‹ãŒã§ãるよã†ãªã®ã§ã™ãŒã€ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ã®SELECTを実際ã«è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ SELECTã®å®Ÿè¡Œ Athenaã®å®Ÿè¡Œæ–¹æ³•ã«ã¤ã„ã¦ã¯å¼Šç¤¾ã®è¨˜äº‹ãªã©ã‚’å‚考ã«ã—ã¦ãã ã•ã„。今回ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹sampledb.elb_logsテーブルã«å¯¾ã—ã¦SELECTを実行ã—ã¦ã¿ã¾ã—ãŸã€‚ 以下ã€ä»Šå›žè©¦ã—ãŸSELECTã®ç¨®é¡žã§ã™ã€‚ with distinct join where group by having union order by limit tablesample unnest with 以下ã®SQLを実行ã—ã¾ã—ãŸã€‚ with elb_logs_with as ( select requestip, backendport from elb
ELBã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‚’å¯è¦–化ã—ã€è¶…絶手軽ã«åˆ†æžã™ã‚‹[QuickSight,Athena] | DevelopersIO![ELBã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‚’å¯è¦–化ã—ã€è¶…絶手軽ã«åˆ†æžã™ã‚‹[QuickSight,Athena] | DevelopersIO](https://cdn-ak-scissors.b.st-hatena.com/image/square/2fa55da21da59730bd35238aa38fac0331bb63ac/height=288;version=1;width=512/https%3A%2F%2Fdevio2023-media.developers.io%2Fwp-content%2Fuploads%2F2016%2F06%2Fquicksight.png)
ã‚Œã¹ã‚‹ã®äººï¼ˆin-the-sky） on Twitter: "@angel_belt_61 ã„ã„人ã§ã‚‚ãã£ã¡å´ã«è»¢ãŒã‚‹å¯èƒ½æ€§ãŒå分ã«ã‚ã‚‹ã—ã€æ°—ã‚’ã¤ã‘ã¦ãªã„ã¨ä»–人事ã˜ã‚ƒãªã„。 やらã‹ã—ãŸå¥´ã¯ã„ã„人ã˜ã‚ƒãªããªã‚ã†ã¨ã—ã¦ã„ãŸã‹ã¨è¨€ãˆã°ãã†ã§ã¯ãªã„。"
自動é‹è»¢è·¯ç·šãƒã‚¹ã€è©¦ä¹—ã—ã¦ãŒã£ã‹ã‚Šã—ãŸç†ç”± (1/5) - ITmedia ビジãƒã‚¹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³
æ±äº¬éƒ½ã®ã€Œé¸ã°ã‚Œã—6路線ã€ã¯å®Ÿç¾ã™ã‚‹ã®ã‹
æ±æ€¥ãƒ»ç›¸é‰„「新横浜線ã€ã€€æ–°è·¯ç·šã®ãƒãƒ¼ãƒŸãƒ³ã‚°ãŒç´ 晴らã—ã„ç†ç”± (1/5) - ITmedia ビジãƒã‚¹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³
国鉄を知らãªã„人ã¸è´ˆã‚‹ã€Œåˆ†å‰²æ°‘営化ã€ã®è©±
æ±å・大和トンãƒãƒ«æ¸‹æ»žã¯ã„ã¤è§£æ¶ˆã•ã‚Œã‚‹ã®ã‹ æ–°æ±åã¨ã®æŽ¥ç¶šã€ã©ã†å½±éŸ¿ï¼Ÿ éµã¯åœå¤®é“ | ä¹—ã‚Šã‚‚ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹
{{#tags}}- {{label}}
{{/tags}}