[B! sql] s-fengã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

s-feng id:s-feng

sqlã«é–¢ã™ã‚‹s-fengã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (28)

${{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}}

GA4ç”¨ã®BigQuery ã‚¯ã‚¨ãƒªé›†
æœ¬ãƒšãƒ¼ã‚¸ã¯SQLã‚’è¦šãˆã‚‹ã“ã¨ã‚’ç›®çš„ã«ã—ãŸãƒšãƒ¼ã‚¸ã§ã¯ãªãã€SQLã‚’ä½¿ã£ã¦GA4ã®BigQueryã‹ã‚‰ã‚ˆãä½¿ã„ãã†ãªSQLã‚’ã¾ã¨ã‚ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚å¯¾è±¡ã¯ä»Šã¾ã§SQLã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’ã ã—ãŸäº‹ãŒç„¡ã„æ–¹ã€æ˜”ä¸€åº¦è©¦ã—ã¦æŒ«æŠ˜ã‚ã‚‹ã„ã¯ã©ã†ã™ã‚Œã°ã‚ˆã„ã‹åˆ†ã‹ã‚‰ãªããªã£ã¦ã—ã¾ã£ãŸæ–¹ãŒå¯¾è±¡ã§ã™ã€‚ãã®ãŸã‚ã€Œã¨ã‚Šã‚ãˆãšä½¿ã£ã¦ã¿ã‚‹ã€äº‹ã‚’æ„è˜ã—ã¦ãŠã‚Šã¾ã™ã€‚å¿…è¦ãªé™ã‚Šã‚³ãƒ¡ãƒ³ãƒˆã‚’å…¥ã‚Œã¦ã€ã‚ã‹ã‚Šã‚„ã™ã•å„ªå…ˆã®è¨˜è¿°ã¨ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚å¿…ãšã—ã‚‚åŠ¹çŽ‡çš„æ›¸ãæ–¹ã§ã¯ç„¡ã„ã“ã¨ã‚’ã”äº†æ‰¿ä¸‹ã•ã„ã€‚ã¾ãŸæœ¬SQLã®å†…å®¹ç‰ã«é–¢ã—ã¦ã¯ã‚µãƒãƒ¼ãƒˆå¯¾è±¡å¤–ã¨ãªã‚Šã¾ã™ã®ã§ã€è‡ªå·±è²¬ä»»ã§ã”åˆ©ç”¨ãã ã•ã„ã€‚ ä½œæˆã”å”åŠ›ï¼š@macchaiceãƒ»@kirin0890ãƒ»ä»–çš†æ§˜ï¼ˆæ„Ÿè¬ï¼ï¼‰ åˆ©ç”¨å‰ã®ç¢ºèªäº‹é … è‡ªåˆ†ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã™ã‚‹ ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹å ´åˆ fromã®éƒ¨åˆ†ã¯ä»¥ä¸‹ã®é€šã‚Šã¨ãªã‚Šã¾ã™ã€‚ä¿å˜ãƒ‡ãƒ¼ã‚¿ã”ã¨ã«å¤‰ã‚ã‚‹ã®ã§ã€å¿…ãšè‡ªç¤¾ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆIDã«
s-feng 2024/07/16
Google

accessAnalysis

sql
ãƒªãƒ³ã‚¯
GitHub - PRQL/prql: PRQL is a modern language for transforming data â€” a simple, powerful, pipelined SQL replacement
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
s-feng 2022/09/24
data

analysis

program

sql

