çŸåšãã»ãšãã©ã©ãã«ã§ã倧éã®ããŒã¿ãããã«ãããããããåæããŒã¿ããŒã¹ã¯äŸç¶ãšããŠéåžžã«çãããã®ã§ãã ãããã¯ããŸãç¥ãããŠããããããã«å¹æçã«äœ¿çšããããšãã§ããŸããã å€ãã®äººã¯ãä»ã®ã·ããªãªåãã«èšèšããã MySQL ã PostgreSQL ã䜿ã£ãŠããµããã³ãé£ã¹ãç¶ããNoSQL ã«æ©ãŸãããããåçšãœãªã¥ãŒã·ã§ã³ã«éå°ãªãéãæã£ããããŠããŸãã ClickHouse ã¯ã²ãŒã ã®ã«ãŒã«ãå€ããåæ DBMS ã®äžçã«å ¥ãæ·å± ãå€§å¹ ã«äžããŸãã
BackEnd Conf 2018 ã®ã¬ããŒãã§ãããè¬æŒè ã®èš±å¯ãåŸãŠæ²èŒããŠããŸãã
ç§ã¯äœè
ã§ããªã ClickHouse ã«ã€ããŠè©±ããŠããã®ã§ãã? ç§ã¯ãClickHouse ã䜿çšããŠãã LifeStreet ã®éçºãã£ã¬ã¯ã¿ãŒã§ãã ãŸããç§ã¯ Altinity ã®åµèšè
ã§ããããŸãã ããã¯ãClickHouse ãæšé²ããYandex ã ClickHouse ãããã«æåãããã®ãæ¯æŽãã Yandex ããŒãããŒã§ãã ClickHouse ã«é¢ããç¥èãå
±æããæºåãã§ããŠããŸãã
ãããŠç§ã¯ããã£ã¢ã»ã¶ã€ãã§ãã®å åŒã§ã¯ãããŸããã ãã®ããšã«ã€ããŠãã質åãããŸãã ããããç§ãã¡ã¯å åŒã§ã¯ãããŸããã
ã誰ããç¥ã£ãŠãããClickHouse ã¯æ¬¡ã®ãšããã§ãã
- ãšãŠãæ©ãã
- ãšãŠãå¿«é©
- Yandex ã§äœ¿çšãããŸãã
ã©ã®äŒæ¥ã§ã©ã®ããã«äœ¿çšãããŠãããã¯ãããŸãç¥ãããŠããŸããã
Yandex ãé€ããŠãClickHouse ããªããã©ãã§ãã©ã®ããã«äœ¿çšãããã®ãã説æããŸãã
ããŸããŸãªäŒæ¥ã§ ClickHouse ãå©çšããŠç¹å®ã®ã¿ã¹ã¯ãã©ã®ããã«è§£æ±ºãããŠããããã¿ã¹ã¯ã«äœ¿çšã§ãã ClickHouse ããŒã«ãããã³ããããããŸããŸãªäŒæ¥ã§ã©ã®ããã«äœ¿çšãããŠãããã«ã€ããŠèª¬æããŸãã
ClickHouseãããŸããŸãªè§åºŠãã玹ä»ããXNUMXã€ã®äºäŸãããã¯ã¢ããããŸããã é¢çœããšæããŸããã
æåã®è³ªåã¯ãããªã ClickHouse ãå¿ èŠãªã®ã?ãã§ãã ããªãæçœãªè³ªåã®ããã«æããŸãããããã«å¯Ÿããçãã¯è€æ°ãããŸãã
- æåã®çãã¯ããã©ãŒãã³ã¹ã«é¢ãããã®ã§ãã ClickHouseã¯éåžžã«é«éã§ãã ClickHouse ã®åæãéåžžã«é«éã§ãã ä»ã®äœããéåžžã«é ãããŸãã¯éåžžã«æªãå Žåã«ãã䜿çšãããŸãã
- XNUMX çªç®ã®çãã¯ã³ã¹ãã§ãã ãããŠãŸã第äžã«ãã¹ã±ãŒãªã³ã°ã®ã³ã¹ãã§ãã ããšãã°ãVertica ã¯éåžžã«åªããããŒã¿ããŒã¹ã§ãã ãã©ãã€ãåäœã®ããŒã¿ãããŸããªãå Žåã«ã¯ãéåžžã«ããŸãæ©èœããŸãã ããããæ°çŸãã©ãã€ãããã¿ãã€ããšãªããšãã©ã€ã»ã³ã¹ãšãµããŒãã®ã³ã¹ãã¯ããªãã®é¡ã«ãªããŸãã ãããŠé«äŸ¡ã§ãã ãããŠClickHouseã¯ç¡æã§ãã
- XNUMX çªç®ã®çãã¯ãéçšã³ã¹ãã§ãã ããã¯å°ãç°ãªãã¢ãããŒãã§ãã RedShift ã¯åªããã¢ããã°ã§ãã RedShift ã§ã¯ãéåžžã«è¿ éã«æ±ºå®ãäžãããšãã§ããŸãã ããã¯ããŸãæ©èœããŸãããåæã«ãããã¯éåžžã«é«äŸ¡ãªãµãŒãã¹ã§ãããããæ¯æéãæ¯æ¥ãæ¯æãAmazon ã«å€é¡ã®æéãæ¯æãããšã«ãªããŸãã Google BigQueryãã 誰ããããã䜿çšããå Žåãããã§ããã€ãã®ãªã¯ãšã¹ããå®è¡ãããšãçªç¶æ°çŸãã«ã®è«æ±æžãå±ãå¯èœæ§ãããããšãããããŸãã
ClickHouse ã«ã¯ãããã®åé¡ã¯ãããŸããã
ClickHouse ã¯çŸåšã©ãã§äœ¿çšãããŠããŸãã? Yandex ã«å ããŠãClickHouse ã¯ããŸããŸãªããžãã¹ãäŒæ¥ã§äœ¿çšãããŠããŸãã
- ãŸã第äžã«ããã㯠Web ã¢ããªã±ãŒã·ã§ã³åæã§ããã€ãŸãããã㯠Yandex ããæ¥ããŠãŒã¹ã±ãŒã¹ã§ãã
- å€ãã®ã¢ãããã¯äŒæ¥ã ClickHouse ã䜿çšããŠããŸãã
- ããŸããŸãªãœãŒã¹ããã®ãã©ã³ã¶ã¯ã·ã§ã³ ãã°ãåæããå¿ èŠãããå€ãã®äŒæ¥ã
- ããã€ãã®äŒæ¥ã ClickHouse ã䜿çšããŠã»ãã¥ãªã㣠ãã°ãç£èŠããŠããŸãã ãããã ClickHouse ã«ã¢ããããŒãããã¬ããŒããäœæããå¿ èŠãªçµæãååŸããŸãã
- äŒæ¥ã¯è²¡ååæã«ããã䜿çšãå§ããŠãããåŸã ã«å€§äŒæ¥ãClickHouseã«ã¢ãããŒãããŠããŸãã
- ã¯ã©ãŠããã¬ã¢ã ClickHouse ããã©ããŒããŠãã人ãªãããããããã®äŒç€Ÿã®ååãèããããšãããã§ãããã ããã¯ã³ãã¥ããã£ããã®éèŠãªè²¢ç®è ã® XNUMX 人ã§ãã ãããŠã圌ãã¯éåžžã«æ¬æ ŒçãªClickHouseãã€ã³ã¹ããŒã«ããŠããŸãã ããšãã°ã圌ã㯠ClickHouse çšã® Kafka ãšã³ãžã³ãäœæããŸããã
- éä¿¡äŒç€Ÿã䜿ãå§ããã ããã€ãã®äŒæ¥ããClickHouse ãæŠå¿µå®èšŒãšããŠããŸãã¯ãã§ã«éçšäžãšããŠäœ¿çšããŠããŸãã
- ããäŒæ¥ã§ã¯ãClickHouse ã䜿çšããŠçç£ããã»ã¹ãç£èŠããŠããŸãã 圌ãã¯è¶ å°ååè·¯ããã¹ããã倧éã®ãã©ã¡ãŒã¿ãæžãçããŸããçŽ 2 ã®ç¹æ§ããããŸãã ãããŠãã²ãŒã ãè¯ããæªãããåæããŸãã
- ãããã¯ãã§ãŒã³åæã Bloxy.info ãšãããã·ã¢ã®äŒç€ŸããããŸãã ããã¯ã€ãŒãµãªã¢ã ãããã¯ãŒã¯ã®åæã§ãã 圌ãã¯ClickHouseã§ããããè¡ããŸããã
ãããŠããµã€ãºã¯é¢ä¿ãããŸããã XNUMX å°ã®å°èŠæš¡ãµãŒããŒã䜿çšããŠããäŒæ¥ã¯æ°å€ããããŸãã ãããŠåœŒã¯åœŒããåé¡ã解決ã§ããããã«ããŸãã ãããŠãå€ãã®ãµãŒããŒãŸãã¯æ°åå°ã®ãµãŒããŒãããªã倧èŠæš¡ãªã¯ã©ã¹ã¿ãŒã䜿çšããäŒæ¥ã¯ããã«å€ããªã£ãŠããŸãã
ãããŠèšé²ãèŠããšã次ã®ããã«ãªããŸãã
- Yandex: 500 å°ä»¥äžã®ãµãŒããŒãããã25 æ¥ããã XNUMX å件ã®ã¬ã³ãŒããä¿åãããŠããŸãã
- LifeStreet: ãµãŒã㌠60 å°ã75 æ¥ãããçŽ XNUMX åã¬ã³ãŒãã Yandex ããããµãŒããŒã®æ°ãå°ãªããã¬ã³ãŒãã®æ°ãå€ããªããŸãã
- CloudFlare: 36 å°ã®ãµãŒããŒã§ã200 æ¥ããã XNUMX å件ã®ã¬ã³ãŒããä¿åãããŸãã ãµãŒããŒã®æ°ã¯ããã«å°ãªããªããããã«å€ãã®ããŒã¿ãä¿åãããŸãã
- ãã«ãŒã ããŒã°: ãµãŒã㌠102 å°ãXNUMX æ¥ãããçŽ XNUMX å 件ã®ãšã³ããªã èšé²ä¿æè ã
å°ççã«ãããã¯ãããããããŸãã ãã®ãããã¯ãClickHouse ãäžçäžã§äœ¿çšãããŠããå Žæã®ããŒããããã瀺ããŠããŸãã ããã§ã¯ãã·ã¢ãäžåœãã¢ã¡ãªã«ãã¯ã£ãããšéç«ã£ãŠããŸãã ãšãŒãããã®åœã¯ã»ãšãã©ãããŸããã ãããŠã¯ã©ã¹ã¿ãŒã¯4ã€ãããŸãã
ããã¯æ¯èŒåæã§ããã絶察çãªæ°åãæ¢ãå¿ èŠã¯ãããŸããã ããã¯ãAltinity ã® Web ãµã€ãã«ã¯ãã·ã¢èªã話ã人ãããªããããè±èªã®è³æãèªãã 蚪åè ã®åæã§ãã ãããŠããã·ã¢ããŠã¯ã©ã€ãããã©ã«ãŒã·ãã€ãŸãã³ãã¥ããã£ã®ãã·ã¢èªã話ãå°åãæãå€ãã®ãŠãŒã¶ãŒãå ããŠããŸãã 次ã«ã¢ã¡ãªã«ãšã«ãããç¶ããŸãã äžåœã¯éåžžã«è¿œãã€ããŠããŸãã å幎åã«ã¯ããã«ã¯äžåœã¯ã»ãšãã©ååšããªãã£ãããä»ã§ã¯äžåœã¯ãã§ã«ãšãŒããããè¿œãè¶ããæé·ãç¶ããŠããã å€ããšãŒããããããã«é ãåã°ããå¥åŠãªããšã«ãClickHouse ã®äœ¿çšã®ãªãŒããŒã¯ãã©ã³ã¹ã§ãã
ãªãç§ããããªããšã話ããŠããã®ã§ããããïŒ ClickHouse ãããã°ããŒã¿åæã®æšæºãœãªã¥ãŒã·ã§ã³ã«ãªãã€ã€ããããã§ã«å€ãã®å Žæã§äœ¿çšãããŠããããšã瀺ãããã ããã䜿ãã°ãããªãã¯æ£ããåŸåã«ããŸãã ãŸã 䜿çšããŠããªãå Žåã¯ãå€ãã®äººããã§ã«ããã䜿çšããŠãããããå€ç«ããŠèª°ãå©ããŠãããªãããšãæããå¿ èŠã¯ãããŸããã
ãããã¯ãããã€ãã®äŒæ¥ã§å®éã« ClickHouse ã䜿çšãããŠããäŸã§ãã
- æåã®äŸã¯åºåãããã¯ãŒã¯ã§ããVertica ãã ClickHouse ãžã®ç§»è¡ã§ãã ãããŠãç§ã¯ Vertica ãã移è¡ããããŸãã¯ç§»è¡éäžã®äŒæ¥ãæ°ç€Ÿç¥ã£ãŠããŸãã
- XNUMX çªç®ã®äŸã¯ãClickHouse ã®ãã©ã³ã¶ã¯ã·ã§ã³ ã¹ãã¬ãŒãžã§ãã ããã¯ã¢ã³ããã¿ãŒã³ã«åºã¥ããŠæ§ç¯ãããäŸã§ãã éçºè ã®ã¢ããã€ã¹ã«åŸã£ãŠ ClickHouse ã§å®è¡ãã¹ãã§ãªãããšã¯ãã¹ãŠãããã§å®è¡ãããŸãã ãããŠããã¯éåžžã«å¹æçã«è¡ãããŠããã®ã§ãããŸããããŸãã ãããŠãããã¯å žåçãªãã©ã³ã¶ã¯ã·ã§ã³ãœãªã¥ãŒã·ã§ã³ãããã¯ããã«ããŸãæ©èœããŸãã
- XNUMX çªç®ã®äŸã¯ãClickHouse ã§ã®åæ£ã³ã³ãã¥ãŒãã£ã³ã°ã§ãã ClickHouse ã Hadoop ãšã³ã·ã¹ãã ã«ã©ã®ããã«çµ±åã§ãããã«ã€ããŠã®è³ªåããããŸããã éåžžã«éèŠãªã¿ã¹ã¯ãèšç®ããããã«ãããäŒæ¥ã ClickHouse ã®ããã ãªãã¥ãŒã¹ ã³ã³ãããŒãšåæ§ã®ããšãå®è¡ããããŒã¿ã®ããŒã«ãªãŒãŒã·ã§ã³ã远跡ãããªã©ã®æ¹æ³ãå®è¡ããäŸã瀺ããŸãã
- LifeStreet ã¯ãåºåãããã¯ãŒã¯ã«ä»éãããããããã¯ãããžãŒãåããã¢ããã¯äŒæ¥ã§ãã
- 圌女ã¯åºåã®æé©åãããã°ã©ããã£ãã¯å ¥æã«åŸäºããŠããŸãã
- 倧éã®ããŒã¿: 10 æ¥ãããçŽ XNUMX åã®ã€ãã³ãã åæã«ãããã§ã®ã€ãã³ãã¯ããã€ãã®ãµãã€ãã³ãã«åå²ã§ããŸãã
- ãã®ããŒã¿ã®ã¯ã©ã€ã¢ã³ãã¯æ°å€ããããŸããããããã¯äººéã ãã§ã¯ãªããããã«å€ãã®ãããã°ã©ããã£ãã¯å ¥æã«é¢äžããããŸããŸãªã¢ã«ãŽãªãºã ã§ãã
å瀟ã¯é·ãéºããéãæ©ãã§ããã ãããŠç§ã¯ããã«ã€ããŠHighLoadã§è©±ããŸããã ãŸããLifeStreet 㯠MySQL (Oracle ã«å°ãç«ã¡å¯ããŸãã) ãã Vertica ã«ç§»è¡ããŸããã ãããŠãããã«é¢ããç©èªãèŠã€ããããšãã§ããŸãã
ãã¹ãŠã¯éåžžã«è¯å¥œã§ããããããŒã¿ãå¢å€§ãç¶ããŠãããVertica ãé«äŸ¡ã§ããããšãããã«æããã«ãªããŸããã ãããã£ãŠãããŸããŸãªä»£æ¿æ¡ã暡玢ãããŸããã ãã®ãã¡ã®ããã€ããããã«ãªã¹ãããŸãã ãããŠå®éãç§ãã¡ã¯ 13 幎ç®ãã 16 幎ç®ã«åžå Žã§å ¥æå¯èœã§ãæ©èœã®ç¹ã§ã»ãŒé©åã ã£ãã»ãŒãã¹ãŠã®ããŒã¿ããŒã¹ã®æŠå¿µå®èšŒããŸãã¯å Žåã«ãã£ãŠã¯ããã©ãŒãã³ã¹ ãã¹ããè¡ããŸããã ãããŠããããã®ããã€ãã«ã€ããŠã¯ HighLoad ã§ã話ããŸããã
ããŒã¿ãå¢å€§ãããããããããã®èª²é¡ã¯ Vertica ãã移è¡ããããšã§ããã ãããŠããããã¯é·å¹Žã«ããã£ãŠé£èºçã«æé·ããŸããã ãã®åŸããããã¯æ£ã«çœ®ãããŸããããããã§ããªãã§ãã ãããŠããã®æé·ãäºæž¬ããããçš®ã®åæãè¡ãå¿ èŠãããããŒã¿éã®ããžãã¹èŠä»¶ãäºæž¬ãããšãããã«ãã¿ãã€ãã«ã€ããŠè°è«ãããããšã¯æããã§ããã ãŸãããã¿ãã€ãã®æéãæ¯æãã®ã¯ãã§ã«éåžžã«é«äŸ¡ã§ããããã代ããã®å Žæãæ¢ããŠããŸããã
ã©ããžè¡ãïŒ ãããŠãäžæ¹ã§ã¯åçšããŒã¿ããŒã¹ãããããããã¯ããŸãæ©èœããŠããããã«èŠãããããé·ãéãã©ãã«è¡ãã¹ãããŸã£ããæ確ã§ã¯ãããŸããã§ããã Vertica ãšã»ãŒåãããã«åäœãããã®ãããã°ãããããå£ããã®ããããŸãã ããããã©ããé«äŸ¡ã§ãããããå®ããŠè¯ããã®ã¯èŠã€ãããŸããã§ããã
äžæ¹ã§ããªãŒãã³ãœãŒã¹ ãœãªã¥ãŒã·ã§ã³ããããŸããããã®æ°ã¯ããã»ã©å€ããããŸãããã€ãŸããåæã«é¢ããŠã¯æã§æ°ããããçšåºŠã§ãã ãããŠããããã¯ç¡æãŸãã¯å®äŸ¡ã§ãããé ãã§ãã ãããŠãå¿ èŠãªäŸ¿å©ãªæ©èœãæ¬ ããŠããããšããããããŸãã
ãããŠãåçšããŒã¿ããŒã¹ã«ããè¯ããã®ãšããªãŒãã³ãœãŒã¹ã«ãããã¹ãŠã®ç¡æã®ãã®ãçµã¿åããããã®ã¯äœããããŸããã§ããã
äºæ³å€ã«ãYandex ãåžœåããã¶ã£ãéè¡åž«ã®ããã«ããŠãµã®ã®ããã« ClickHouse ãåŒãåºããŸã§ã¯äœããããŸããã§ããã ãããŠããã¯äºæãã¬æ±ºæã ã£ãã®ã§ã圌ãã¯ä»ã§ãããªãïŒããšããçåãæ±ããŠããŸãããããã§ããªãã§ãã
ãã㊠2016 幎ã®å€ã«ããã«ãç§ãã¡ã¯ ClickHouse ãšã¯äœãªã®ããæ€èšãå§ããŸããã ãããŠãå Žåã«ãã£ãŠã¯ Vertica ãããé«éãªå Žåãããããšãå€æããŸããã ããŸããŸãªã¯ãšãªã§ããŸããŸãªã·ããªãªããã¹ãããŸããã ãŸããã¯ãšãªã§ããŒãã«ã XNUMX ã€ã ã䜿çšãããå Žåãã€ãŸãçµå (çµå) ããªãã£ãå ŽåãClickHouse 㯠Vertica ã® XNUMX åé«éã§ããã
å æ¥ãããŸãã«ãæ æ°ã§ã¯ãªãã£ãã®ã§ãYandexã®ãã¹ãã調ã¹ãŸããã ããã¯åãã§ããClickHouse 㯠Vertica ã® XNUMX åéãã®ã§ã圌ãã¯ããã«ã€ããŠãã話é¡ã«ããŸãã
ããããã¯ãšãªã«çµåãããå Žåããã¹ãŠãæ確ã§ã¯ãªãããšãããããŸãã ãŸããClickHouse 㯠Vertica ã® XNUMX åé ããªãå¯èœæ§ããããŸãã ãããŠããªã¯ãšã¹ããå°ãä¿®æ£ããŠæžãçŽããšããããã¯ã»ãŒåçã«ãªããŸãã æªããªãã ãããç¡æã
ãããŠãã¹ãçµæãåãåãããããããŸããŸãªè§åºŠããæ€èšããåŸãLifeStreet 㯠ClickHouse ã«è¡ããŸããã
æ°ãã€ãã°ä»å¹Žã§16幎ç®ã§ãã ããã¯ãæ³£ãå«ãã§èªåèªèº«ãåºããªããããµããã³ãé£ã¹ç¶ããããºãã«ã€ããŠã®åè«ã®ããã§ããã ããã«ã€ããŠã¯è©³ãã説æãããŠãããããã«é¢ãããããªããããŸãã
ãããã£ãŠã詳现ã«ã€ããŠã¯è©±ããŸãããçµæãšããã®æã¯è©±ããªãã£ãããã€ãã®èå³æ·±ãç¹ã«ã€ããŠã®ã¿è©±ããŸãã
çµæã¯æ¬¡ã®ãšããã§ãã
- 移è¡ãæåããXNUMX 幎以äžã«ããã£ãŠã·ã¹ãã ã¯ãã§ã«å®çšŒåç°å¢ã§çšŒåããŠããŸãã
- çç£æ§ãšæè»æ§ãåäžããŸããã 10 æ¥ãããçæéä¿åã§ãã 75 å件ã®ã¬ã³ãŒãã®ãã¡ãLifeStreet ã¯çŸåš 3 æ¥ããã XNUMX å件ã®ã¬ã³ãŒããä¿åããŠãããããã XNUMX ãæ以äžä¿åã§ããŸãã ããŒã¯æã«ã«ãŠã³ããããšãXNUMX ç§ãããæ倧 XNUMX äžä»¶ã®ã€ãã³ããçºçããŸãã XNUMX æ¥ã« XNUMX äžä»¶ãè¶ ãã SQL ã¯ãšãªããã®ã·ã¹ãã ã«å±ããŸããããã®ã»ãšãã©ã¯ããŸããŸãªããããããã®ãã®ã§ãã
- Vertica ããã ClickHouse ã«å€ãã®ãµãŒããŒã䜿çšããããšããäºå®ã«ãããããããVertica ã§ã¯ããªãé«äŸ¡ãª SAS ãã£ã¹ã¯ã䜿çšãããŠãããããããŒããŠã§ã¢ãç¯çŽãããŸããã ClickHouseã¯SATAã䜿çšããŠããŸããã ãªãïŒ Vertica ã§ã¯æ¿å ¥ãåæçã§ããããã§ãã ãŸããåæã«ã¯ããã£ã¹ã¯ã®é床ãäœäžããããªãããšãããã³ãããã¯ãŒã¯ã®é床ãäœäžããããªãããšãå¿ èŠã§ãããããªãã³ã¹ãã®ãããæäœã«ãªããŸãã ãŸããClickHouse ã§ã¯æ¿å ¥ã¯éåæã§ãã ããã«ããã€ã§ããã¹ãŠãããŒã«ã«ã«æžã蟌ãããšãã§ããè¿œå ã³ã¹ãã¯ããããŸããããã®ãããäœéãã©ã€ãã§ãã£ãŠããVertika ãããã¯ããã«éãããŒã¿ã ClickHouse ã«æ¿å ¥ã§ããŸãã ãããŠèªæžãã»ãŒåãã§ãã SATA ã§ã®èªã¿åãã¯ãRAID å ã§ããã°ããã¹ãŠååã«é«éã§ãã
- ã©ã€ã»ã³ã¹ã«ããå¶éã¯ãããŸãããã€ãŸãã3 å°ã®ãµãŒã㌠(60 å°ã®ãµãŒããŒã 20 ã€ã®ã¬ããªã«) ã«ãã 6 ãã¿ãã€ãã®ããŒã¿ãšããã¡ã¯ããšéèšã® XNUMX å 件ã®ã¬ã³ãŒãã§ãã Vertica ã§ã¯ãã®ãããªãã®ã¯ãããŸããã
次ã«ããã®äŸã®å®è·µçãªå 容ã«ç§»ããŸãã
- XNUMXã€ç®ã¯å¹ççãªã¹ããŒã ã§ãã å€ãã¯ã¹ããŒãã«äŸåããŸãã
- XNUMX ã€ç®ã¯å¹çç㪠SQL çæã§ãã
å žåç㪠OLAP ã¯ãšãªã¯éžæã§ãã äžéšã®åã¯ã°ã«ãŒãåã«äœ¿çšãããäžéšã®åã¯éèšé¢æ°ã«äœ¿çšãããŸãã ç«æ¹äœã®ã¹ã©ã€ã¹ãšããŠè¡šçŸã§ããå ŽæããããŸãã ã°ã«ãŒãå šäœã¯æ圱ãšããŠèããããšãã§ããŸãã ãããå€å€éããŒã¿åæãšåŒã°ããçç±ã§ãã
ãããŠå€ãã®å Žåãããã¯ã¹ã¿ãŒã¹ããŒã ã®åœ¢ã§ã¢ãã«åãããŸãããã®å Žåãäžå¿çãªäºå®ãšãåŽé¢ãå ç·ã«æ²¿ã£ããã®äºå®ã®ç¹åŸŽããããŸãã
ãããŠãç©ççãªãã¶ã€ã³ãã€ãŸãããŒãã«ã«ã©ã®ããã«ãã£ããããããšããç¹ã§ã¯ãéåžžã¯æ£èŠåãããè¡šçŸãè¡ãããŸãã éæ£èŠåããããšãã§ããŸããããã£ã¹ã¯ã«è² è·ãããããã¯ãšãªã§ã¯ããŸãå¹ççã§ã¯ãããŸããã ãããã£ãŠãéåžžããããã¯æ£èŠåãããè¡šçŸãã€ãŸããã¡ã¯ã ããŒãã«ãšéåžžã«å€ãã®ãã£ã¡ã³ã·ã§ã³ ããŒãã«ãäœæããŸãã
ããããClickHouseã§ã¯ããŸãæ©èœããŸããã çç±ã¯ XNUMX ã€ãããŸãã
- XNUMX ã€ç®ã¯ãClickHouse ã®çµåãããŸãåªããŠããªãããã§ããã€ãŸããçµåã¯ãããŸãããæªããã®ã§ãã æªããªãããã
- XNUMX ã€ç®ã¯ãããŒãã«ãæŽæ°ãããªãããšã§ãã éåžžãã¹ã¿ãŒåè·¯ã®åšå²ã«ãããããã®ãã¬ãŒãã§ã¯ãäœããå€æŽããå¿ èŠããããŸãã ããšãã°ã顧客åãäŒç€Ÿåãªã©ã§ãã ãããŠããã¯æ©èœããŸããã
ãããŠãClickHouseã«ã¯ããã解決ããæ¹æ³ããããŸãã XNUMXã€ã§ã:
- äžã€ç®ã¯èŸæžã®æŽ»çšã§ãã å€éšèŸæžã¯ãã¢ããããŒããªã©ã«ãããã¹ã¿ãŒ ã¹ããŒãã®åé¡ã 99% 解決ããã®ã«åœ¹ç«ã¡ãŸãã
- XNUMX ã€ç®ã¯é åã®äœ¿çšã§ãã é åã¯ãçµåãæ£èŠåã®åé¡ãåãé€ãã®ã«ã圹ç«ã¡ãŸãã
- åå ããå¿ èŠã¯ãããŸããã
- ã¢ããã°ã¬ãŒãå¯èœã 2018 幎 XNUMX æ以éãèŸæžãéšåçã«æŽæ°ãããã€ãŸãå€æŽããããšã³ããªãæŽæ°ããææžåãããŠããªãæ©äŒãåºçŸããŸãã (ããã¯ææžã«ã¯èŠã€ãããŸãã)ã å®éã«ã¯ããŒãã«ã®ãããªãã®ã§ãã
- åžžã«ã¡ã¢ãªå ã«ããããããã£ã¯ã·ã§ããªãšã®çµåã¯ãããŒãã«ããã£ã¹ã¯äžã«ããå Žåãããé«éã«åäœããŸããããã£ãã·ã¥å ã«ååšããããšã¯ãŸã äºå®ã§ã¯ãããŸãããããããããã§ã¯ãããŸããã
- çµåãå¿ èŠãããŸããã
- ããã¯ã³ã³ãã¯ã㪠1 察å€ã®è¡šçŸã§ãã
- ç§ã®æèŠã§ã¯ãé åã¯ãªã¿ã¯åãã«äœãããŠããŸãã ãããã¯ã©ã ãé¢æ°ãªã©ã§ãã
ããã¯èµ€æåçšã§ã¯ãããŸããã ããã¯éåžžã«åŒ·åãªæ©èœã§ãããå€ãã®ããšãéåžžã«ã·ã³ãã«ãã€ãšã¬ã¬ã³ããªæ¹æ³ã§è¡ãããšãã§ããŸãã
é åã解ãã®ã«åœ¹ç«ã€å žåçãªäŸã ãããã®äŸã¯åçŽãã€æ確ã§ãã
- ã¿ã°ããæ€çŽ¢ããŸãã ããã«ããã·ã¥ã¿ã°ããããããã·ã¥ã¿ã°ã§ããã€ãã®æçš¿ãèŠã€ãããå Žåã
- ããŒãšå€ã®ãã¢ã§æ€çŽ¢ããŸãã å€ãæã€å±æ§ãããã€ããããŸãã
- å¥ã®ãã®ã«å€æããå¿ èŠãããããŒã®ãªã¹ããä¿åããŸãã
ããããã¹ãŠã®ã¿ã¹ã¯ã¯é åãªãã§è§£æ±ºã§ããŸãã ã¿ã°ã¯è¡ã«å ¥ããŠæ£èŠè¡šçŸãŸãã¯å¥ã®ããŒãã«ã§éžæã§ããŸããããã®å Žåã¯çµåãè¡ãå¿ èŠããããŸãã
ClickHouse ã§ã¯ãäœãããå¿ èŠã¯ãããŸãããããã·ã¥ã¿ã°ã®æååé åãèšè¿°ããããããŒãšå€ã®ã·ã¹ãã ã®å ¥ãåæ§é ãäœæãããããã ãã§ååã§ãã
ãã¹ããããæ§é ã¯æé©ãªååã§ã¯ãªãå¯èœæ§ããããŸãã ãããã¯ãååã«å ±ééšåãšããã€ãã®é¢é£ããç¹æ§ãæ〠XNUMX ã€ã®é åã§ãã
ã¿ã°æ€çŽ¢ãç°¡åã§ãã æ©èœããã has
ãé
åã«èŠçŽ ãå«ãŸããŠããããšã確èªããŸãã çãããç§ãã¡ã®ã«ã³ãã¡ã¬ã³ã¹ã«é¢é£ãããã¹ãŠã®ãšã³ããªãèŠã€ããŸããã
subid ã«ããæ€çŽ¢ã¯å°ãè€éã§ãã ãŸãããŒã®ã€ã³ããã¯ã¹ãèŠã€ããŠããããã®ã€ã³ããã¯ã¹ãæã€èŠçŽ ãååŸããŠããã®å€ãå¿ èŠãªãã®ã§ããããšã確èªããå¿ èŠããããŸãã ãã ããéåžžã«ã·ã³ãã«ã§ã³ã³ãã¯ãã§ãã
æ£èŠè¡šçŸã XNUMX è¡ã«ãŸãšããŠæžããšããŸããäžæ Œå¥œã«ãªããŸãã ãããŠç¬¬äºã«ãXNUMX ã€ã®ã¢ã¬ã€ãããã¯ããã«é·ãåäœããŸããã
ããäžã€ã®äŸã ID ãä¿åããé
åããããŸãã ãããŠãããããååã«å€æããããšãã§ããŸãã é¢æ° arrayMap
ã ããã¯å
žåçãªã©ã ãé¢æ°ã§ãã ããã«ã©ã ãåŒãæž¡ããŸãã ãããŠãå ID ã®ååã®å€ãèŸæžããåãåºããŸãã
æ€çŽ¢ãåæ§ã«è¡ããŸãã èŠçŽ ãäžèŽãããã®ããã§ãã¯ããè¿°èªé¢æ°ãæž¡ãããŸãã
ãããã«ããåè·¯ãå€§å¹ ã«ç°¡çŽ åãããå€ãã®åé¡ã解決ãããŸãã
ããããç§ãã¡ãçŽé¢ããŠãã次ã®åé¡ã¯ãå¹ççãªã¯ãšãªãŒã§ããããšã«ã€ããŠè§ŠããŠãããããšæããŸãã
- ClickHouse ã«ã¯ã¯ãšãª ãã©ã³ããŒããããŸããã 絶察éãã
- ããã§ããè€éãªã¯ãšãªãèšç»ããå¿ èŠããããŸãã ã©ã®ãããªå Žåã«ïŒ
- ã¯ãšãªå ã«è€æ°ã®çµåãããå Žåã¯ãããããå¯éžæã§ã©ããããŸãã ãããŠãããããå®è¡ãããé åºãéèŠã§ãã
- ãã㊠XNUMX ã€ç®ã¯ããªã¯ãšã¹ããåæ£ãããå Žåã§ãã åæ£ã¯ãšãªã§ã¯ãæãå åŽã®ãµãéžæã®ã¿ãåæ£å®è¡ããããã®ä»ã¯ãã¹ãŠæ¥ç¶ãã XNUMX ã€ã®ãµãŒããŒã«æž¡ãããããã§å®è¡ãããããã§ãã ãããã£ãŠãå€æ°ã®çµå (çµå) ãå«ãåæ£ã¯ãšãªãããå Žåã¯ãé åºãéžæããå¿ èŠããããŸãã
ãŸããããåçŽãªå Žåã§ããã¹ã±ãžã¥ãŒã©ã®äœæ¥ãå®è¡ããŠã¯ãšãªãå°ãæžãçŽãå¿ èŠãããå ŽåããããŸãã
ããã«äžäŸã瀺ããŸãã å·ŠåŽã«ã¯ãäžäœ 5 ãåœã瀺ãã¯ãšãªããããŸãã ç§ã®æèŠã§ã¯ãããã«ã¯ 2,5 ç§ããããŸãã å³åŽã¯åãã¯ãšãªã§ãããå°ãæžãçŽãããŠããŸãã æååã§ã°ã«ãŒãåãã代ããã«ãã㌠(int) ã§ã°ã«ãŒãåããããã«ãªããŸããã ãããŠããã¯ããéãã§ãã ãããŠããã®çµæã«èŸæžãæ¥ç¶ããŸããã ãªã¯ãšã¹ãã«ã¯ 2,5 ç§ã§ã¯ãªã 1,5 ç§ããããŸãã ããã¯ããã
ãã£ã«ã¿ãæžãæããåæ§ã®äŸã ããã¯ãã·ã¢ãžã®èŠæã§ãã 5ç§éå®è¡ãããŸãã æååã§ã¯ãªãæ°å€ãããã·ã¢ã«é¢é£ããããŒã®ã»ãããšå床æ¯èŒããããã«æžãçŽããšãã¯ããã«é«éã«ãªããŸãã
ãã®ãããªããªãã¯ã¯ãããããããŸãã ãŸãããã§ã«é«éã«å®è¡ãããŠãããšæãããã¯ãšãªããéã«äœéã«å®è¡ãããŠãããšæãããã¯ãšãªãå€§å¹ ã«é«éåããããšãã§ããŸãã ããã«é«éã«äœæããããšãã§ããŸãã
- åæ£ã¢ãŒãã§ã®æ倧äœæ¥éã
- int ã§è¡ã£ãããã«ãæå°åã§äžŠã¹æ¿ããŸãã
- çµå (ãžã§ã€ã³) ããã£ã¯ã·ã§ããªãããå Žåã¯ãæåŸã®æ段ãšããŠããããå®è¡ããããšããå§ãããŸããæ¢ã«ããŒã¿ãå°ãªããšãéšåçã«ã°ã«ãŒãåãããŠããå ŽåãçµåæäœãŸãã¯ãã£ã¯ã·ã§ããªåŒã³åºãã®åŒã³åºãåæ°ãæžããåŠçãé«éã«ãªããŸãã ã
- ãã£ã«ã¿ãŒã®äº€æã
ç§ã玹ä»ãããã¯ããã¯ã ãã§ã¯ãªããä»ã«ããã¯ããã¯ããããŸãã ãããŠãããã¯ãã¹ãŠãã¯ãšãªã®å®è¡ãå€§å¹ ã«é«éåã§ããå ŽåããããŸãã
次ã®äŸã«é²ã¿ãŸãããã ã¢ã¡ãªã«ã®X瀟ã 圌女ã¯äœããã£ãŠããïŒ
ã¿ã¹ã¯ããããŸãã:
- åºåãã©ã³ã¶ã¯ã·ã§ã³ã®ãªãã©ã€ã³ãªã³ã¯ã
- ããŸããŸãªãã€ã³ãã£ã³ã° ã¢ãã«ãã¢ããªã³ã°ããŸãã
ã·ããªãªã¯äœã§ãã?
æ®éã®èšªåè ã¯ãããšãã°ãããŸããŸãªåºåããæã« 20 åãµã€ãã«ã¢ã¯ã»ã¹ããŸãããããã¯ããã®ãµã€ãã®ããšãèŠããŠãããããåºåãªãã§èšªåããããšããããŸãã ããã€ãã®ååãèŠãŠãã«ãŽã«å ¥ããããã«ãŽããåãåºãããããŸãã ãããŠæçµçã«ã¯äœããè²·ãããŸãã
ãã£ãšããªè³ªå: ãå¿ èŠãªå Žåãåºåè²»ã¯èª°ãæ¯æãã¹ãã§ãã?ã ã圌ã«åœ±é¿ãäžããåºåãããã°?ã ã€ãŸãããªã圌ã¯è²·ã£ãã®ãããããŠãã®äººã®ãããªäººã ã«ãè²·ã£ãŠãããã«ã¯ã©ãããã°ããã®ããšããããšã§ãã
ãã®åé¡ã解決ããã«ã¯ãWeb ãµã€ãäžã§çºçããåºæ¥äºãé©åãªæ¹æ³ã§çµã³ä»ãããã€ãŸããäœããã®æ¹æ³ã§ãããã®éã«ã€ãªãããæ§ç¯ããå¿ èŠããããŸãã ãã®åŸãåæã®ããã« DWH ã«éä¿¡ãããŸãã ãããŠããã®åæã«åºã¥ããŠã誰ã«ã©ã®ãããªåºåã衚瀺ãããã®ã¢ãã«ãæ§ç¯ããŸãã
åºåãã©ã³ã¶ã¯ã·ã§ã³ã¯ãåºåã®è¡šç€ºããå§ãŸããäœããèµ·ããããã®åŸè³Œå ¥ãè¡ãããããã«è³Œå ¥ã®äžã§è³Œå ¥ãè¡ãããäžé£ã®é¢é£ãŠãŒã¶ãŒ ã€ãã³ãã§ãã ããšãã°ããããã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ãã¢ãã€ã« ã²ãŒã ã®å Žåãéåžžãã¢ããªã±ãŒã·ã§ã³ã®ã€ã³ã¹ããŒã«ã¯ç¡æã§è¡ãããŸãããããã§äœããè¡ãå Žåãããã«ã¯ãéãå¿ èŠã«ãªãå ŽåããããŸãã ãããŠããŠãŒã¶ãŒãã¢ããªã±ãŒã·ã§ã³ã«è²»ããã»ã©ããã®äŸ¡å€ã¯é«ãŸããŸãã ãã ãããã®ããã«ã¯ãã¹ãŠãæ¥ç¶ããå¿ èŠããããŸãã
ãã€ã³ãã£ã³ã°ã¢ãã«ãå€æ°ãããŸãã
æã人æ°ã®ãããã®ã¯æ¬¡ã®ãšããã§ãã
- æåŸã®ã€ã³ã¿ã©ã¯ã·ã§ã³ãã€ã³ã¿ã©ã¯ã·ã§ã³ã¯ã¯ãªãã¯ãŸãã¯ã€ã³ãã¬ãã·ã§ã³ã®ããããã§ãã
- æåã®ã€ã³ã¿ã©ã¯ã·ã§ã³ãã€ãŸãããŠãŒã¶ãŒããµã€ãã«èªå°ããæåã®ãã®ã
- ç·åœ¢çµå - ãã¹ãŠåçã
- æžè¡°ã
- çã ã
ãããŠãããããããã¯ã©ã®ããã«ããŠæ©èœããã®ã§ãããã? ã©ã³ã¿ã€ã ãšã«ãµã³ãã©ããããŸããã Cassandra ã¯ãã©ã³ã¶ã¯ã·ã§ã³ ã¹ãã¬ãŒãžãšããŠäœ¿çšãããé¢é£ãããã¹ãŠã®ãã©ã³ã¶ã¯ã·ã§ã³ã Cassandra ã«ä¿åãããŸããã ãããŠãã©ã³ã¿ã€ã ã§äœããã®ã€ãã³ããçºçãããšãããšãã°ãããããŒãžãäœãã衚瀺ãããšãCassandra ã«å¯ŸããŠãªã¯ãšã¹ããè¡ãããŸãããã®ãããªäººããããã©ããã¯ããããŸããã 次ã«ãããã«é¢é£ãããã©ã³ã¶ã¯ã·ã§ã³ãååŸãããŸããã ãããŠã€ãªãããã§ããŸããã
幞éã«ããªã¯ãšã¹ãã«ãã©ã³ã¶ã¯ã·ã§ã³ ID ãããã°ãããã¯ç°¡åã§ãã ããããéåžžã¯éããããŸããã ãã®ãããæåŸã®ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã¹ãã¯ãªãã¯ã®ãããã©ã³ã¶ã¯ã·ã§ã³ãªã©ãèŠã€ããå¿ èŠããããŸããã
ãããŠããã€ã³ãã£ã³ã°ãæåŸã®ã¯ãªãã¯ãŸã§è¡ãããŠããéãããã¹ãŠéåžžã«ããŸãæ©èœããŸããã ãªããªãã10 ãæã®æéãèšå®ããå Žåãããšãã° 300 æ¥ããã 10 äžåã15 ãæããã XNUMX ååã®ã¯ãªãã¯ãããããã§ãã ãŸããCassandra ã§ã¯é«éã«å®è¡ããã«ã¯ãã¹ãŠãã¡ã¢ãªå ã«ããå¿ èŠããããã©ã³ã¿ã€ã ã¯è¿ éã«å¿çããå¿ èŠããããããçŽ XNUMX ïœ XNUMX å°ã®ãµãŒããŒãå¿ èŠã§ããã
ãããŠããã©ã³ã¶ã¯ã·ã§ã³ããã£ã¹ãã¬ã€ã«ãªã³ã¯ãããããšæã£ããšããããã¯ããã«ããŸãé¢çœããªãããšãããããŸããã ãªãïŒ 30 åã®ã€ãã³ããä¿åããå¿ èŠãããããšãããããŸãã ãããã£ãŠã30 åã®ãµãŒããŒãå¿ èŠã«ãªããŸãã ãããŠãããã¯ããçš®ã®å€©æåŠçãªæ°å€ã§ããããšãå€æããŸããã å®è¡æã®ãµãŒããŒã®æ°ãå€§å¹ ã«å°ãªãã«ããããããããªã³ã¯ãè¡ãããã«æ倧 500 å°ã®ãµãŒããŒãç¶æãããšããããšã¯ãããçš®ã®ééã£ãæ°åã§ãã ãããŠåœŒãã¯äœããã¹ãããèãå§ããŸããã
ãããŠãã¯ãªãã¯ããŠã¹ã«è¡ããŸããã ClickHouse ã§ãããè¡ãã«ã¯ã©ãããã°ããã§ãããã? äžèŠãããšãããã¯äžé£ã®ã¢ã³ããã¿ãŒã³ã§ããããã«èŠããŸãã
- ãã©ã³ã¶ã¯ã·ã§ã³ã¯æé·ãããŸããŸãå€ãã®ã€ãã³ãããã©ã³ã¶ã¯ã·ã§ã³ã«æ¥ç¶ããŸããã€ãŸãããã©ã³ã¶ã¯ã·ã§ã³ã¯å¯å€ã§ãããClickHouse ã¯å¯å€ãªããžã§ã¯ãã§ã¯ããŸãããŸãæ©èœããŸããã
- 蚪åè ãç§ãã¡ã蚪ããããããŒãšèšªå ID ã«ãã£ãŠãã©ã³ã¶ã¯ã·ã§ã³ãåŒãåºãå¿ èŠããããŸãã ããããã€ã³ãã¯ãšãªã§ãããClickHouse ã§ã¯ãããè¡ããŸããã éåžžãClickHouse ã«ã¯å€§èŠæš¡ãªã¹ãã£ã³ããããŸãããããã§ã¯ããã€ãã®ã¬ã³ãŒããååŸããå¿ èŠããããŸãã ãã¡ããã¢ã³ããã¿ãŒã³ã
- ããã«ããã©ã³ã¶ã¯ã·ã§ã³ã¯ json 圢åŒã§ããããæžãæããããªãã£ãã®ã§ãjson ãæ§é åãããŠããªãæ¹æ³ã§ä¿åããå¿ èŠã«å¿ããŠããããäœããåãåºããããšèããŠããŸããã ãããŠããããã¢ã³ããã¿ãŒã³ã§ãã
ã€ãŸããäžé£ã®ã¢ã³ããã¿ãŒã³ã§ãã
ããããããã«ãããããããéåžžã«ããŸãæ©èœããã·ã¹ãã ãäœãããšãã§ããŸããã
äœãè¡ãããã®ã§ããããïŒ ClickHouse ãç»å Žãããã°ãã¬ã³ãŒãã«åå²ãããŠæã蟌ãŸããŸããã ClickHouse ãããã°ãåä¿¡ããå±æ§ä»ããµãŒãã¹ãç»å ŽããŸããã ãã®åŸããšã³ããªããšã«ã蚪å ID ããšã«ããŸã åŠçãããŠããªãå¯èœæ§ã®ãããã©ã³ã¶ã¯ã·ã§ã³ãšã¹ãããã·ã§ãããã€ãŸããã§ã«æ¥ç¶ãããŠãããã©ã³ã¶ã¯ã·ã§ã³ãã€ãŸã以åã®äœæ¥ã®çµæãåãåããŸããã ç§ã¯ãã§ã«ãããããããžãã¯ãäœæããæ£ãããã©ã³ã¶ã¯ã·ã§ã³ãéžæããæ°ããã€ãã³ããæ¥ç¶ããŸããã å床ãã°ã«èšé²ãããŸããã ãã°ã¯ ClickHouse ã«æ»ããŸãããã€ãŸããClickHouse ã¯åžžã«åŸªç°ããã·ã¹ãã ã§ãã ããã«ãDWH ã«è¡ã£ãŠãããã§åæããŸããã
ãã®åœ¢ã§ã¯ããŸãããŸããããŸããã§ããã ãŸããClickHouse ã«ãšã£ãŠäœæ¥ã容æã«ããããã«ã蚪å ID ã«ãããªã¯ãšã¹ãããã£ãå Žåããããã®ãªã¯ãšã¹ãã 1 ïœ 000 ã®èšªå ID ã®ãããã¯ã«ã°ã«ãŒãåãã2 ïœ 000 人ã®ãã©ã³ã¶ã¯ã·ã§ã³ããã¹ãŠæœåºããŸããã ãããŠããã¹ãŠãããŸããããŸããã
ClickHouse ã®äžãèŠããšãããããã¹ãŠãæäŸããã¡ã€ã³ ããŒãã«ã¯ 3 ã€ã ãã§ãã
ãã°ãã¢ããããŒããããæåã®ããŒãã«ããã°ã¯ã»ãšãã©åŠçãããã«ã¢ããããŒããããŸãã
XNUMXçªç®ã®ããŒãã«ã ãããªã¢ã©ã€ãºã ãã¥ãŒãéããŠããŸã å±æ§ãç¹å®ãããŠããªãã€ãã³ããã€ãŸãç¡é¢ä¿ãªã€ãã³ãããããã®ãã°ããåãåºãããŸãã ãããŠããããªã¢ã©ã€ãºã ãã¥ãŒãéããŠããããã®ãã°ãããã©ã³ã¶ã¯ã·ã§ã³ãæœåºãããã¹ãããã·ã§ãããäœæãããŸããã ã€ãŸããç¹å¥ãªãããªã¢ã©ã€ãºã ãã¥ãŒã«ãã£ãŠã¹ãããã·ã§ãããã€ãŸããã©ã³ã¶ã¯ã·ã§ã³ã®æåŸã«èç©ãããç¶æ ãæ§ç¯ãããŸããã
SQL ã§æžãããããã¹ãã¯æ¬¡ã®ãšããã§ãã ãã®äžã®ããã€ãã®éèŠãªç¹ã«ã€ããŠã³ã¡ã³ãããããšæããŸãã
ãŸãéèŠãªããšã¯ãClickHouse ã® json ããåãšãã£ãŒã«ããæœåºã§ããããšã§ãã ã€ãŸããClickHouse ã«ã¯ json ãæäœããããã®ã¡ãœãããããã€ããããŸãã ãšãŠããšãŠãåå§çãªãã®ã§ãã
visitParamExtractInt ã䜿çšãããšãjson ããå±æ§ãæœåºã§ããŸããã€ãŸããæåã®ããããããªã¬ãŒãããŸãã ãã®ããã«ããŠããã©ã³ã¶ã¯ã·ã§ã³ ID ãŸãã¯èšªå ID ãååŸã§ããŸãã ãã®æã
次ã«ãããã§ã¯æ±ãã«ããå®äœåãã£ãŒã«ãã䜿çšãããŠããŸãã ã©ãããæå³ã§ããïŒ ããã¯ãããŒãã«ã«ãããæ¿å ¥ã§ããªãããšãæå³ããŸããã€ãŸããããã¯æ¿å ¥ããããæ¿å ¥æã«èšç®ãããŠä¿åãããŸãã 貌ãä»ãããšãã¯ãClickHouse ãäœæ¥ãè¡ããŸãã ãããŠãåŸã§å¿ èŠã«ãªããã®ã¯ãã§ã« json ããæœåºãããŠããŸãã
ãã®å Žåããããªã¢ã©ã€ãºã ãã¥ãŒã¯çã®è¡çšã§ãã ãããŠãå®è³ªçã«çã®ãã°ãå«ãæåã®ããŒãã«ããã®ãŸãŸäœ¿çšãããŸãã ãããŠåœŒã¯äœãããŠããã®ã§ããããïŒ ãŸãã䞊ã¹æ¿ããå€æŽãããŸããã€ãŸããç¹å®ã®äººã®ãã©ã³ã¶ã¯ã·ã§ã³ãããã«æœåºããå¿ èŠãããããã䞊ã¹æ¿ãã¯èšªå ID ã«ãã£ãŠè¡ãããããã«ãªããŸããã
8 çªç®ã«éèŠãªã®ã¯ãindex_granularity ã§ãã MergeTree ãèŠãããšããããšæããŸãããããã©ã«ãã®index_granularity ã¯éåžž 192 ã§ãã ããã¯äœã§ããïŒ ããã¯ã€ã³ããã¯ã¹ã®çæ§ãã©ã¡ãŒã¿ã§ãã ClickHouse ã§ã¯ã€ã³ããã¯ã¹ã¯ãŸã°ãã§ããããã¹ãŠã®ãšã³ããªã«ã€ã³ããã¯ã¹ãä»ããããšã¯ãããŸããã ãã㯠8 192 ããšã«è¡ãããŸããããã¯ã倧éã®ããŒã¿ãèšç®ããå¿ èŠãããå Žåã«ã¯é©ããŠããŸãããå°éã®å Žåã¯ãªãŒããŒãããã倧ãããã奜ãŸãããããŸããã ãŸããã€ã³ããã¯ã¹ã®ç²åºŠãå°ãããããšããªãŒããŒããããåæžãããŸãã ã¡ã¢ãªãäžè¶³ããŠããå¯èœæ§ããããããXNUMX ã€ã«æžããããšã¯ã§ããŸããã ã€ã³ããã¯ã¹ã¯åžžã«ã¡ã¢ãªã«ä¿åãããŸãã
ã¹ãããã·ã§ããã¯ãä»ã®èå³æ·±ã ClickHouse æ©èœã䜿çšããŸãã
ãŸããAggregatingMergeTreeã§ãã ãããŠãAggregatingMergeTree 㯠argMax ãä¿åããŸããã€ãŸããããã¯æåŸã®ã¿ã€ã ã¹ã¿ã³ãã«å¯Ÿå¿ãããã©ã³ã¶ã¯ã·ã§ã³ã®ç¶æ ã§ãã ãã©ã³ã¶ã¯ã·ã§ã³ã¯ç¹å®ã®èšªåè ã«å¯ŸããŠåžžã«çæãããŸãã ãããŠããã®ãã©ã³ã¶ã¯ã·ã§ã³ã®æåŸã®ç¶æ ã§ã€ãã³ããè¿œå ããæ°ããç¶æ ãã§ããŸããã åã³ClickHouseã襲ã£ãã ãããŠããã®å ·äœåããããã¥ãŒã® argMax ãéããŠãåžžã«çŸåšã®ç¶æ ãååŸã§ããŸãã
- ãã€ã³ãã£ã³ã°ã¯ã©ã³ã¿ã€ã ãããåé¢ããããŸãã
- æ¯ææ倧 3 å件ã®ãã©ã³ã¶ã¯ã·ã§ã³ãä¿åããã³åŠçãããŸãã ããã¯ãCassandra ã®å Žåãã€ãŸãäžè¬çãªãã©ã³ã¶ã¯ã·ã§ã³ ã·ã¹ãã ã®å Žåãããæ¡éãã«å€ããªããŸãã
- 2x5 ClickHouse ãµãŒããŒã®ã¯ã©ã¹ã¿ãŒã 5 ã€ã®ãµãŒããŒããããåãµãŒããŒã«ã¯ã¬ããªã«ããããŸãã ããã¯ãã¯ãªãã¯ããŒã¹ã®ã¢ããªãã¥ãŒã·ã§ã³ãè¡ãããã® Cassandra ã®å Žåãããããã«å°ãªããããã§ã¯ã€ã³ãã¬ãã·ã§ã³ããŒã¹ã§ãã ã€ãŸãããµãŒããŒã®æ°ã 30 åã«å¢ãã代ããã«ããµãŒããŒã®æ°ãæžããããšãã§ããŸããã
ãããŠæåŸã®äŸã¯éèäŒç€Ÿ Y ã§ãæ ªäŸ¡ã®å€åã®çžé¢é¢ä¿ãåæããŸããã
ãããŠããã®ä»»åã¯æ¬¡ã®ãšããã§ããã
- æ ªæ°ã¯çŽ5æ ªã§ãã
- 100 ããªç§ããšã®åŒçšç¬Šãããã£ãŠããŸãã
- ããŒã¿ã¯10幎以äžèç©ãããŠããŸãã ã©ããããäžéšã®äŒæ¥ã§ã¯ãã以äžãäžéšã®äŒæ¥ã§ã¯ãã以äžã®ããã§ãã
- åèšã§çŽ 100 åè¡ãããŸãã
ãããŠãå€åã®çžé¢é¢ä¿ãèšç®ããå¿ èŠããããŸããã
ããã§ã¯XNUMXã€ã®éæãšãã®æ ªäŸ¡ã玹ä»ããŸãã äžæ¹ãäžæããä»æ¹ãäžæããå Žåãããã¯æ£ã®çžé¢é¢ä¿ã§ããã€ãŸããäžæ¹ãäžæããä»æ¹ãäžæããŸãã ã°ã©ãã®ç«¯ã®ããã«äžæ¹ãäžæããä»æ¹ãäžéããå Žåãããã¯è² ã®çžé¢é¢ä¿ã§ããã€ãŸããäžæ¹ãäžæãããšä»æ¹ãäœäžããŸãã
ããããçžäºã®å€åãåæããããšã§ãéèåžå Žã®äºæž¬ãç«ãŠãããšãã§ããŸãã
ãããããã®ä»»åã¯é£ããã ãã®ããã«äœãè¡ãããŠããã®ã§ããããïŒ ç§ãã¡ã¯ãæéãåšåº«ãäŸ¡æ Œãå«ã 100 å件ã®ã¬ã³ãŒããæã£ãŠããŸãã æåã«äŸ¡æ Œã¢ã«ãŽãªãºã ãã runningDifference ã® 100 ååãèšç®ããå¿ èŠããããŸãã RunningDifference ã¯ãXNUMX ã€ã®æååã®å·®ãé çªã«èšç®ãã ClickHouse ã®é¢æ°ã§ãã
ãã®åŸãçžé¢é¢ä¿ãèšç®ããå¿ èŠããããŸããçžé¢é¢ä¿ã¯ãã¢ããšã«èšç®ããå¿ èŠããããŸãã 5 æ ªã®å Žåããã¢ã¯ 000 äžã§ãã ããã¯éåžžã«å€ããã€ãŸãããã®ãããªçžé¢é¢æ°ãèšç®ããã®ã«å¿ èŠãªæé㯠12,5 åã§ãã
誰ããå¿ããå ŽåãÍx ãš Íy ã¯ãã§ãã¯ã¡ã€ãã«ãªããŸãã ãµã³ããªã³ã°ã®æåŸ ã ã€ãŸããæ ¹ãšåãèšç®ããã ãã§ãªãããããã®åã®äžã®ãã 12,5 ã€ã®åãèšç®ããå¿ èŠããããŸãã 倧éã®èšç®ã 60 äžåå®è¡ããå¿ èŠããããããã«ã¯æéããšã«ã°ã«ãŒãåããå¿ èŠããããŸãã æéããããããããŸãã ãããŠãããXNUMXç§ä»¥å ã«ãããªããã°ãªããŸããã ããã¯åè«ã ã
ClickHouse ãç»å ŽãããŸã§ã¯ãããããã¹ãŠã®äœæ¥ãéåžžã«ãã£ãããšè¡ãããŠãããããå°ãªããšãäœããã®åœ¢ã§æéã確ä¿ããå¿ èŠããããŸããã
圌ãã¯ãHadoopãSparkãGreenplum ã§ãããèšç®ããããšããŸããã ãããŠãããã¯ãã¹ãŠéåžžã«æéããããããé«äŸ¡ã§ããã ã€ãŸãããªããšãèšç®ããããšã¯ã§ããŸãããããã®å Žåã¯é«äŸ¡ã§ããã
ãã®åŸãClickHouse ãç»å Žããäºæ ã¯å€§å¹ ã«æ¹åãããŸããã
çžé¢é¢ä¿ã¯å±æåã§ããªããããããŒã¿ã®å±ææ§ã«åé¡ãããããšãæãåºããŠãã ããã ããŒã¿ã®äžéšã XNUMX ã€ã®ãµãŒããŒã«é 眮ããäžéšãå¥ã®ãµãŒããŒã«é 眮ããŠèšç®ããããšã¯ã§ããŸããããã¹ãŠã®ããŒã¿ãã©ãã«ã§ãé 眮ããå¿ èŠããããŸãã
圌ãã¯äœãããã®ã§ããããïŒ æåã«ãããŒã¿ã¯ããŒã«ã©ã€ãºãããŸãã åãµãŒããŒã¯ãç¹å®ã®æ ªåŒã»ããã®äŸ¡æ Œèšå®ã«é¢ããããŒã¿ãä¿åããŸãã ãããŠãããã¯éãªããŸããã ãããã£ãŠãlogReturn ã䞊åãã€ç¬ç«ããŠèšç®ããããšãå¯èœã§ããããããŸã§ã®åŠçã¯ãã¹ãŠäžŠåãã€åæ£çã«è¡ãããŸãã
ããã§ãè¡šçŸåã倱ããã«ãããã®ããŒã¿ãåæžããããšã«ããŸããã é åã䜿çšããŠåæžããŸããã€ãŸããæéããšã«ãæ ªåŒã®é åãšäŸ¡æ Œã®é åãäœæããŸãã ãããã£ãŠãå¿ èŠãªããŒã¿å®¹éãã¯ããã«å°ãªããªããŸãã ãããŠããããã¯å°ãäœæ¥ãç°¡åã§ãã ãããã¯ã»ãŒäžŠåæäœã§ããã€ãŸããéšåçã«äžŠåã§èªã¿åãããã®åŸãµãŒããŒã«æžã蟌ã¿ãŸãã
ãã®åŸãè€è£œããããšãã§ããŸãã æåãrãã¯ããã®ããŒã¿ãè€è£œããããšãæå³ããŸãã ã€ãŸããXNUMX ã€ã®ãµãŒããŒãã¹ãŠã«åãããŒã¿ããããŸãããããã¯é åã§ãã
ãããŠãèšç®ããå¿ èŠããããã® 12,5 äžåã®çžé¢é¢ä¿ã®ã»ããããç¹å¥ãªã¹ã¯ãªããã䜿çšããŠãããã±ãŒãžãäœæã§ããŸãã ã€ãŸãã2 ãã¢ã®çžé¢é¢ä¿ãæ〠500 ã®ã¿ã¹ã¯ã§ãã ãããŠããã®ã¿ã¹ã¯ã¯ç¹å®ã® ClickHouse ãµãŒããŒäžã§èšç®ãããŸãã ããŒã¿ã¯åãã§ãããããããé çªã«èšç®ã§ããããã圌ã¯ãã¹ãŠã®ããŒã¿ãæã£ãŠããŸãã
ããäžåºŠèšããŸããšããããªæãã§ãã ãŸãããã®æ§é ã«ã¯æéãæ ªäŸ¡ãäŸ¡æ Œãªã©ã®ãã¹ãŠã®ããŒã¿ãå«ãŸããŠããŸãã 次ã«ãlogReturnãã€ãŸãåãæ§é ã®ããŒã¿ãèšç®ããŸããããäŸ¡æ Œã®ä»£ããã«ãã§ã« logReturn ãåŸãããŠããŸãã ãã®åŸããããã¯ããçŽãããŸãããã€ãŸããæ ªäŸ¡ãšäŸ¡æ Œã®æå»ãš groupArray ãååŸããŸããã è€è£œãããŸããã ãã®åŸã倧éã®ã¿ã¹ã¯ãçæãããããã ClickHouse ã«äŸçµŠããŠãã¿ã¹ã¯ãã«ãŠã³ããããããã«ããŸããã ãããŠããã¯ããŸããããŸãã
æŠå¿µå®èšŒã§ã¯ãã¿ã¹ã¯ã¯ãµãã¿ã¹ã¯ã§ãããã€ãŸããååŸãããããŒã¿ãå°ãªããªããŸããã ããããµãŒããŒã¯ãã£ãã®XNUMXå°ã
æåã® XNUMX ã€ã®æ®µéãã€ãŸã Log_return ã®èšç®ãšé åãžã®ã©ããã«ã¯çŽ XNUMX æéããããŸããã
ãããŠçžé¢é¢ä¿ã®èšç®ã«ã¯çŽ50æéããããŸãã ãããã以åã¯äœé±éãåããŠããããã50 æéã§ã¯ååã§ã¯ãããŸããã 倧æåã§ããã ãããŠãæ°ããŠã¿ããšããã®ã¯ã©ã¹ã¿ãŒã§ã¯ 70 ç§ããã XNUMX åããã¹ãŠãã«ãŠã³ããããããšã«ãªããŸãã
ããããæãéèŠãªããšã¯ããã®ã·ã¹ãã ã«ã¯å®è³ªçã«ããã«ããã¯ããªãããšãã€ãŸããã»ãŒçŽç·çã«æ¡åŒµã§ããããšã§ãã ãããŠåœŒãã¯ããã調ã¹ãŸããã ã¹ã±ãŒã«ã¢ããã«æåããŸããã
- é©åãªèšç»ã¯æåã®ååã§ãã ãããŠãé©åãªã¹ããŒã ã¯ãå¿ èŠãªãã¹ãŠã® ClickHouse ãã¯ãããžãŒã䜿çšããããšã§ãã
- Summing/AggregatingMergeTrees ã¯ãç¶æ ã¹ãããã·ã§ãããç¹å¥ãªã±ãŒã¹ãšããŠéçŽãããèæ ®ãããã§ãããã¯ãããžãŒã§ãã ãããŠãå€ãã®ããšãå€§å¹ ã«ç°¡çŽ åãããŸãã
- ãããªã¢ã©ã€ãºã ãã¥ãŒã䜿çšãããšãXNUMX ã€ã®ã€ã³ããã¯ã¹å¶éãåé¿ã§ããŸãã ããŸãã¯ã£ãããšã¯èšããªãã£ããããããŸãããããã°ãããŒããããšããçã®ãã°ã¯ XNUMX ã€ã®ã€ã³ããã¯ã¹ãæã€ããŒãã«å ã«ãããå±æ§ãã°ã¯ããŒãã«å ã«ãããŸãããã€ãŸããåãããŒã¿ã¯ãã£ã«ã¿ãªã³ã°ãããã ãã§ãã€ã³ããã¯ã¹ã¯å®å šã«åé€ãããŠããŸããããã®ä»ã åãããŒã¿ã§ããã䞊ã¹æ¿ããç°ãªãããã«èŠããŸãã ãããŠããããªã¢ã©ã€ãºã ãã¥ãŒã䜿çšãããšãå¿ èŠã«å¿ããŠããã®ãã㪠ClickHouse ã®å¶éãåé¿ã§ããŸãã
- ãã€ã³ã ã¯ãšãªã®ã€ã³ããã¯ã¹ã®ç²åºŠãæžãããŸãã
- ããŒã¿ãè³¢ãåæ£ããå¯èœãªéããµãŒããŒå ã§ããŒã¿ãããŒã«ã©ã€ãºããããã«ããŠãã ããã ãããŠãå¯èœãªéããªã¯ãšã¹ãã§ãããŒã«ãªãŒãŒã·ã§ã³ã䜿çšããããã«ããŠãã ããã
ãã®çãã¹ããŒããèŠçŽãããšãClickHouse ã¯çŸåšãåçšããŒã¿ããŒã¹ãšãªãŒãã³ãœãŒã¹ ããŒã¿ããŒã¹ã®äž¡æ¹ãã€ãŸãç¹ã«åæåéã®é åããã£ãããšå é ããŠãããšèšããŸãã 圌ã¯ãã®é¢šæ¯ã«å®ç§ã«æº¶ã蟌ãã§ããŸãã ããã«ãClickHouse ãããã° InfiniDB ã¯å¿ èŠãªããããåŸã ã«ä»ã®ãã®ãæé€ãå§ããŸãã éåžžã® SQL ãµããŒããäœæããã°ãVertika ã¯ããã«å¿ èŠãªããªãå¯èœæ§ããããŸãã 楜ãã¿ïŒ
- ãå ±åããããšãããããŸãïŒ ãšãŠãèå³æ·±ãïŒ Apache Phoenix ãšã®æ¯èŒã¯ãããŸããã?
ãããã誰ããæ¯èŒããŠããã®ãèããããšããããŸããã ç§ãã¡ãš Yandex ã¯ãããŸããŸãªããŒã¿ããŒã¹ãšã®ãã¹ãŠã® ClickHouse æ¯èŒã远跡ããããšããŠããŸãã ãªããªããçªç¶äœããClickHouseãããéãããšãå€æããå ŽåãLesha Milovidovã¯å€ç ãããšãã§ãããããã«é床ãäžãå§ããããã§ãã ãããªæ¯èŒã¯èããããšããããŸããã
-
(Aleksey Milovidov) Apache Phoenix ã¯ãHbase ãå©çšãã SQL ãšã³ãžã³ã§ãã Hbase ã¯äž»ã«ããŒãšå€ã®äœæ¥ã·ããªãªçšã§ãã åè¡ã«ã¯ãä»»æã®ååãæã€ä»»æã®æ°ã®åãååšã§ããŸãã ããã¯ãHbaseãCassandra ãªã©ã®ã·ã¹ãã ã«ã€ããŠãèšããŸãã ãããŠãããã¯ãŸãã«éãåæã¯ãšãªã§ãããéåžžã¯æ©èœããŸããã ãããã¯ãClickHouse ã®äœ¿çšçµéšããªããã°ãåé¡ãªãåäœãããšèãããããããŸããã
-
æè¬
-
ããã«ã¡ã¯ç§ã¯åæãµãã·ã¹ãã ãæã£ãŠããã®ã§ããã®ãããã¯ã«ã¯ãã§ã«éåžžã«èå³ããããŸãã ããããClickHouse ãèŠããšãClickHouse ã¯ã€ãã³ãåæã«éåžžã«é©ããŠãããå¯å€ã§ãããšæããŸãã ãããŠãå€æ°ã®å€§ããªããŒãã«ã䜿çšããŠå€§éã®ããžãã¹ ããŒã¿ãåæããå¿ èŠãããå Žåãç§ã®ç解ããéããClickHouse ã¯ç§ã«ã¯ããŸãé©ããŠããŸããã? ç¹ã«åœŒããå€ããå Žåã¯ã ããã¯æ£ããã§ããããããšãããã«åè«ã§ããäŸã¯ãããŸãã?
-
ããã¯æ£ããã§ãã ããã¯ãã»ãšãã©ã®ç¹æ®ãªåæããŒã¿ããŒã¹ã«åœãŠã¯ãŸããŸãã ãããã¯ãå€æŽå¯èœãª XNUMX ã€ä»¥äžã®å€§ããªããŒãã«ãšããã£ãããšå€åããå€ãã®å°ããªããŒãã«ããããšããäºå®ã«åãããŠèª¿æŽãããŠããŸãã ã€ãŸããClickHouse ã¯ããã¹ãŠãé 眮ããŠéåžžã«è€éãªã¯ãšãªãæ§ç¯ã§ãã Oracle ãšã¯ç°ãªããŸãã ClickHouse ãå¹æçã«äœ¿çšããã«ã¯ãClickHouse ã§é©åã«æ©èœããæ¹æ³ã§ã¹ããŒã ãæ§ç¯ããå¿ èŠããããŸãã ã€ãŸããéå°ãªæ£èŠåãé¿ããèŸæžã䜿çšããé·ããªã³ã¯ãå°ãªãããããã«åªããŸãã ãã®æ¹æ³ã§ã¹ããŒããæ§ç¯ãããšãåæ§ã®ããžãã¹ ã¿ã¹ã¯ãåŸæ¥ã®ãªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ããã ClickHouse ã§ã¯ããã«å¹ççã«è§£æ±ºã§ããŸãã
-
ãå ±åããããšãããããŸãïŒ æè¿ã®éèäºä»¶ã«ã€ããŠè³ªåããããŸãã 圌ãã¯åææ©èœãæã£ãŠããŸããã äžãäžãã®æ§åãæ¯èŒããå¿ èŠããããŸããã ãã®åæã®ããã«ç¹å¥ã«ã·ã¹ãã ãæ§ç¯ããããšèããŸããã? ããšãã°ãææ¥ããã®ããŒã¿ã«é¢ããå¥ã®ã¬ããŒããå¿ èŠãªå Žåãã¹ããŒããåæ§ç¯ããŠããŒã¿ãã¢ããããŒãããå¿ èŠããããŸãã? ã€ãŸãããªã¯ãšã¹ããååŸããããã«äœããã®ååŠçãè¡ãå¿ èŠããããŸãã?
ãã¡ãããããã¯éåžžã«ç¹æ®ãªã¿ã¹ã¯ã®ããã® ClickHouse ã®äœ¿çšã§ãã ããã¯ãããäŒçµ±çã« Hadoop å ã§è§£æ±ºã§ããå¯èœæ§ããããŸãã Hadoop ã«ãšã£ãŠãããã¯çæ³çãªã¿ã¹ã¯ã§ãã ããããHadoop ã§ã¯éåžžã«é ãã§ãã ãããŠç§ã®ç®æšã¯ãéåžžã¯ãŸã£ããç°ãªãæ段ã§è§£æ±ºãããã¿ã¹ã¯ã ClickHouse ã解決ã§ãããšåæã«ãã¯ããã«å¹ççã«å®è¡ã§ããããšãå®èšŒããããšã§ãã ç¹å®ã®ã¿ã¹ã¯ã«åãããŠèª¿æŽãããŠããŸãã åæ§ã®åé¡ãçºçããå Žåãåæ§ã®æ¹æ³ã§è§£æ±ºã§ããããšã¯æããã§ãã
ããã¯æããã ã 50æéåŠçãããšãã£ããããŸããã ããŒã¿ãããŒãããããçµæãååŸãããããã®ã¯æåããã§ãã?
ã¯ããã¯ãã
ã¯ããããããšãããããŸãã
ãã㯠3 ãµãŒã㌠ã¯ã©ã¹ã¿ãŒäžã«ãããŸãã
ããã«ã¡ã¯ïŒ ãå ±åããããšãããããŸãïŒ ã©ãããšãŠãèå³æ·±ãã§ããã æ©èœã«ã€ããŠã¯å°ã質åããŸããããå®å®æ§ã®èŠ³ç¹ããã® ClickHouse ã®äœ¿çšã«ã€ããŠè³ªåããŸãã ã€ãŸããäœããããŸãããã埩å ããå¿ èŠããããŸããã? ãã®å ŽåãClickHouse ã¯ã©ã®ããã«åäœããŸãã? ããã§ãããŸããŸã¬ããªã«ãæã£ãŠãããã§ããïŒ ããšãã°ãClickHouse ãäŸç¶ãšããŠå¶éãè¶ ããŠèœäžãããšããåé¡ãçºçããŸããã
ãã¡ãããçæ³çãªã·ã¹ãã ãªã©ãããŸããã ãããŠãClickHouse ã«ãç¬èªã®åé¡ããããŸãã ããããYandex.Metrica ãé·ãéæ©èœããŠããªããšãã話ãèããããšããããŸãã? ããããããã§ã¯ãããŸããã ClickHouse ã§ã¯ 2012 幎ãã 2013 幎ãŸã§å®å®ããŠåäœããŠããŸãã ç§ã®çµéšã«ã€ããŠãåãããšãèšããŸãã ç§ãã¡ã¯å®å šãªå€±æãçµéšããããšããããŸããã éšåçãªåé¡ãçºçããå¯èœæ§ã¯ãããŸãããããžãã¹ã«æ·±å»ãªåœ±é¿ãäžããã»ã©é倧ãªãã®ã§ã¯ãããŸããã§ããã ãããªããšã¯æ±ºããŠèµ·ãããªãã£ãã ClickHouse ã¯éåžžã«ä¿¡é Œæ§ãé«ããã©ã³ãã ã«ã¯ã©ãã·ã¥ããããšã¯ãããŸããã å¿é ããå¿ èŠã¯ãããŸããã ããã¯çã ãããã®ã§ã¯ãããŸããã ããã¯å€ãã®äŒæ¥ã«ãã£ãŠèšŒæãããŠããŸãã
ããã«ã¡ã¯ïŒ ããŒã¿ ã¹ããŒããããã«æ€èšããå¿ èŠããããšãã£ããããŸããã ãããèµ·ãã£ããã©ããªãã§ããããïŒ ç§ã®ããŒã¿ã¯ã©ãã©ãæµã蟌ãã§ããŸãã å幎ãçµã¡ããã®ãŸãŸã§ã¯ç¡çã ãšããããããŒã¿ãåã¢ããããŒãããŠäœããããå¿ èŠããããŸãã
ãã¡ãããããã¯ã·ã¹ãã ã«ãã£ãŠç°ãªããŸãã å®è³ªçã«åæ¢ããã«ãããè¡ãæ¹æ³ã¯ããã€ããããŸãã ããšãã°ãäžæã«ãããã³ã°ã§ããå Žåã¯ãç°ãªãããŒã¿æ§é ãäœæãããããªã¢ã©ã€ãºã ãã¥ãŒãäœæã§ããŸãã ã€ãŸããClickHouse ã䜿çšãããããã³ã°ãèš±å¯ãããŠããå Žåãã€ãŸããããã€ãã®ãã®ãæœåºããäž»ããŒãå€æŽããããŒãã£ã·ã§ã³ãå€æŽãããšããããªã¢ã©ã€ãºã ãã¥ãŒãäœæã§ããŸãã ããã«å€ãããŒã¿ãäžæžããããšãæ°ããããŒã¿ãèªåçã«æžã蟌ãŸããŸãã 次ã«ããããªã¢ã©ã€ãºã ãã¥ãŒã®äœ¿çšã«åãæ¿ããŠãã¬ã³ãŒããåãæ¿ããŠå€ãããŒãã«ã匷å¶çµäºããŸãã ããã¯éåžžããã³ã¹ãããã®æ¹æ³ã§ãã
ããããšãã
åºæïŒ habr.com