[B! SQL] yassan0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yassan0627 id:yassan0627

SQLã«é–¢ã™ã‚‹yassan0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (34)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã«ã¤ã„ã¦ - Leverages ãƒ‡ãƒ¼ã‚¿æˆ¦ç•¥ãƒ–ãƒã‚°
ãƒ‡ãƒ¼ã‚¿æˆ¦ç•¥å®¤ã§ä½¿ç”¨ã—ã¦ã„ã‚‹SQLã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã‚’ã”ç´¹ä»‹ã—ã¾ã™ ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚ãƒ‡ãƒ¼ã‚¿æˆ¦ç•¥å®¤ã®æ£®ä¸‹ã§ã™ã€‚ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã†éš›ã«åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Šé›¢ã›ãªã„SQLã«ã¤ã„ã¦ã€ãƒ¬ãƒãƒ¬ã‚¸ãƒ¼ã‚ºã®ãƒ‡ãƒ¼ã‚¿æˆ¦ç•¥å®¤ã§ä½œæˆãŠã‚ˆã³é‹ç”¨ã—ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã«ã¤ã„ã¦ãŠè©±ã—ã¾ã™ã€‚ ãƒ¬ãƒãƒ¬ã‚¸ãƒ¼ã‚ºã®ãƒ‡ãƒ¼ã‚¿æˆ¦ç•¥å®¤ã§ã¯ä»Šå›žã”ç´¹ä»‹ã™ã‚‹è¦ç´„ã‚’ç–å®šã—ã¦ã„ã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã®ãƒ•ã‚§ãƒ¼ã‚ºã‚„ç’°å¢ƒã«ã‚ˆã£ã¦å¤šåˆ†ã«å¤‰ã‚ã‚‹éƒ¨åˆ†ã§ã‚‚ã‚ã‚Šã¾ã™ã®ã§ã€ã¨ã‚ã‚‹ä¸€ç¤¾ã®é‹ç”¨æ–¹æ³•ã¨ã—ã¦å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ ãƒ¬ãƒãƒ¬ã‚¸ãƒ¼ã‚ºã®SQLå®Ÿè¡Œç’°å¢ƒã«ã¤ã„ã¦ Google BigQueryã‚’åˆã‚ã¨ã™ã‚‹ã‚«ãƒ©ãƒ ãƒŠãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ã€SQLã‚’ç”¨ã„ã¦ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã™ã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ãã®ãŸã‚ã€ä»Šå›žã”ç´¹ä»‹ã™ã‚‹SQLã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã«ã¯ã€RDBã«å¯¾ã™ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢é€£ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯è¦ç´„ã«å…¥ã£ã¦ã„ã¾ã›ã‚“ã€‚ ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã«ã¤ã„ã¦ ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¦ç´„ã¯
yassan0627 2023/05/31
sql

ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°

ãƒ‡ãƒ¼ã‚¿
ãƒªãƒ³ã‚¯
é«˜æ€§èƒ½åˆ†æ•£SQLã‚¨ãƒ³ã‚¸ãƒ³ã€ŒTrinoã€æœ€é€Ÿã‚¬ã‚¤ãƒ‰ - NTT Communications Engineers' Blog
ã“ã‚“ã«ã¡ã¯ã€‚ãªã‚“ã®å› æžœã‹NTTã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ºã®ã‚¨ãƒãƒ³ã‚¸ã‚§ãƒªã‚¹ãƒˆã‚’ã‚„ã£ã¦ã„ã‚‹è¥¿å¡šã§ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€NTT Communications Advent Calendar 2021 22æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ 5åˆ†ã§ã‚ã‹ã‚‹ã€ŒTrinoã€ ã€ŒTrinoã€ã¯ã€ç•°ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«å¯¾ã—ã¦ã‚‚é«˜é€Ÿã§ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ãƒ†ã‚£ãƒ–ã«åˆ†æžãŒã§ãã‚‹é«˜æ€§èƒ½åˆ†æ•£SQLã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ ä»¥ä¸‹ã®ç‰¹å¾´ã‚’æŒã£ã¦ãŠã‚Šã€ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’æ”¯ãˆã‚‹é‡è¦ãªOSS(ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢)ã®1ã¤ã§ã™ã€‚ SQL-on-Anything: Hadoopã ã‘ã§ãªãå¾“æ¥ã®RDBMS(ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹)ã‚„NoSQLã¾ã§ã€æ¨™æº–SQL(ANSI SQL)ã«æº–æ‹ ã—ãŸã‚¢ã‚¯ã‚»ã‚¹ã‚’ãƒ¯ãƒ³ã‚¹ãƒˆãƒƒãƒ—ã«æä¾› ä¸¦åˆ—å‡¦ç†ã§ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦å®¹æ˜“ã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ— ã—ã‹ã‚‚é«˜é€Ÿ(hiveã®æ•°åå€) Netflix, LinkedIn, Salesforce, Shopif
yassan0627 2021/12/24
é–‹ç™º