module
ãƒªãƒ³ã‚¯
ã€Žãƒ‡ãƒ¼ã‚¿åˆ†æžã®ãŸã‚ã®SQLå‹‰å¼·ä¼šã€œåˆç´šç·¨ã€œã€è³‡æ–™å…¬é–‹ï½œé«˜æ©‹ å…‰ | è‘—æ›¸ã€Žãƒ‡ãƒ¼ã‚¿åˆ†æžåŠ›ã‚’é«˜ã‚ã‚‹ ãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ã‚½ãƒ³ã®ãŸã‚ã®SQLå…¥é–€ã€
ã“ã®æœ¬ã§ã¯ã€ç„¡æ–™ã§å…¬é–‹ã—ã¦ã„ã‚‹noteã®å†…å®¹ã‚’ã•ã‚‰ã«ä¸å¯§ã«åˆ†ã‹ã‚Šã‚„ã™ãã€ä½“ç³»åŒ–ã•ã›ã¦ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã—ãŸå†…å®¹ã¨ãªã£ã¦ã„ã¾ã™ã€‚ noteã®å†…å®¹ã‚’ç«‹ã¡èªã¿ã ã¨æ€ã£ã¦ã‚‚ã‚‰ã„ã€ã‚ˆã‚Šä¸å¯§ã«å¦ã³ãŸã„å ´åˆã¯æ˜¯éžæ›¸ç±ã‚’èªã‚“ã§ã‚‚ã‚‰ãˆã‚‹ã¨å¬‰ã—ã„ã§ã™mm ã“ã‚Œã‹ã‚‰SQLã‚’å¦ã³ãŸã„ã¨æ€ã£ã¦ã„ã‚‹æ–¹å‘ã‘ã«ä½œæˆã—ãŸSQLå‹‰å¼·ä¼šã®è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã™ï¼(ä»¥ä¸‹ã®æ–¹å‘ã‘ã®å‹‰å¼·ä¼šè³‡æ–™ã§ã™) SQLã‚’ã“ã‚Œã‹ã‚‰å¦ã³ãŸã„äºº ä»•äº‹ã§SQLã‚’è§¦ã‚Šå§‹ã‚ãŸã‘ã©ã‚¤ãƒžã‚¤ãƒã‚ˆãã‚ã‹ã‚‰ãªã„äºº ãƒ‡ãƒ¼ã‚¿é›†è¨ˆã‚„ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ã‚¨ã‚¯ã‚»ãƒ«ä½¿ã£ã¦ã‚„ã£ã¦ã‚‹äºº è³‡æ–™ã“ã¡ã‚‰ã‹ã‚‰æœ€æ–°ã®è³‡æ–™ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ä¸‹ã•ã„ã€‚ (â€»ã€ŒSource code (zip)ã€ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ä¸‹ã•ã„) è³‡æ–™ã®æ§‹æˆã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ docs PDFè³‡æ–™ æ¼”ç¿’å•é¡Œãªã©å«ã‚ã¦å…¨éƒ¨ã§ç´„200ãƒšãƒ¼ã‚¸ãã‚‰ã„ã‚ã‚Šã¾ã™ data ãƒãƒ³ã‚ºã‚ªãƒ³ç”¨ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ csvãƒ•ã‚¡ã‚¤ãƒ«3ã¤ script ãƒãƒ³ã‚ºã‚ªãƒ³ç”¨ãƒ†ã‚¹ãƒˆãƒ‡
s-feng 2022/01/18
SQL

study

consolidation

presentation

data

analysis

tutorial
ãƒªãƒ³ã‚¯
https://dev.classmethod.jp/articles/bigquery-create-table-by-ddl/
s-feng 2021/12/08
create table / partition æŒ‡å®šãªã©ã‚‚

BigQuery

