Redshiftã§ä»»æ„個数ã®æ–‡å—列を扱ㆠ- é’木ブãƒã‚°æœ€çµ‚çš„ã«ã¯ç¸¦æŒã¡ã«ã—ã¡ã‚ƒãˆã°ã©ã‚“ãªRDBã§ã‚‚扱ãˆã‚‹ã‚“ã ã‘ã©ã€ æŸMySQLã¨ã‹æŸHadoopã¨ã‹ã ã¨é…列ã§æŒã£ã¦ã‚‹ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ ã‚ã‚ã„ã†ã®ã‚’ã©ã†ã‚„ã£ã¦ã¨ã‚Šã“ã‚€ã‹1å¹´ãらã„考ãˆã¦ãŸã‚“ã ã‘ã© ã¤ã„ã«æ±ºå®šç‰ˆã‚’æ€ã„ã¤ã„ãŸã€‚ 扱ãˆã‚‹å€‹æ•°ã®ä¸Šé™ã¯ã‚ã‚‹ã‚“ã ã‘ã©ã€ç¾å®Ÿçš„ã«ã¯ã»ã¼ä¸Šé™ã‚’考ãˆãªãã¦æ¸ˆã‚€ã¨æ€ã†ã€‚ 1. æ–‡å—列é…列をJSONã¨ã—ã¦Redshiftã«å–り込む => select * from slog order by 1; id | words ----+--------------- 1 | ["a","b","c"] 2 | ["xxx","yyy"] 2. 連番 1 カラムã ã‘ã®ãƒ†ãƒ¼ãƒ–ルを用æ„ã™ã‚‹ ã“ã®é€£ç•ªãƒ†ãƒ¼ãƒ–ルã®ã‚µã‚¤ã‚ºãŒæ‰±ãˆã‚‹å€‹æ•°ã®ä¸Šé™ã«ãªã£ã¦ã—ã¾ã†ã®ã§æ³¨æ„ => select * from sseq order by 1; x --- 1 2 3 4 5 3. ジョインã™ã‚‹ ä¸ç‰å·
CyberZã€å¤§åž‹eスãƒãƒ¼ãƒ„スタジオを構ãˆãŸã€ŒOPENREC STUDIOã€--リーグ戦構想も
Python Django入門 (1) - Qiita
{{#tags}}- {{label}}
{{/tags}}