ãƒ‡ãƒ¼ã‚¿

presto

trino

sql
ãƒªãƒ³ã‚¯
Impala 4.0 ã¨Presto 350ã«ã‚ˆã‚‹SQLãƒ¬ã‚·ãƒ”æœ¬ã®æ¤œè¨¼ï¼ˆï¼‘ï¼‰
Distributed computing (Apache Spark, Hadoop, Kafka, â€¦) Advent Calendar 2021 23æ—¥ç›®ã§ã™ã€‚ ä»Šå¹´ã‚‚ Hue ã«ã¤ã„ã¦æ›¸ã“ã†ã‹ã¨è€ƒãˆã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ SQL(Presto)ã‚„Embulk,Digdagã‚’ä½¿ã†æ©Ÿä¼šãŒå¢—ãˆã¦ã„ã‚‹ã®ã§è¶£å‘ã‚’å¤‰ãˆã¦ã¿ã¾ã™ã€‚ Hueã«ã¤ã„ã¦èˆˆå‘³ãŒã‚ã‚‹æ–¹ã¯[å…¬å¼ãƒ–ãƒã‚°ï¼ˆæ—¥æœ¬èªžï¼‰](http://https://jp.gethue.com//posts/ â€œå…¬å¼ãƒ–ãƒã‚°ï¼ˆæ—¥æœ¬èªžï¼‰â€)ã‚’ã”è¦§ãã ã•ã„ã€‚ç¿»è¨³ã‚µãƒœã£ã¦ã¾ã™ãƒ»ãƒ»ãƒ» â€”â€”â€”â€” SQL ãƒ¬ã‚·ãƒ”æœ¬ã¨ã¯ï¼Ÿ ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ç³»ã®è‰¯æ›¸ã®ä¸€å†Šã§ã‚‚ã‚ã‚‹ã€Œãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ åˆ†æžã®ãŸã‚ã®SQL ãƒ¬ã‚·ãƒ”æœ¬ã€ã€å‡ºç‰ˆã‹ã‚‰4å¹´çµŒéŽã—ã¦ã‚‚è‰²ã‚ã›ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã“ã®æ›¸ç±ã§ã¯ã€SQLã®è¨˜è¿°æ–¹æ³•ã‹ã‚‰åˆ†æžæ‰‹æ³•ã¾ã§åºƒãæ‰±ã‚ã‚ŒãŠã‚Šã€å†™çµŒã™ã‚‹ã ã‘ã§ã‚‚å¤§ããªçŸ¥è¦‹ãŒå¾—ã‚‰ã‚Œã‚‹ã§ã—ã‚‡ã†ã€‚ä¸€æ–¹ã€æ‰±ã‚ã‚Œ
yassan0627 2021/12/24
hadoop

impala

presto

sql
ãƒªãƒ³ã‚¯
WHEREå¥ã§MySQLã®LEFT JOINãŒ "NULL"ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ã®ã¯ãªãœã§ã™ã‹?
ä»Šæ—¥ç§ã¯ã„ãã¤ã‹ã®è¤‡é›‘ãªMySQLã‚¯ã‚¨ãƒªã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸãŒã€MySQLã®LEFT JOINãŒWHEREå¥ã§å‹•ä½œã—ã¦ã„ãªã„ã“ã¨ã«æ°—ä»˜ãã¾ã—ãŸã€‚ã¤ã¾ã‚Šã€ã„ãã¤ã‹ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒè¿”ã•ã‚Œã¾ã™ãŒã€å³å´ã«ç©ºã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¯è¿”ã•ã‚Œã¾ã›ã‚“ã€‚ ãŸã¨ãˆã°ã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚ albums ; albums_rap id artist title tracks ; id artist title rank ---- -------- ---------- --------------- ; ---- --------- ----- -------------- 1 John Doe Mix CD 20 ; 3 Mark CD #7 15 2 Mark CD #7 35 ; ãã—ã¦ã€ã“ã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã¨: SELECT t1.artist as artist, t1.title as title, t1.trac
yassan0627 2020/09/29
sql
ãƒªãƒ³ã‚¯
ãƒã‚±ãƒ¢ãƒ³ã‚’é¡Œæã«ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’å®Ÿè·µã—ã¦ã¿ã‚‹ - kanayamaã®ãƒ–ãƒã‚°
@tkanayama_ã§ã™ã€‚ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ *1ã€ ã¨ã„ã†æœ¬ã‚’èªã¿ã¾ã—ãŸã€‚ã€Œãƒã‚±ãƒ¢ãƒ³ã‚’é¡Œæã«å› æžœæŽ¨è«–ã‚’å®Ÿè·µã—ã¦ã¿ã‚‹ã€ã®ã‚ˆã†ã«ã€ä»®æƒ³çš„ãªã‚¹ãƒˆãƒ¼ãƒªä¸Šã§å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸæ„Ÿã‚’å‡ºã™ã“ã¨ã«ã‚ˆã‚Šã€è‡ªåˆ†ã®è¨˜æ†¶ã«å®šç€ã•ã›ã‚‹ã“ã¨ã‚’ç‹™ã„ã¾ã™ã€‚ å‰æã¨ã—ã¦ã€ä½•ã‚’ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã™ã‚‹ã‹ã¯çŠ¶æ³ï¼ˆãƒ™ãƒ³ãƒ€ãƒ¼ãƒ•ãƒªãƒ¼ã§ã‚ã‚‹å¿…è¦ãŒã‚ã‚‹ã‹ã©ã†ã‹ã€ã©ã®ç¨‹åº¦ã®é »åº¦ã§æ›´æ–°ã•ã‚Œã‚‹ã‹ãƒ»ãƒ»ãƒ»ãªã©ï¼‰ã«ã‚ˆã£ã¦å¤§ããç•°ãªã‚‹ã®ã§ã€ä¸‹è¨˜ã§ç´¹ä»‹ã™ã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã¯å®Ÿã¯çŠ¶æ³ã«ã‚ˆã£ã¦ã¯å•é¡Œã«ãªã‚‰ãªã„ã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ã“ã®æŠ•ç¨¿ã¯ã‚ãã¾ã§ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã«å¿ å®Ÿã«å¾“ã†ã“ã¨ãŒç›®çš„ã§ã™ã€‚ www.oreilly.co.jp è¿½è¨˜ ç™»å ´äººç‰© ã‚¹ãƒˆãƒ¼ãƒªãƒ¼ ãƒ•ã‚·ã‚®ãƒ€ãƒã¸ã®å¯¾å¿œ ãƒ¤ãƒŸã‚«ãƒ©ã‚¹ã¸ã®å¯¾å¿œ ãƒ‡ã‚£ã‚°ãƒ€ã¸ã®å¯¾å¿œ èª¤ç™»éŒ²ã§ãƒã‚±ãƒ¢ãƒ³ãƒˆãƒ¬ãƒ¼ãƒŠãƒ¼ã«ãªã£ã¦ã—ã¾ã£ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®å‰Šé™¤ æœ€å¾Œã« è¬è¾ž è¿½è¨˜ ã“ã®ãƒ–ãƒã‚°ã‚’å…¬é–‹å¾Œã€ã€Œå¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ãƒãƒƒã‚¯å‘¨ã‚Šã®ãƒˆ
yassan0627 2020/07/26
sql
ãƒªãƒ³ã‚¯
The Mother of all Query Languages: SQL in Modern Times | Markus Winand
yassan0627 2019/01/08
SQL
ãƒªãƒ³ã‚¯
HeidiSQL - MariaDB/MySQL, MSSQL, PostgreSQL, SQLite and Interbase/Firebird made easy
What is HeidiSQL? HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you are connected, you can edit data and structures in these databases. Invented in 2002 by Ansgar, HeidiSQL is still a popular tool for MariaDB and M
yassan0627 2018/10/18
]