sql
ãƒªãƒ³ã‚¯
BigQueryã§Previewã«ãªã£ãŸPIVOTã¨UNPIVOTã‚’è©¦ã™ | DevelopersIO
ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹äº‹æ¥æœ¬éƒ¨ã€æ± ç”°ã§ã™ã€‚ 2021/05/10ã®ãƒªãƒªãƒ¼ã‚¹ã§BigQueryã§PIVOTã¨UNPIVOTãŒPreviewï¼ˆåŸ·ç†æ™‚ç‚¹ï¼‰ã¨ãªã‚Šã¾ã—ãŸã®ã§ã€ å‹•ã‹ã—ã¦ã¿ã¾ã—ãŸã€‚ ã€ Release notes ã€‘ ä»¥å‰ã®ãƒ–ãƒã‚° ã§ã¯SQLã§PIVOTã§ããªã‹ã£ãŸã®ã§ã€pandasã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸã€‚ ï¼ˆ2021/07/20è¿½è¨˜ï¼‰ 07/19ã®ãƒªãƒªãƒ¼ã‚¹ ã§ generally availableï¼ˆGAï¼‰ ã«ãªã‚Šã¾ã—ãŸã€‚ æŽ²è¼‰ã®SQLã¯ãã®ã¾ã¾ã§å‹•ãã“ã¨ã‚’ç¢ºèªæ¸ˆã¿ã§ã™ã€‚ PIVOT PIVOTã‚’ä½¿ã£ã¦ã¿ã¾ã™ã€‚ ã€ PIVOT operator ã€‘ã€€â€»åŸ·ç†æ™‚ç‚¹ã§ã¯ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¯è‹±èªžã®ã¿ å¯¾è±¡ã¯ BigQuery ã®ä¸€èˆ¬å…¬é–‹ãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆ ã‹ã‚‰å‡ºç”Ÿãƒ‡ãƒ¼ã‚¿ã® natality ã‚µãƒ³ãƒ—ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã™ã€‚ ã¾ãšã¯æ™®é€šã«å¹´ãƒ»æœˆãƒ»æ€§åˆ¥ã§GROUP BYã—ã¦ã€æ–°ç”Ÿå…ã®å¹³å‡ä½“é‡ã‚’è¦‹ã¦ã¿ã¾ã™ã€‚ ï¼ˆä»Šå›žã¯PIVO
s-feng 2021/12/07
sql

data

analysis

tips
ãƒªãƒ³ã‚¯
GitHub - kayak/pypika: PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
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
s-feng 2021/10/29
python

sql
ãƒªãƒ³ã‚¯
BigQueryã§TIMESTAMPã‚’ï¼•åˆ†å˜ä½ã§ä¸¸ã‚ã‚‹ - Qiita
timestampã‚’5åˆ†å˜ä½ã«ä¸¸ã‚ã‚‹ ä¾‹ 2018-04-07 03:17:42 â†’ 2018-04-07 03:15:00 SQL SELECT my_timestamp AS org_timestamp, TIMESTAMP_TRUNC(TIMESTAMP_SUB(my_timestamp, INTERVAL MOD(EXTRACT(MINUTE from my_timestamp), 5) MINUTE) ,MINUTE) AS rounded_timestamp FROM `table` MOD(EXTRACT(MINUTE from my_timestamp), 5) â†’ã€€åˆ†ã‚’æŠœãå–ã‚Šã€5ã§å‰²ã£ãŸæ•° TIMESTAMP_SUB(my_timestamp, INTERVAL N MINUTE) â†’ ${N}åˆ†å‰ã€‚ã¤ã¾ã‚Šã“ã‚Œã§ã€Œ5åˆ†ã§å‰²ã£ãŸã‚ã¾ã‚Šã®æ•°ã€åˆ†å‰ã®TIMESTAMPã«ãªã‚‹
s-feng 2021/05/12
sql

BigQuery

tips
ãƒªãƒ³ã‚¯
Introducing JinjaSQL â€” Generate SQL Using Jinja Templates
s-feng 2020/08/04
python

sql
ãƒªãƒ³ã‚¯
Advanced SQL Templates In Python with JinjaSql
In A Simple Approach To Templated SQL Queries In Python, I introduced the basics of SQL templates in Python using JinjaSql. This post further demonstrates the power of Jinja2 within JinjaSql templates using presets, loops, and custom functions. Letâ€™s consider an everyday use case when we have a table with some dimensions and some numerical values, and we want to find some metrics for a given dimen
s-feng 2020/07/22
python

sql

database

