ã¹ããªãããã£ãŒã
ã¹ããªãããã£ãŒãã¯ãããŒã¿ããè€æ°ã®ãã£ãŒããèªåçæããŸããæåã»ããã¢ããã¯äžèŠã§ãããã£ãŒããŠã£ãžã§ããã 1 åèšå®ããåå²ããã«ã©ã ãéžæããã ãã§ãIronFlock ããã®ã«ã©ã ã®ãŠããŒã¯ãªå€ããšã« 1 ã€ã®ãã£ãŒããçæããŸãã
ä»çµã¿
- ãã£ãŒããŠã£ãžã§ãããç·šéã¢ãŒãã§éããŸãã
- ããŒã¿ã·ãªãŒãºèšå®å ã® Split Column èšå®ãèŠã€ããŸãã
- ããããåºæã®ãã£ãŒããçæããå€ãæã€ã«ã©ã ãéžæããŸãã
- ä¿åããŸã â ããŒããã°ã«ãŒãããšã«åå¥ã®ãã£ãŒããèªåçã«ã¬ã³ããªã³ã°ããŸãã
ãã®ã«ã©ã ã«æ°ããå€ã远å ãããå Žåããã£ãŒããå³åº§ã«èªåçæãããŸããèšå®ã®å€æŽã¯äžèŠã§ãã
ã©ã€ãäŸ
äŸïŒéœåžå¥ã®æž©åºŠ
ããã€ã¹ã timestampãtemperatureãcity ã® 3 ã€ã®ã«ã©ã ãæã€ããŒãã«ãéä¿¡ããŠãããšããŸãã
Split Column ã city ã«èšå®ããŸããããŒããèªåçã«ä»¥äžãçæããŸãïŒ
- ãã©ã³ã¯ãã«ã ã®æãç·ã°ã©ã
- ãã«ãªã³ ã®æãç·ã°ã©ã
- ããŒã¿ã«çŸãããã®ä»ãã¹ãŠã®éœåžã®ãã£ãŒã
| Timestamp | Temperature | City |
|---|---|---|
| 08:00 | 18 | Frankfurt |
| 09:00 | 19 | Frankfurt |
| 08:00 | 16 | Berlin |
| 09:00 | 17 | Berlin |
ãŠã£ãžã§ããå®çŸ©ã®éè€ã¯ãããŸãããæ°ããéœåžã远å ãããŠãæåæŽæ°ã¯äžèŠã§ãã
ã¹ããªãããã£ãŒãã䜿ãçç±
- æéã®ç¯çŽ â ãšã³ãã£ãã£ããšã«ãŠã£ãžã§ãããäœæãã代ããã«ã1 åã®èšå®ã§å®äºããŸãã
- èªåã¹ã±ãŒã« â æ°ããã»ã³ãµãŒããã·ã³ãå Žæã远å ããããšããã£ãŒããèªåçã«è¡šç€ºãããŸãã
- ããã·ã¥ããŒãããã£ããä¿ã€ â 1 ã€ã®ã³ã³ãã¯ããªèšå®ã§ãåçãªåºåãå®çŸããŸãã
ããã€ã¹ã®ããªãŒããã»ã³ãµãŒãããã¯ãŒã¯ããŸãã¯ã«ããŽãªå¥ã«ã°ã«ãŒãåãããããããããŒã¿ã»ããã®å¯èŠåã«æé©ã§ãã