MySQL

SQL

database

PostgreSQL

MariaDB

Windows
ãƒªãƒ³ã‚¯
ãˆ?SQLã§å…¥é–€?ã™ã‚‹â€¨ Elasticsearchã¨Elastic Stack / Getting started Elastic Stack with SQL - Speaker Deck
db tech showcase 2018ã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã¯ã ã„ã¶ç…½ã‚Šæ°—å‘³ã§ã€Elastic Stackã®å…¥é–€ã®è©±ãŒãƒ¡ã‚¤ãƒ³ã§ã™ã€‚
yassan0627 2018/09/29
Elasticsearch

sql
ãƒªãƒ³ã‚¯
Visualizing SQL Joins and Building on the Classic Venn Diagrams
Get it free Products Featured Developers Product Managers IT professionals Business Teams Leadership Teams Featured Developers Product Managers IT professionals Business Teams Leadership Teams
yassan0627 2018/09/27
SQLã®JOINã®ç¨®é¡žã‚’å¯è¦–åŒ–

sql
ãƒªãƒ³ã‚¯
SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ Â· SQL style guide by Simon Holywell
æ¦‚è¦ å…¨èˆ¬ æŽ¨å¥¨ éžæŽ¨å¥¨ å‘½åè¦å‰‡ é€šå‰‡ è¡¨ åˆ— åˆ¥åã€ç›¸é–¢å ã‚¹ãƒˆã‚¢ãƒ‰ãƒ»ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ çµ±ä¸€çš„æŽ¥å°¾è¾ž å•åˆã›æ–‡ äºˆç´„èªž ç©ºç™½é¡ž ã‚¤ãƒ³ãƒ‡ãƒ³ãƒˆ æœ›ã¾ã—ã„å½¢å¼ Createæ–‡ ãƒ‡ãƒ¼ã‚¿åž‹ã®é¸æŠž ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æŒ‡å®š åˆ¶ç´„ã¨ã‚ãƒ¼ éžæŽ¨å¥¨è¨è¨ˆ ä»˜éŒ² äºˆç´„èªžãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ SQLã‚¹ã‚¿ã‚¤ãƒ«ã‚¬ã‚¤ãƒ‰ï¼ˆæ—¥æœ¬èªžè¨³ï¼‰ æ—¥æœ¬èªžè¨³ã«ã¤ã„ã¦ æ—¥æœ¬èªžè¨³ã¯èª¤è¨³ã‚„åŽŸæ–‡ã®æœ€æ–°ç‰ˆã«è¿½éšã—ã¦ã„ãªã„æã‚ŒãŒã‚ã‚Šã¾ã™ã€‚èª¤è¨³ã‚„æ”¹å–„ç‚¹ãŒã‚ã‚Œã°ã€GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã™ã‚‹ã‹ã€Twitterã§ãŠçŸ¥ã‚‰ã›ãã ã•ã„ã€‚ ç¿»è¨³: ä¹…åˆ©å²ä¹‹ @nkuritw æ¦‚è¦ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã¯åˆ©ç”¨ã®ä»–ã€forkã—ãŸã‚Šã€è‡ªåˆ†è‡ªèº«ã®ã‚‚ã®ã«æ”¹å¤‰ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§å¤§äº‹ãªã®ã¯ã‚¹ã‚¿ã‚¤ãƒ«ã‚’é¸æŠžã—ãã‚Œã‚’è¸è¥²ã™ã‚‹ã“ã¨ã§ã™ã€‚å¤‰æ›´ã®ææ¡ˆã‚„ãƒã‚°ã®ä¿®æ£ã«ã¯GitHubã®issueã¾ãŸã¯pull requestã‚’ä½¿ç”¨ã—ã¦ãã ã•ã„ã€‚ ã“ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³
yassan0627 2018/09/24
sql
ãƒªãƒ³ã‚¯
Ibis: Python Data Analysis Productivity Framework
An open source dataframe library that works with any data system Use the same API for 20+ backends Fast local dataframes with embedded DuckDB (default), Polars, or DataFusion Iterate locally and deploy remotely by changing a single line of code Compose SQL and Python dataframe code, bridging the gap between data engineering and data science Ibis: the porta ble Python dataframe library Ibis offers a
yassan0627 2018/09/20
pandasãƒ©ã‚¤ã‚¯ãªãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã€SQLã‚’ã‚µãƒãƒ¼ãƒˆã€‚BigQueryã®ä»–ã€HDFSã‚„PostgreSQLç‰ã«å¯¾å¿œ