program
ãƒªãƒ³ã‚¯
Djangoã®ORMã‚’ä½¿ã‚ãªã„ã§ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³• - utamaroâ€™s blog
ORMï¼ˆobject relational mapperï¼‰ã‚’ä½¿ã†ã¹ãã‹ã€ä½¿ã‚ã–ã‚‹ã¹ãã‹ã®è°è«–ã‚’æ™‚ã€…ç›®ã«ã—ã¾ã™ã€‚ Author.objects.all()â†ã“ã†ã„ã†ã‚„ã¤ã§ã™ã€‚ ä»Šå›žã¯ã€Djangoã§ORMã‚’ä½¿ã‚ãšã«ã‚¯ã‚¨ãƒªã‚’æ›¸ã„ã¦DBã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚¯ã‚¨ãƒªã®ç”Ÿæˆã«ã¯jinjasqlã¨ã„ã†pythonã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯â†“ã®ã‚ˆã†ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ pip install jinjasql jinjasqlã¯jinja2ã¨ã„ã†ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ³ã‚’åŸºã«ã—ã¦ã„ã‚‹ã®ã§ã€æŸ”è»Ÿã«ã‚¯ã‚¨ãƒªã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã™ã€‚ github.com ç´¹ä»‹ ã¾ãšã¯Modelã«ã¤ã„ã¦ã§ã™ã€‚ class Data(models.Model): title = models.TextField(max_length=400) is_deleted = models.BooleanF
s-feng 2020/07/20
SQLã‚’ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å‹•çš„ã«æ¸¡ã™ã¨ãã€‚jinjasqlã‚’ä½¿ã†æ–¹æ³•ãŒã‚ã‚‹ã€‚

python

sql

template
ãƒªãƒ³ã‚¯
SQLã§ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚’ä½¿ã†æ–¹æ³•
s-feng 2020/05/29
exploratory

sql

data

analysis

tutorial
ãƒªãƒ³ã‚¯
Splitting array/string into rows in Amazon Redshift or MySQL
We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they come to us with SQL question - that we thought would be interesting to share with others! Today, one of our customers came to us with a question - They were having probl ems unnesting a string/array into rows in Amazon Redshift. Question - Splitting comma-delimited string into rows in Redshift Suppose
s-feng 2019/01/08
å€¤ã‚’ã‚¹ãƒ—ãƒªãƒƒãƒˆã—ã¦ã€ç¸¦æŒã¡ã«å¤‰ãˆã‚‹æ–¹æ³•

AWS

sql

tips
ãƒªãƒ³ã‚¯
SQL ã¨ Pandas ã®å¯¾å¿œè¡¨ - Qiita
ãƒˆãƒ”ãƒƒã‚¯ SQL ã®ã‚¯ã‚¨ãƒªã¨ã€Pandas ã®ãƒ¡ã‚½ãƒƒãƒ‰ã®å¯¾å¿œè¡¨ã‚’ä½œæˆã™ã‚‹ã€‚ SQL å‹‰å¼·ä¸ã®ãŸã‚ã€å‚™å¿˜éŒ²ä»£ã‚ã‚Šã«ç®‡æ¡æ›¸ãï¼ˆæ®´ã‚Šæ›¸ãï¼‰ã§æ›¸ã„ã¦ã„ãã€‚ Udemy ã®ã“ã¡ã‚‰ã®ã‚³ãƒ¼ã‚¹ã§å‹‰å¼·ã—ã¦ã„ã¾ã—ãŸã€‚ DBã‚„ãƒ†ãƒ¼ãƒ–ãƒ«è‡ªä½“ã®æ›´æ–°ãƒ»æ“ä½œã«é–¢ã™ã‚‹ã‚‚ã®ã¯ã“ã¡ã‚‰ã«ã¾ã¨ã‚ã¦ã„ã‚‹ã€‚ï¼ˆSQL ã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãæ•£ã‚‰ã‹ã—ã¦ã„ã‚‹ã ã‘ï¼‰ é †åº è¨˜è¿°é †åº select from joinç³»(+on) where group by having order by limit å®Ÿè¡Œé †åº(â€») from joinç³»(+on) where group by select having order by limit (â€»)è¿½è¨˜ @nora1962jp ã•ã‚“ã‹ã‚‰ã”æŒ‡æ‘˜ã‚’ã„ãŸã ãã¾ã—ãŸã®ã§ã€ã‚³ãƒ¡ãƒ³ãƒˆå†…å®¹ã‚’è¿½è¨˜ã—ã¾ã™ã€‚ å®Ÿè¡Œé †åº from joinç³»(+on) where SQLã«ã¤ã„ã¦ãªã‚‰å®Ÿè¡Œé †åºã¯onã¨whereã®é †åºã¯onãŒå…ˆ
s-feng 2018/11/12
sql

python

analysis

module

consolidation

