ããã«ã¡ã¯ïŒ æ°ãããã®ãèŠãŠã¿ãŸããã -
æ°ããããŒã¿ããŒã¹ã®ãµããŒã
ãã®ãªãªãŒã¹ã§ã¯ã次㮠XNUMX ã€ã®ããŒã¿ããŒã¹ãããŒã«ã§æ£åŒã«ãµããŒããããŸããã
ApacheHive â Hadoop ãã©ãããã©ãŒã ã«åºã¥ãããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã
ã°ãªãŒã³ãã©ã â PostgreSQL ã«åºã¥ãããŒã¿ ãŠã§ã¢ããŠã¹çšã®åæ DBMSã
Vertica â ããã°ããŒã¿åæçšã®ã«ã©ã åããŒã¿ããŒã¹ã
ã¹ããŒãã¬ãŒã¯ â ã¯ã©ãŠãããŒã¿ã¹ãã¬ãŒãžã ãªã¬ãŒã·ã§ãã« ããŒã¿ããŒã¹ã«ã€ããŠèšãã°ãSnowflake
æ¥ç¶
ããŒã¿ããŒã¹æ¥ç¶ãã€ã¢ãã° ããã¯ã¹ã«å€æŽãå ããŸãããããæ確ã§äŸ¿å©ã«ãªãããã«åªããŸããã
ãã®ã¿ãã¯ã»ãšãã©ãªãã¡ã¯ã¿ãªã³ã°ãããŠããŸãã
ãã£ãŒã«ã æ¥ç¶ã¿ã€ã 以åã¯åŒã°ããŠããŸãã URLã®çš®é¡ ãããŠããã¯äžçªäžã«ãããŸããã ãã ãããã®ãã£ãŒã«ãã®å€ã«ãã£ãŠãã®åŸã®ããã»ã¹ã決å®ããããããçŸåšã¯äžçªäžã«ãããŸãã
ãã£ãŒã«ã ããŒã¿ããŒã¹ ããŒã¿ããŒã¹ã®äžèŠ§ã衚瀺ããã«ã¯èªèšŒãå¿ èŠãªããããã°ã€ã³åãšãã¹ã¯ãŒããå ¥åããåŸã«é 眮ãããŸãã Ctrl/Cmd+ã¹ããŒã¹.
äžã€åã®æçš¿ã®ã³ã¡ã³ãã§
- ãã¹ã¯ãŒãã¯ä¿åããªãã§ãã ããã
- DataGrip ãåèµ·åããããŸã§ä¿åããŸã (以åã¯ãããããä¿åããªãããªãã·ã§ã³ã®åäœæ¹æ³ã§ãã)ã
- ã»ãã·ã§ã³ã®ããã«ä¿å: ããŒã¿ ãœãŒã¹ããåæãããŸã§ã
- æ°žç¶ããã
æ··ä¹±ãé¿ãããããã³ã³ããã¹ã ã¡ãã¥ãŒãã空ã®ãã¹ã¯ãŒããå
¥åããŠãã ããã
çµæ è©Šéšçšæ¥ç¶ ãŠã£ã³ããŠèªäœã«è¡šç€ºãããããã«ãªããäœåãªã¯ãªãã¯ããã€ã¢ãã°ã衚瀺ãããªããªããŸãã
ãã©ã€ããŒãããŠã³ããŒããããŠããªãå Žåã¯ãDataGrip ãããŠã³ããŒããææ¡ããŸãã ãåãžããã¿ã³ è©Šéšçšæ¥ç¶ ãã®å Žåã¯ãããã¯ãããããããŠãŒã¶ãŒã¯æ··ä¹±ããŸããã
ãªãã·ã§ã³
èšå®ã¯ãäžè¬ãã¿ãããããã«ç§»åãããŸãã èªã¿åãå°çšã®, èªååæ, ååŒç®¡ç.
æ°ãã:
â N ç§ããšã«ããŒãã¢ã©ã€ã ã¯ãšãªãå®è¡ããŸãã N ç§ããšã«ããŒã¿ ãœãŒã¹ãæ£ã§çªããŸãã åŒç€ŸããµããŒãããŠããªãããŒã¿ããŒã¹ã®å Žåã¯ãèªåã§ããŒãã¢ã©ã€ã ãªã¯ãšã¹ããäœæã§ããŸãã ããã¯ãã©ã€ããŒèšå®ã§è¡ãããŸãã
â èªååæ Nç§åŸ: ããã«å ¥åããç§åäœã®å€ã¯ãããŒã¿ ãœãŒã¹ããèªåçã«åæããããŸã§ã®æéã DataGrip ã«æ瀺ããŸãã
â èµ·åã¹ã¯ãªãã: ããã§ãæ¥ç¶ãäœæããããã³ã«å®è¡ãããã¯ãšãªãå
¥åã§ããŸãã æãåºããŠã¿ãŸãããã åäžæ¥ç¶
ã¢ãŒã ãæå¹ã«ãªã£ãŠããªãå Žåãæ°ããã³ã³ãœãŒã«ããšã«æ°ããæ¥ç¶ãäœæãããŸãã
ã¹ããŒã
ããªãŒã«è¡šç€ºããããªããžã§ã¯ãã®ãã£ã«ã¿ãŒã¯ããã«ç§»åããŸããã
ããã²ãŒã·ã§ã³ãšæ€çŽ¢
æè¿ã®å Žæã®ãªã¹ã
æ°ãã [æè¿ã®å Žæ] ãŠã£ã³ããŠã«ã¯ãæè¿è¡ã£ãå Žæã衚瀺ãããŸãã ãªã¹ãé
ç®ã¯ãæè¿ç·šéãŸãã¯è¡šç€ºããå°ããªã³ãŒãã®äžéšã§ãã ããã¯ãã³ã³ããã¹ãã¯èŠããŠããããã¡ã€ã«åã¯èŠããŠããªãå Žåã«äŸ¿å©ã§ãã ãã¹ãŠã®ã³ã³ãœãŒã«ã®ååã䌌ãŠãããããDataGrip ã§ã¯ãããé »ç¹ã«çºçããŸã:) ããã©ã«ãã®ããŒããŒã ã·ã§ãŒãã«ããã¯æ¬¡ã®ãšããã§ãã
Ctrl/Cmd+Shift+Eã
以åã«ãã®ããŒããŒã ã·ã§ãŒãã«ããã䜿çšããŠæè¿å€æŽããããã¡ã€ã«ã®ãªã¹ãã衚瀺ããå Žåã¯ãä»åºŠã¯ããã«ã¯ãªãã¯ããŠãã ããã Ctrl/Cmd+E.
ãã¹ã§æ€çŽ¢
ãã©ãããã©ãŒã ãããå ¥æãããäžèŠãªãªãã·ã§ã³ãåé€ããŸããã ã¢ãžã¥ãŒã« О ãããžã§ã¯ãã ä»ã§ã¯ããã©ã«ã㧠ãã¹å ã§æ€çŽ¢ DataGrip ã¯ããããå Žæãæ€çŽ¢ããŸãã æ°ããæ€çŽ¢ãšãªã¢ãè¿œå ããŸãã æ·»ä»ãã£ã¬ã¯ã㪠â [ãã¡ã€ã«] ããã«ã®ãã¡ã€ã«ãšãã©ã«ããŒã®ã¿ãå«ãŸããŸãã
ããã²ãŒã·ã§ã³çµæããã®ã¢ã¯ã·ã§ã³
ããã²ãŒã·ã§ã³ã®çµæã«ã¯ãã³ãŒããŸãã¯ããªãŒå ã®ãªããžã§ã¯ãã«é©çšãããã¢ã¯ã·ã§ã³ã衚瀺ãããããã«ãªããŸããã ããšãã°ãããŒãã«ãæ¢ããŠãããšããŸãã çµæãŠã£ã³ããŠããã§ããããšã¯æ¬¡ã®ãšããã§ãã
- DDL ã衚瀺ããŸãã Ctrl/Cmd+B.
- ãªãŒãã³ããŒã¿: F4.
- ãããŒãã«ã®å€æŽããŠã£ã³ããŠãéããŸãã Ctrl/Cmd+F6.
- å¥ã®ã³ã³ããã¹ãã§è¡šç€ºããŸãã Alt + F1 (ããšãã°ãããªãŒå ã«è¡šç€ºããŸã)ã
- äžè¬æ å ±ãåç §ããŠãã ãã: Ctrl+Q/F1.
- SQL ãçæããŸãã Ctrl/Cmd+Alt+G.
ã³ãŒãã®æäœ
ãªãŒãã³ã³ããªãŒãã§ã®èŠçŽ ã®çµå
ã®ããã« CREATE
О DROP
ãªãŒãã³ã³ããªãŒãã§ã¯ãçµã¿åããããªãã·ã§ã³ãæäŸãããŸãã
é åèªãå¿ããªãã§ãã ããã
æ°èŠæ€æ»
DataGrip ã¯ãéããŠããªãã«ãŒãœã«ã䜿çšããŠããå Žåã«èŠåã衚瀺ããŸãã
次㮠XNUMX ã€ã®ã€ã³ã¹ãã¯ã·ã§ã³ã¯ããã©ã«ãã§ã¯ç¡å¹ã«ãªã£ãŠããŸãããå¿
èŠãªå ŽåããããŸãã
ååã®ãªãåŒæ°ã䜿çšãããšãããã匷調衚瀺ãããŸãã
GOTOæã«æå¥ãèšãæ€æ»ã
ãã¡ã€ã«ã®æäœ
ããã©ã«ãã®ãããžã§ã¯ããã©ã«ããŒã®èšå®ãè¿œå ããŸããã æ°ãããããžã§ã¯ãã¯ãã®ãã©ã«ããŒã«äœæãããŸãã
ã¢ã¯ã·ã§ã³ ååãä»ããŠä¿å⊠ä»ã³ã³ãœãŒã«ã®å Žå:
- ããã©ã«ãã®ãããžã§ã¯ããã©ã«ããŒãææ¡ããŸãã
- æåŸã®éžæãæãåºããŸãã
ãã¡ã€ã«ããªãŒã«ã¢ã¯ã·ã§ã³ãè¿œå ãããŸãã ãã£ã¬ã¯ããªã®åãé¢ã: ãã©ã«ããŒã®åºå®ã解é€ããŸãã 以åã¯ããã©ã«ããŒã®åºå®ã解é€ãã (ã€ãŸãããã®ããªãŒã«ãã©ã«ããŒã衚瀺ããªã) ã«ã¯ã åé€ãš DataGrip ãå°ããŸãã: åé€ããŸããããããšãåºå®ã解é€ããŸãã? äžäŸ¿ã§ãããã«ããã£ãã§ã:)
ããŒã¿ããŒã¹ããªãŒ
ç§ãã¡ã¯ DB2 çšã«ç¬èªã®ã€ã³ããã¹ãã¯ã·ã§ã³ãäœæããŸããã ããã¯ã以åã®ããã« JDBC ãã©ã€ããŒãä»ããŠã§ã¯ãªããã¯ãšãªã䜿çšããŠããŒã¿ããŒã¹ ãªããžã§ã¯ãã«é¢ããæ å ±ãååŸããããšãæå³ããŸãã ãããã£ãŠãããªã¬ãŒãã¿ã€ããã¡ãœãããã¢ãžã¥ãŒã«ãã«ãŠã³ã¿ãŒãããŒã«ãªã©ã以åã¯ååšããªãã£ããªããžã§ã¯ããããªãŒã«è¡šç€ºãããŸããã
ããªãŒã«ã¯ã³ã³ããã¹ããä¿åãããŸããããŒã¿ ãœãŒã¹ã®ååãäžçªäžã«è¡šç€ºãããŸãã
ãµããŒããããŠããªãããŒã¿ããŒã¹ã«ã¯ã¢ã€ã³ã³ãæç»ãããŠããŸãããã®ãããªããŒã¿ããŒã¹çšã«ããŒã¿ ãœãŒã¹ãäœæããŠãã人ã¯ãããæ··ä¹±ããããšã¯ãããŸããã
ãã©ã€ããŒèšå®ã§äœ¿çšã§ããæœè±¡çãªã¢ã€ã³ã³ãæããŸããã
æ®ã
ã«ã¹ã¿ã ããŒã
DataGrip ãŠãŒã¶ãŒã¯ãåžæããé
è²ãäœæã§ããããã«ãªããŸããã æ°ããã¹ããŒã ã¯ãã»ã¯ã·ã§ã³ããã€ã³ã¹ããŒã«ããå¿
èŠããããã©ã°ã€ã³ã§ãã ãã©ã°ã€ã³ èšå®ã§ã
ç¬èªã®ããŒãã®äœææ¹æ³ã«ã€ããŠã¯ããã¡ãããèªã¿ãã ããã
ç§ãã¡ã¯èªåãã¡ã§ããã€ãã®æ°ãããã®ãäœã£ãŠã¿ãŸããã ãããã¯æ¬¡ã®ããã«ãªããŸãã
ã·ã¢ã³
ããŒã¯ããŒãã«
ããŒã¿ãšãã£ã¿
ãã£ã«ã¿ãŒã¯ã¯ãªããããŒãããã®å€ãææ¡ããŸãã
ãã¹ãŠ
詳现ã¯ãã¡ãïŒè±èªïŒ XNUMX ãæéè©ŠçšçãããŠã³ããŒã ç§ãã¡ãèªãã ãã€ãã¿ãŒ - ç§ãã¡ãèªãã ã¡ãŒã«: [ã¡ãŒã«ä¿è·]
ãã°ãã©ãã«ãŒ - èªãã ã³ã¡ã³ã âââ
ããŒã¿ã°ãªããããŒã
åºæïŒ habr.com