python

sql
ãƒªãƒ³ã‚¯
INNER JOINã¨CROSS JOINã®é•ã„ - è±†ç„¡æ—¥è¨˜
ä»Šã¾ã§JOINæ§‹æ–‡ã‚’ãªã‚“ã¨ãªãã§ä½¿ã£ã¦ããŸã®ã§ã€INNER JOINã¨CROSS JOINã®é•ã„ãŒã‚ˆãã‚ã‹ã‚‰ãªã„ã§ã„ã‚‹ä»Šæ—¥ã“ã®é ƒã€‚ ã„ã¾ã•ã‚‰ãªãŒã‚‰èª¿ã¹ã¦ã¿ãŸã€‚ CROSS JOIN: ON, USING ã‚’æŒ‡å®šã—ãªã„å ´åˆã€å·¦å³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ç›´ç©ã‚’è¿”ã—ã¾ã™ã€‚ ã¤ã¾ã‚Šã€å·¦å³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãã‚Œãžã‚Œ2è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã€3è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹å ´åˆã€çµæžœã¯å…¨ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã®çµ„åˆã›ã«ãªã‚Šåˆè¨ˆ 2x3=6 è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãªã‚Šã¾ã™ã€‚ PostgreSQL ã‚„ MySQL ã§ã¯ ON, USING ã‚’æŒ‡å®šã™ã‚‹ã¨ INNER JOIN ã¨ç‰ä¾¡ã«ãªã‚Šã¾ã™ã€‚ SELECT * FROM table1 CROSS JOIN table2 ã¯æ¬¡ã® SQL æ–‡ã¨ç‰ä¾¡ã§ã™ã€‚ SELECT * FROM table1, table2 ã¾ãŸã€PostgreSQL, MySQL ã§ã¯ SELECT * FROM table1 CR
yassan0627 2018/05/21
SQL