tutorial
ãƒªãƒ³ã‚¯
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. ã‚¸ãƒ§ã‚¤ãƒ³ã™ã‚‹ ä¸ç‰å·
s-feng 2018/02/16
JSONã«æ ¼ç´ã•ã‚ŒãŸå€¤ã‚’SQLã§ç¸¦å±•é–‹ã™ã‚‹æ–¹æ³•

tips

Redshift

sql

tutorial

database
ãƒªãƒ³ã‚¯
Learn GraphQL Fundamentals with Fullstack Tutorial
GraphQL is a new API standard that provides a more efficient, powerful and flexible alternative to REST. It was developed and open-sourced by Facebook and is now maintained by a large community of companies and individuals from all over the world. APIs have become ubiquitous components of software infrastructures. In short, an API defines how a client can load data from a server. At its core, Grap
s-feng 2017/08/18
database

sql

graph

network

program

tutorial

movie
ãƒªãƒ³ã‚¯
ãƒžãƒ¼ã‚±ã‚¿ãƒ¼ã‚‚ã‚¯ã‚¨ãƒªè¨€èªžã‚’ã‚„ã‚Šã¾ã—ã‚‡ã†ï¼2017åˆå¤ ã€Œãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQLãƒ¬ã‚·ãƒ”ã€ - MM-LAB NEWS
ä»Šå›žã¯ä»¥ä¸‹ã®æœ¬ã®ç´¹ä»‹ã‚’ã„ãŸã—ã¾ã™ã€‚ åŠ åµœ é•·é–€ ç”°å®® ç›´äºº ä¸¸å±± å¼˜è©© ãƒžã‚¤ãƒŠãƒ“å‡ºç‰ˆ 2017-03-27 ã€Œãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®ã€ã¨æã‹ã‚Œã¦ã„ã‚‹é€šã‚Šã€æ–‡ä¸ã¯å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’æƒ³å®šã—ãŸSQLæ–‡ãŒä¸¦ã³ã¾ã™ã€‚ã“ã®ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ãªæ™‚ä»£ã€è‰²ã‚“ãªSQL æœ¬ãŒå‡ºç‰ˆã•ã‚Œã¦ã„ã¾ã™ãŒã€ã“ã“ã¾ã§å®Ÿç”¨çš„ã§ã€ã‹ã¤ã‚µãƒ³ãƒ—ãƒ«ä¾‹ãŒæƒã£ãŸæœ¬ã«åˆã‚ã¦å‡ºä¼šã„ã¾ã—ãŸã€‚ è‘—è€…ã¯DMM.comãƒ©ãƒœã«å‹¤ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã ãã†ã§ã™ãŒã€ã“ã®æ›¸ç±ã®å…ƒãƒã‚¿ã¯ç¾å ´ã§å®Ÿéš›ã«ä½¿ã£ã¦ã„ã‚‹SQLæ–‡ã‹è‘—è€…ã®å€‹äººçš„ãªãƒ¡ãƒ¢ãªã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã‚Œãã‚‰ã„ã€Œç—’ã„æ‰€ã«æ‰‹ãŒå±Šãã€ã€Œå›°ã£ãŸæ™‚ã«çŸ¥ã£ã¦ãŠããŸã„ã€ã‚µãƒ³ãƒ—ãƒ«ä¾‹ã°ã‹ã‚Šã§ã™ã€‚ ä»Šå›žã¯ã€ã“ã®æœ¬ã§ç€ç›®ã™ã¹ã3ã¤ã®æ³¨ç›®ç‚¹ã‚’ç°¡å˜ã«çºã‚ã¦ã¿ã¾ã—ãŸã€‚ ãã®1ï¼šéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®æ˜“ã—ã„è§£èª¬æ›¸ã‚¹ã‚¿ãƒ³ã‚¹ ãã‚‚ãã‚‚ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã¨ä¸€å£ã«ç”³ã—ã¦ã‚‚ã€ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã—ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã€
s-feng 2017/05/16
book

sql

database