DBMS

db
ãƒªãƒ³ã‚¯
SQL Pivot in all databases: MySQL, MariaDB, SQLite, PostgreSQL, Oracle, â€¦
Pivoting data is a rather common probl em that comes in many different flavors. At its heart, the requirement is to transpose data from multiple rows into columns of a single row. This requirement is particularity common in a reporting context. The following explanation is therefore based on a query that reports monthly revenues: SELECT EXTRACT(YEAR FROM invoice_date) year , EXTRACT(MONTH FROM invo
yassan0627 2018/02/06
SQL
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
yassan0627 2018/01/26
sql
ãƒªãƒ³ã‚¯
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
yassan0627 2017/06/27
ã‚ã¨ã§èªã‚€

DB

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

sql
ãƒªãƒ³ã‚¯
CSV ã« SQL ã§ãŠæ‰‹è»½ã«å•ã„åˆã‚ã›ãŸã„ - 2016 å¹´ã€å†¬ï¼ˆJOIN ãªã©ã‚‚äº¤ãˆã¤ã¤ï¼‰
ãŠæ‰‹å…ƒã® CSV ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ‰‹è»½ã«åŠ å·¥ã—ã‚ˆã†ã¨æ€ã£ãŸå ´åˆã€EXCEL ç‰ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å–ã‚Šè¾¼ã‚“ã§åˆ©ç”¨ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ã‹ã¨æ€ã„ã¾ã™ã€‚ ã¾ãã€ã»ã¨ã‚“ã©ã®å ´åˆã¯ãã‚Œã§ååˆ†ãªã®ã§ã™ãŒã€‚ ã€Œ65,536 è¡Œã¾ã§ã—ã‹æ‰±ãˆãªã„å¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’è€ƒæ…®ã—ãªãã¦ã¯ã„ã‘ãªã„ç’°å¢ƒãªã®ã§ã€ãã‚‚ãã‚‚ EXCEL ã«å–ã‚Šè¾¼ã‚€ç‚ºã®ãƒ‡ãƒ¼ã‚¿ã‚’ CSV ã‹ã‚‰å¿…è¦ãªåˆ†ã ã‘æŠ½å‡ºã—ãŸã„ã€ ã§ã™ã¨ã‹ã€ ã€Œã“ã£ã¡ã¨ã‚ã£ã¡ã® CSV ã‚’çµåˆã—ãŸçµæžœã‚’åŠ å·¥ã—ã¦å‡ºåŠ›ã—ãŸã„ã€ ã§ã™ã¨ã‹ã€ ã€Œã¦ã‚†ã†ã‹ã€ ç›´æŽ¥ CSV ã« SQL ã§å•ã„åˆã‚ã›ãŸã„ã‚“ã˜ã‚ƒãƒ¼ã€ ã¿ãŸã„ãªæ¬²æ±‚ãŒã€ã“ã®è¨˜äº‹ã‚’é–‹ã„ãŸã‚ˆã†ãªæ–¹ã«ã¯ç¨€ã«è‰¯ãã‚ã‚‹ã®ã ã¨æ€ã„ã¾ã™ã€‚ ãã“ã§ã€ä»Šå›žã¯ CSV ã« SQL ã§å•ã„åˆã‚ã›ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€JOIN ç‰ã‚‚è€ƒæ…®ã—ã¤ã¤ã€ãªã‚‹ã¹ãè‰²ã€…ãªã‚±ãƒ¼ã‚¹ã‚’è¦‹ãŸä¸Šã§ã€æœ€å¾Œã«ç°¡å˜ãªæ¯”è¼ƒã‚’ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã¾ãŸã€GUI ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ãŸæ–¹æ³•ã‚‚ã€å°‘ã—ã§ã™
yassan0627 2017/06/14
CSV

SQL

ãƒ‡ãƒ¼ã‚¿

Apache Drill
ãƒªãƒ³ã‚¯
SQLã§åŸºæœ¬ã®ãƒ‡ãƒ¼ã‚¿è§£æžã«æŒ‘æˆ¦ã™ã‚‹
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
yassan0627 2017/05/27
SQL

ãƒ‡ãƒ¼ã‚¿
ãƒªãƒ³ã‚¯
HAWQ ã‚’ CDH ã§å‹•ã‹ã™ - Qiita
HAWQã¨ã¯ HAWQã¯PivotalãŒé–‹ç™ºã—ãŸHadoopä¸Šã§å‹•ä½œã™ã‚‹SQLå®Ÿè¡Œã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ ç¾åœ¨ã¯Apacheã«å¯„è´ˆã•ã‚Œã€Apache HAWQã¨ã—ã¦å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ HAWQã«è¿‘ã„ä½ç½®ä»˜ã‘ã®ã‚‚ã®ã«ã¯ã€ClouderaãŒä¸»å°Žã™ã‚‹ImpalaãŒã‚ã‚Šã¾ã™ã€‚ HAWQã®ä¸èº«ã¯PostgreSQLã‚’ãƒ™ãƒ¼ã‚¹ã«åˆ†æ•£ç’°å¢ƒã«å¯¾å¿œã—ãŸGreenplumã‚’Hadoopã«å¯¾å¿œã—ãŸã‚‚ã®ã¨è€ƒãˆã‚Œã°ã‚ˆã„ã¨æ€ã„ã¾ã™ã€‚ PostgreSQLã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ã¦ã„ã‚‹ã“ã¨ã‹ã‚‰ã€æ•°ã‚ã‚‹SQL on Hadoopã®ä¸ã§ã‚‚SQLã¸ã®æº–æ‹ ãƒ¬ãƒ™ãƒ«ãŒé«˜ã„ã“ã¨ãŒç‰¹å¾´ã«ãªã£ã¦ã„ã¾ã™ã€‚ è©³ç´°ã¯Enterprise SQL on Hadoop with Pivotal HDBãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ Pivotalã¨ODPi ODPiã¯Hadoopã®ç›¸äº’é‹ç”¨æ€§ã‚’ç›®çš„ã¨ã—ã¦Hortonworksã€Pivotalã‚’ä¸å¿ƒã«è¨ç«‹ã•ã‚ŒãŸå›£ä½“ã§ã™ã€‚ Hadoo
yassan0627 2017/03/30
HAWQï¼ãƒ›ãƒ¼ã‚¯ã¨å‘¼ã¶ã€‚SQLã¸ã®æº–æ‹ ãƒ¬ãƒ™ãƒ«ãŒé«˜ã„ã€‚Impalaã¿ãŸã„ãªã‚‚ã®ã€‚

hadoop

HDP

Apache HAWQ

SQL
ãƒªãƒ³ã‚¯
GitHub - xo/usql: Universal command-line interface for SQL databases
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yassan0627 2017/03/03
ãƒã‚¤ãƒŠãƒª1å€‹ã§PostgreSQL,MySQL,Oracle,SQLite,MSSQL Severã«ç¹‹ã’ã‚‰ã‚Œã‚‹CLIã‚³ãƒžãƒ³ãƒ‰

MySQL

PostgreSQL

SQL
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®SQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ/ERå›³ä½œæˆã‚½ãƒ•ãƒˆ (æ¾åŽŸæ£å’Œ)
ç‰¹å¾´ãƒ»æ©Ÿèƒ½ æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶š Oracle Database ã¸ã¯OCIæŽ¥ç¶šï¼ˆã‚ªãƒ©ã‚¯ãƒ«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆçµŒç”±ï¼‰ã€ç›´æŽ¥æŽ¥ç¶šï¼ˆã‚ªãƒ©ã‚¯ãƒ«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆä¸è¦ï¼‰ã§æŽ¥ç¶šå‡ºæ¥ã¾ã™ã€‚ PostgreSQL, MySQLã¸ã¯ç›´æŽ¥æŽ¥ç¶šï¼ˆã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªä¸è¦ï¼‰ã§æŽ¥ç¶šå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Server ã¸ã¯ NativeClient çµŒç”±ã§æŽ¥ç¶šã§ãã¾ã™ã€‚ ãã‚Œä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã¯ADO(OLE DB)ã¾ãŸã¯ã€ODBCã§æŽ¥ç¶šå‡ºæ¥ã¾ã™ã€‚ SQLå…¥åŠ›æ”¯æ´æ©Ÿèƒ½ Ctrl+Spaceã§SQLæ–‡ã‚’è§£æžã—ãƒ†ãƒ¼ãƒ–ãƒ«åã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚«ãƒ©ãƒ åã®å…¥åŠ›è£œå®ŒãŒè¡Œãˆã¾ã™ã€‚ å…±é€šè¡¨å¼ã‚„å‰¯ç…§ä¼šã‚‚è§£æžã™ã‚‹å¼·åŠ›ãªæ©Ÿèƒ½ã§ã™ã€‚ GUIã§ã®ã‚¯ã‚¨ãƒªãƒ¼ã®è¨è¨ˆã¨åˆ†æžæ©Ÿèƒ½ GUIã‚’ä½¿ã„ã‚¯ã‚¨ãƒªãƒ¼ã®è¨è¨ˆã¨åˆ†æžã‚’ä½¿ã£ã¦ã‚¯ã‚¨ãƒªãƒ¼ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ å®Ÿè¡Œè¨ˆç”»å–å¾—æ©Ÿèƒ½ RDBMSãŒSQLã‚’å®Ÿè¡Œã™ã‚‹éš›ã®å®Ÿè¡Œè¨ˆç”»ï¼ˆã‚¢ã‚¯ã‚»ã‚¹ãƒ—ãƒ©ãƒ³ï¼‰ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚
yassan0627 2017/02/08
sql

DB
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