analysis
ãƒªãƒ³ã‚¯
è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹(Redshiftã‚„ä¸»è¦RDBMSç‰)åŠã³OS(Mac/Windows/Linux)å¯¾å¿œã®ç„¡å„ŸSQLã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ã€ŽDBeaverã€ | DevelopersIO
å½“ãƒ–ãƒã‚°ã§ã¯ã€ã“ã‚Œã¾ã§ã«ã€ŽAmazon Redshiftã«å¯¾å¿œã—ã¦ã„ã‚‹äº‹ãƒ»ç¹‹ãŒã‚‹äº‹ã€ã‚’1ã¤ã®è©•ä¾¡è»¸ã¨ã—ã¦å¹¾ã¤ã‹ã®ãƒ„ãƒ¼ãƒ«ã‚’ç´¹ä»‹ã—ã¦æ¥ã¾ã—ãŸãŒã€ãã®ä¸€è¦§ã«æ–°ãŸã«åŠ ãˆã¦ã‚‚è‰¯ã•ãã†ãªãƒ„ãƒ¼ãƒ«ã®æƒ…å ±ã‚’å…ˆç¨‹ç›®ã«ã—ã¾ã—ãŸã®ã§ã€å½“ã‚¨ãƒ³ãƒˆãƒªã§ãã®å†…å®¹ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ãã‚ŒãŒã“ã¡ã‚‰ã®ã€ŽDBeaverã€ã§ã™ã€‚ DBeaver | Free Universal SQL Client ã“ã‚Œã¾ã§ç´¹ä»‹ã—ã¦ããŸDBé–¢é€£ãƒ„ãƒ¼ãƒ« å‚è€ƒã¾ã§ã«ã€ã“ã‚Œã¾ã§ã«ç´¹ä»‹ã—ã¦æ¥ãŸDBé–¢é€£ãƒ„ãƒ¼ãƒ«ã®ä¸€è¦§ã‚’ä»¥ä¸‹ã«çºã‚ã¾ã™ã€‚ Intellij IDEA(Ultimate Edition) Amazon Redshiftã®Mac OS Xå‘ã‘GUIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€ŽIntellij IDEA Ultimate Editionã€ã®Database Toolsã‚’ä½¿ã† ï½œ Developers.IO 0xDBE â†’ DataGrip Mac/W
s-feng 2017/05/05
Redshift

database

gui

sql

application
ãƒªãƒ³ã‚¯
ã€Žãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQLãƒ¬ã‚·ãƒ”ã€ã¯ãƒ‡ãƒ¼ã‚¿åˆ†æžã§SQLã‚¯ã‚¨ãƒªã‚’å©ãäººãªã‚‰å¿…èªã®é»’é”è¡“å¤§å…¨ - æ¸‹è°·é§…å‰ã§åƒããƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã®ãƒ–ãƒã‚°
ã“ã¡ã‚‰ã®æœ¬ã‚’ã”æµè´ˆã„ãŸã ãã¾ã—ãŸã€‚ ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿åˆ†æžãƒ»æ´»ç”¨ã®ãŸã‚ã®SQL ãƒ¬ã‚·ãƒ” ä½œè€…: åŠ åµœé•·é–€,ç”°å®®ç›´äººå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ãƒžã‚¤ãƒŠãƒ“å‡ºç‰ˆç™ºå£²æ—¥: 2017/03/27ãƒ¡ãƒ‡ã‚£ã‚¢: Kindleç‰ˆã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚°ã‚’è¦‹ã‚‹ ä¸€èˆ¬çš„ãªSQLã®æœ¬ã¨ã„ã†ã®ã¯DBç®¡ç†ã®ä¸€ç’°ã¨ã—ã¦ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®æŠ€è¡“æ›¸ã§ã‚ã‚‹ã“ã¨ãŒå¤šãã€æ„å¤–ã«ã‚‚ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ä¸»ç›®çš„ã¨ã—ãŸSQLã®ä½¿ã„æ–¹ã‚„ã‚¯ã‚¨ãƒªã®å·¥å¤«ã®ä»•æ–¹ã«ã¤ã„ã¦æ›¸ã‹ã‚ŒãŸæœ¬ã¨ã„ã†ã®ã¯ã‚ã¾ã‚Šå¤šããªã„ã‚“ã§ã™ã‚ˆãã€‚æ•…ã«ã€å¤šãã®ãƒ‡ãƒ¼ã‚¿åˆ†æžè€…ã¯é›£è§£ãªãƒ†ãƒ¼ãƒžã‚’å®Ÿç¾ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’æ›¸ããŸãã¦ã‚‚å‚è€ƒã«ãªã‚‹è³‡æ–™ãŒä¹ã—ãã€é€”æ–¹ã«æš®ã‚Œã‚‹ã‚ã‘ã§ã™ã€‚åƒ•ã‚‚Hive / Redshift / BigQueryã®ã‚¯ã‚¨ãƒªã‚’æ›¸ããªãŒã‚‰ã€Œã“ã‚“ãªåˆ†æžãŒã—ãŸã„ã‚“ã ã‘ã©ã€ãã‚Œã‚’å®Ÿç¾ã§ãã‚‹ã‚¯ã‚¨ãƒªã£ã¦ãªã„ã‚ˆãªãã€‚ã€‚ã€‚ã€ã¨ä½•åº¦å¤©ã‚’ä»°ã„ã ã“ã¨ã‹ã€‚ ãã‚“ãªã¨ã“ã‚ã«çªç„¶é™ã£ã¦æ¹§ã„ã¦ããŸã®ãŒã“ã¡ã‚‰ã®æ–°åˆŠæ›¸ã€‚ã‚‚ã†ç›®æ¬¡ã‚’è¦‹ãŸã
s-feng 2017/04/13
bigdata

sql

book
ãƒªãƒ³ã‚¯
Apache Drill 1.0ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã§Amazon S3ã¨é€£æºã—ã¦ã¿ãŸ | DevelopersIO
ã¯ã˜ã‚ã« Apache Drill 1.0ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸï¼ Drill 1.0 Released Apache Drillã¯ã€NoSQLå‘ã‘ã®SQLã‚¯ã‚¨ãƒªã‚¨ãƒ³ã‚¸ãƒ³ã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ä¸Šã®JSON/CSV/Parquetãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã€Hiveã‚½ãƒ¼ã‚¹ã€HBaseã€Mongo DBãªã©ã«ç›´æŽ¥SQLã‚¯ã‚¨ãƒªã‚’æŠ•ã’ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ä½•ã¯ã¨ã‚‚ã‚ã‚Œã€è§¦ã£ã¦ã¿ãªã„ã¨ã©ã‚“ãªãƒ¢ãƒŽãªã®ã‹ã‚ã‹ã‚Šã¾ã›ã‚“ã€‚æ—©é€Ÿè©¦ã—ã¦ã¿ã¾ã—ãŸï¼ ã‚„ã£ã¦ã¿ãŸ è©¦ã—ãŸç’°å¢ƒã¯EC2(on Amazon Linux 2015.03)ã§ã™ã€‚ ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ— Drillã®å‹•ä½œã«ã¯JDK 7ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã®ã§ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã™ã€‚ $ java -version java version "1.7.0_79" OpenJDK Runtime Environment (amzn-2.5.5.1.59.amzn1-x86_64
s-feng 2015/11/25
JSON

sql
ãƒªãƒ³ã‚¯
CSVå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ã‚’SQLã‚’ä½¿ã£ã¦è§£æžã™ã‚‹ - Qiita
q ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€CSVã‚„TSVå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾ã—ã¦ç›´æŽ¥SQLã‚’ç™ºè¡Œã§ãã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é † http://harelba.github.io/q/ qã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿è§£æžã®ä¾‹ ä»¥ä¸‹ã®æ§˜ãªå—æ³¨ãƒ‡ãƒ¼ã‚¿ã®CSV (ãƒ•ã‚¡ã‚¤ãƒ«åã¯orders.csv) ãŒæ‰‹å…ƒã«ã‚ã£ãŸæ™‚ã€‚ OrderId,OrderDate,ProductID,UserID,Quantity,TotalPrice 10000005,2015/2/13,100,10000,1,10000 10000006,2015/2/13,101,10001,2,2000 10000007,2015/2/13,102,10002,3,6000 10000008,2015/2/13,100,10003,1,10000 10000009,2015/2/13,101,10004,2,2000 10000010,2015/2/14,100,10005
s-feng 2015/08/15
sql

tutorial

program

analysis

data

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