[B! query] muddydixonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

muddydixon id:muddydixon

queryã«é–¢ã™ã‚‹muddydixonã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

ã‚°ãƒ¼ã‚°ãƒ«ã®æ¤œç´¢å±¥æ´ã‚’æ”¿åºœãŒç›£è¦–ã™ã‚‹ã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ä»¤çŠ¶ã€ã®å®Ÿæ…‹ | Forbes JAPAN å…¬å¼ã‚µã‚¤ãƒˆï¼ˆãƒ•ã‚©ãƒ¼ãƒ–ã‚¹ ã‚¸ãƒ£ãƒ‘ãƒ³ï¼‰
2019å¹´ã«ã‚¦ã‚£ã‚¹ã‚³ãƒ³ã‚·ãƒ³å·žã®é€£é‚¦æœæŸ»å®˜ã¯ã€ã‚ã‚‹å¥³å…ã«å¯¾ã™ã‚‹æ€§çš„è™å¾…ã¨äººèº«å–å¼•ã®å®¹ç–‘ã§è¤‡æ•°ã®ç”·ã®è¡Œæ–¹ã‚’è¿½ã£ã¦ã„ãŸã€‚ãƒ•ã‚©ãƒ¼ãƒ–ã‚¹ãŒå…¥æ‰‹ã—ãŸæœæŸ»è³‡æ–™ã«ã‚ˆã‚‹ã¨ã€ã“ã®å¥³å…ã¯2019å¹´ã«è¡Œæ–¹ä¸æ˜Žã«ãªã£ãŸå¾Œã«ã€èª˜æ‹ã•ã‚Œã¦æ€§çš„æš´è¡Œè¢«å®³ã«éã£ãŸã“ã¨ã‚’è¨´ãˆãŸã¨ã„ã†ã€‚ è¦å¯Ÿã¯ã€ã‚°ãƒ¼ã‚°ãƒ«ã«å¯¾ã—ã€å¥³å…ã‚„å¥³å…ã®æ¯è¦ªã®åå‰ã‚„ä½æ‰€ã‚’äº‹ä»¶ãŒç™ºç”Ÿã—ãŸ16æ—¥é–“ã«æ¤œç´¢ã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æƒ…å ±ã‚’æä¾›ã™ã‚‹ã‚ˆã†è¦æ±‚ã—ãŸã€‚ã‚°ãƒ¼ã‚°ãƒ«ã¯ã€2020å¹´åŠã°ã«æ¤œç´¢ã‚’è¡Œã£ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚°ãƒ¼ã‚°ãƒ«ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚„IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æ”¿åºœã«æä¾›ã—ãŸãŒã€ä½•äººã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒå¯¾è±¡ã«ãªã£ãŸã‹ã¯æ˜Žã‹ã•ã‚Œã¦ã„ãªã„ã€‚ ä»Šå›žã®æœæŸ»ã§ã¯ã€ç‰¹å®šã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æƒ…å ±æä¾›ã‚’æ±‚ã‚ã‚‹ã€ã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ä»¤çŠ¶ã€ï¼ˆkeyword warrantï¼‰ã¨å‘¼ã°ã‚Œã‚‹ç‰¹æ®ŠãªæœæŸ»ä»¤çŠ¶ãŒç™ºè¡Œã•ã‚ŒãŸã€‚ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ä»¤çŠ¶ãŒå…¬ã«ãªã£ãŸã®ã¯ã€ã“ã‚Œã¾ã§ã«2ä»¶ã—ã‹ãªã„ã€‚1ä»¶ç›®ã¯ã€æŒæ‰‹ã®Rãƒ»ã‚±ãƒªãƒ¼ã«ã‚ˆã‚‹æå–äº‹ä»¶ã®ç›®æ’ƒè€…ãŒè»Šã‚’æ”¾ç«
muddydixon 2021/10/07
privacy

google

query

search

government
ãƒªãƒ³ã‚¯
PartiQL :: PartiQL
PartiQL's extensions to SQL are easy to understand, treat nested data as first class citizens and compose seamlessly with each other and SQL. This enables intuitive filtering, joining and aggregation on the combination of structured, semistructured and nested datasets. PartiQL enables unified query access across multiple data stores and data formats by separating the syntax and semantics of a quer
muddydixon 2019/08/06
sql

partiql

facebook

database

query
ãƒªãƒ³ã‚¯
BigQueryã®ã‚³ã‚¹ãƒˆå¯è¦–åŒ–ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’10åˆ†ã§ä½œã‚‹ - ä¸‹ç”ºæŸšåé»„æ˜è¨˜ by @yuzutas0
ã“ã®è¨˜äº‹ã¯Google Cloud Platform ãã®ï¼‘ Advent Calendar 2018 - 18æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ä»¥å‰ã“ã†ã„ã†ãƒ–ã‚³ãƒ¡ã‚’ã—ãŸã®ã§ã™ãŒã€è¨€ã„ã£æ”¾ã—ã ã¨ãƒ€ã‚µã„ã®ã§ã€å…·ä½“çš„ãªã‚„ã‚Šæ–¹ã‚’æ›¸ãã¾ã™ã€‚ "ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã”ã¨/æ—¥ä»˜ã”ã¨ã®BigQueryã‚³ã‚¹ãƒˆã‚’å¯è¦–åŒ–ã§ãã‚‹ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰" ãªã‚‰ Stackdriver + BQ + Datastudio ã‚’ä½¿ã†ã¨ä½œæ¥æ™‚é–“10åˆ†ãƒ»ã»ã¼ç„¡æ–™ã§ä½œã‚Œã‚‹ã®ã§ã€ã†ã¡ã¯ãã®ã‚„ã‚Šæ–¹ã‚’æŽ¡ç”¨ã—ã¦ã„ã¾ã™ãã€‚â€¦ https://t.co/9yoni22iw7â€” ã‚†ãšãŸã (@yuzutas0) August 17, 2018 ã‚‚ãã˜ ã‚‚ãã˜ ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã®ã‚´ãƒ¼ãƒ« è§£æ±ºã—ãŸã„èª²é¡Œ èª²é¡Œã®èƒŒæ™¯ å®Ÿè¡Œæ–¹é‡ å®Œæˆã‚¤ãƒ¡ãƒ¼ã‚¸ ä½œæ¥æ‰‹é † 1: BQã‚¯ã‚¨ãƒªå®Ÿè¡Œãƒã‚°ã‚’æµã™ 2: DataStudioã§ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã«è¡¨ç¤ºã™ã‚‹ å¿œç”¨ç·¨ 1: å…¨ä½“ã‚³ã‚¹ãƒˆã‚’å¯è¦–åŒ–ã™ã‚‹ 2
muddydixon 2019/02/20
gcp

bigquery

money

cost

query
ãƒªãƒ³ã‚¯
subarasikigraphqlfalsesekaiheyoukoso?slide=56
DroidKaigi 2018ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™
muddydixon 2018/02/14
presentation

graphql

query
ãƒªãƒ³ã‚¯
Nç§’é–“ã ã‘ã‚¯ã‚¨ãƒªå®Ÿè¡Œãƒã‚°ã‚’å–ã‚ŠãŸã„ - Hateburo: kazeburo hatenablog
pt-query-digestã ã£ãŸã‚Šèª¿æŸ»ã®ãŸã‚ã«ã€Nç§’é–“ã ã‘mysqlã®å…¨ã‚¯ã‚¨ãƒªã®ãƒã‚°ã‚’å–å¾—ã—ãŸã„ã¨ã„ã†ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆã ãã‚“ãªæ™‚ã¯ã“ã‚“ãªã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ç°¡å˜ã«æŒ‡å®šã®ç§’æ•°slowlogã‚’åˆ‡ã‚Šæ›¿ãˆã¦ä¿å˜ã€å–å¾—å¾Œã«å…ƒã«æˆ»ã—ã¦ãã‚Œã¾ã™ã€‚ $ slowlog.pl --duration 10 -- --default-extra-file=/hoge/my.cnf -uuser -- ã®ã‚ã¨ã¯mysqlã‚³ãƒžãƒ³ãƒ‰ã«æ¸¡ã™ã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã‚½ãƒ¼ã‚¹ #!/usr/bin/perl use strict; use warnings; use IO::Handle; use Getopt::Long; use File::Spec; sub find_path { my $pg = shift; my $path; for ( split /:/, $ENV{PATH} ) { if ( -x "$_/$p
muddydixon 2017/02/09
benri

tools

mysql

perl

database

query
ãƒªãƒ³ã‚¯
q - Text as Data
q - Run SQL directly on CSV or TSV filesÂ¶ OverviewÂ¶ q's purpose is to bring SQL expressive power to the Linux command line by providing easy access to text as actual data, and allowing direct access to multi-file sqlite3 databases. q <flags> <sql-query> q allows the following: Performing SQL-like statements directly on tabular text data, auto-caching the data in order to accelerate additional quer
muddydixon 2016/11/16
query

csv

tsv
ãƒªãƒ³ã‚¯
æ¤œç´¢ãƒã‚°ã‹ã‚‰ã€Œã˜ã‚ã˜ã‚æ¤œç´¢é »åº¦ãŒä¸Šæ˜‡ã—ã¦ã„ã‚‹ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€ã‚’è¦‹ã¤ã‘ã‚‹ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã®äº•ä¸Šå¯›ä¹‹ï¼ˆ@inohiroï¼‰ã§ã™ã€‚ æ™®æ®µã¯æ³•äººå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã€ŒãŸã¹ã¿ã‚‹ã€ã®é–‹ç™ºã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚ ãŸã¹ã¿ã‚‹ã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®æ¤œç´¢ãƒã‚°ã‚’åŸºã«ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€ä»»æ„ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã®æ¤œç´¢é »åº¦ã€ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰åŒå£«ã®çµ„ã¿åˆã‚ã›æ¤œç´¢é »åº¦ã€ ãŠã‚ˆã³ãã‚Œã‚‰ã‚’åœ°åŸŸã‚„å¹´ä»£ãƒ»æ€§åˆ¥ã§çµžã‚Šè¾¼ã‚“ã§åˆ†æžã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã§ã¯ã€ŒãŸã¹ã¿ã‚‹ã€ã®é–‹ç™ºã®ã»ã‹ã€ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ä¸Šã®ãƒˆãƒ¬ãƒ³ãƒ‰ã‚’è¦‹ã¤ã‘ã‚‹ãŸã‚ã«æ—¥ã€…èª¿æŸ»ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ã“ã“ã§ã®ãƒˆãƒ¬ãƒ³ãƒ‰ã¨ã¯ã€ã€Œæµè¡Œã£ã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ã€Œæµè¡Œã‚Šãã†ã€ã¨ã„ã£ãŸã‚‚ã®ã‚’æŒ‡ã—ã¾ã™ã€‚ æ¶ˆè²»è€…ãŒæ°—ã«ãªã£ã¦ã„ã‚‹ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãŒä½•ã‹ã‚’çŸ¥ã‚‹ã“ã¨ã§ã€æ¶ˆè²»è€…ãŒæ±‚ã‚ã¦ã„ã‚‹æƒ…å ±ã‚’é©åˆ‡ã«æä¾›ã§ãã‚‹ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€è†¨å¤§ãªæ¤œç´¢ãƒã‚°ã®ä¸ã‹ã‚‰ã€Œã˜ã‚ã˜ã‚æ¤œç´¢é »åº¦ãŒä¸Šæ˜‡ã—ã¦ã„ã‚‹ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã€ã‚’è¦‹ã¤ã‘ã‚‹ãŸã‚ã« è¡Œã£ãŸã“ã¨ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã˜ã‚ã˜ã‚æ¤œå‡º ã€Œã˜ã‚ã˜ã‚æ¤œç´¢é »åº¦ãŒä¸Šæ˜‡ã—ã¦
muddydixon 2015/06/30
è©¦è¡ŒéŒ¯èª¤ã™ã°ã‚‰ã—ã„ï¼

data

analysis

search

query
ãƒªãƒ³ã‚¯
Google docsã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§é›†è¨ˆã™ã‚‹éš›ã«SQLã£ã½ã„ã‚¯ã‚¨ãƒªã‚’ä½¿ã† - ãƒ†ãƒŽãƒ‹ãƒƒã‚ (@hideack 's diary)
æœ€è¿‘æ¥å‹™ã§google docsã‚„Excelã§ç®¡ç†ã•ã‚ŒãŸã‚·ãƒ¼ãƒˆã®å†…å®¹ã‚’é›†è¨ˆã—ãŸã„ã“ã¨ãŒã‚ã£ã¦ã€åŸºæœ¬google docsã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã‚´ãƒ‹ãƒ§ã‚´ãƒ‹ãƒ§ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã®ã§ã™ãŒã€ä¾‹ãˆã° ã®æ§˜ãªã‚‚ã®ãŒã‚ã£ã¦ã€ä¸Šã®ä¾‹ã ã¨å„ãƒ¦ãƒ¼ã‚¶ã®ãƒã‚¤ãƒ³ãƒˆã®åˆè¨ˆã‚’é›†è¨ˆã—ãŸã„ãªã¨è€ƒãˆãŸæ™‚ã«Excelã«æ…£ã‚Œã¦ã„ã‚‹æ–¹ã ã¨Excelã®é–¢æ•°ãŒæµ®ã‹ã‚“ã§é›†è¨ˆã§ãã‚‹ã®ã‹ã¨æ€ã†ã®ã§ã™ãŒè‡ªåˆ†ã ã¨SQLæ–‡ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒå…ˆã«å‡ºã‚‹ã®ã§ã‚ˆã—ãªã«ã§ããªã„ã‹ãªã¨æ€ã£ã¦ã„ãŸã‚‰ã€Google docsã ã¨ QUERY ã¨ã„ã†é–¢æ•°ã‚’ä½¿ã†ã“ã¨ã§å®Ÿç¾ã§ãã‚‹ã“ã¨ã‚’çŸ¥ã£ãŸã®ã§ãƒ¡ãƒ¢ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ ä¸Šã®ä¾‹ã ã¨ D1 ã®ã‚»ãƒ«ã«ä»¥ä¸‹ã®æ§˜ãªå†…å®¹ã‚’è¨˜è¿°ã—ã¾ã™ã€‚ =query(A2:B9, "select A, sum(B) group by A") 1ç•ªç›®ã®å¼•æ•°ã«ãƒ‡ãƒ¼ã‚¿ã®ç¯„å›²ã‚’æŒ‡å®šã—ã€2ç•ªç›®ã«ãã®ãƒ‡ãƒ¼ã‚¿ç¯„å›²ã§ã®ã‚¯ã‚¨ãƒªã‚’è¨˜è¿°ã—ã¾ã™ã€‚ SQLã‚’è§¦ã£ãŸã“ã¨ãŒã‚ã‚‹æ–¹ãªã‚‰ãªã‚“ã¨ãªã
muddydixon 2015/06/29
spreadsheet

query

sql
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€ŽSQLå®Ÿè·µå…¥é–€ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
4æœˆä¸æ—¬ã“ã‚ã«ãªã‚Šã¾ã™ãŒã€æ–°è‘—ãŒå‡ºã¾ã™ã€‚SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸»é¡Œã«ã—ãŸæœ¬ã§ã€å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ã“ã¨ã§ã€ãªãœã“ã®SQLã¯é…ã„ã®ã‹ã€ã‚ã‚‹ã„ã¯é€Ÿã„ã®ã‹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã¾ã§æŠŠæ¡ã—ã¦ç†è§£ã—ã‚ˆã†ã€ã¨ã„ã†è¶£æ—¨ã§ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯ã€SQLã¨ã„ã†è‡ªç„¶è¨€èªžã‚’æ¨¡ã—ãŸã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã€ä½Žæ¬¡ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’éš è”½ã™ã‚‹æ„å›³ã§ä½œã‚‰ã‚ŒãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãªã®ã§ã€æœ¬å½“ã¯å®Ÿè¡Œè¨ˆç”»ãªã©ã¨ã„ã†æ‰‹ç¶šãƒ¬ãƒ™ãƒ«ã®ä¸–ç•Œã‚’ãƒ¦ãƒ¼ã‚¶ãŒè¦—ãè¦‹ã‚‹ã®ã¯ã€æœ¬æœ«è»¢å€’ãªã¨ã“ã‚ã‚‚ã‚ã‚Šã¾ã™ã€‚ãŸã ãã†ã¯ã„ã£ã¦ã‚‚ã€ç¾å®Ÿã«SQLãŒé…ã‹ã£ãŸã‚‰åŽŸå› ã‚’è§£æžã›ã–ã‚‹ã‚’ãˆãªã„ã‚ã‘ã ã—ã€å¤§ä½“æœ¬å½“ã«ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã«ã—ãŸã„ãªã‚‰ã€ãªã‚“ã§ã©ã®DBMSã‚‚å®Ÿè¡Œè¨ˆç”»ã‚’è¦‹ã‚‰ã‚Œã‚‹æ‰‹æ®µãªã‚“ã‹ç”¨æ„ã—ã¦ã‚‹ã‚“ã§ã—ã‚‡ã†ãä¸æ€è°ã§ã™ãã€ã¨ã„ã†ç†æƒ³ã¨ç¾å®Ÿã®ç‹é–“ã§æ‚©ã‚€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã€…ã«å°‘ã—ã§ã‚‚ãƒ™ã‚¿ãƒ¼ãªè§£ã«è¾¿ã‚Šã¤ã‘ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æç¤ºã§ãã‚Œã°ã€ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¾ãˆãŒãã¨ç« ç«‹ã¦ã§ã™ã€‚
muddydixon 2015/03/30
sql

data

database

query

book
ãƒªãƒ³ã‚¯
Osquery
muddydixon 2014/10/31
operation

os

query

sql
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã®ãŸã‚ã®HiveQLåˆ†æžã‚¯ã‚¨ãƒªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ ãã®ï¼“ - ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ï¼ˆTreasure Dataï¼‰ãƒ–ãƒã‚°
*ãƒˆãƒ¬ã‚¸ãƒ£ãƒ¼ãƒ‡ãƒ¼ã‚¿ã¯ãƒ‡ãƒ¼ã‚¿åŽé›†ã€ä¿å˜ã€åˆ†æžã®ãŸã‚ã®ã‚¨ãƒ³ãƒ‰ãƒ„ãƒ¼ã‚¨ãƒ³ãƒ‰ã§ã‚µãƒãƒ¼ãƒˆã•ã‚ŒãŸã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã®ãŸã‚ã®HiveQLåˆ†æžã‚¯ã‚¨ãƒªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚·ãƒªãƒ¼ã‚ºï¼š ãã®ï¼‘,Â ãã®ï¼’,Â ãã®ï¼“,Â ãã®ï¼”,Â ãã®ï¼•, ãã®ï¼– ãã®ï¼’ã«å¼•ãç¶šã„ã¦B. < m1|Bin(m2), Bin(m3) >ã«å±žã™ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’è¦‹ã¦ã„ãã¾ã™ã€‚ ãƒ‘ã‚¿ãƒ¼ãƒ³ B-3ï¼š< m1 | Bin(m2) > ã‚ˆã‚Šä¸€èˆ¬çš„ãªã“ã¡ã‚‰ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’è¦‹ã¦ã„ãã¾ã™ã€‚ SELECT ceil(Â #m2/width )*width AS x,Â SUM(#m1) AS sum FROM ( SELECTÂ #m1, #m2, 1 AS one FROM table WHERE condition ) t1 JOIN ( SELECT POW(10,floor(LOG10(MAX(Â #m2Â )))-1) AS width, 1
muddydixon 2014/06/02
hive

query

template
ãƒªãƒ³ã‚¯
Prestoã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°#2 ãƒ¡ãƒ¢
memo.md Presto ãƒ¡ãƒ¢ presto 0.60 [ QueryResource , TaskResource ) ç’°å¢ƒ ãªã‚“ã‹ãã®ã¾ã¾ mvn clean install eclipse:eclipse -DskipTests ã‚³ãƒžãƒ³ãƒ‰å©ã„ã¦ã‚‚ checkstyle ã§è½ã¡ãŸã®ã§: mvn clean install -DskipTests mvn eclipse:eclipse -Dcheckstyle.skip ã¡ãªã¿ã«ã€Eclipseã˜ã‚ƒãªãã¦IDEAæŽ¨å¥¨ã®æ¨¡æ§˜ã€‚ ã‚¨ãƒ³ãƒˆãƒªãƒã‚¤ãƒ³ãƒˆ ã‚µãƒ¼ãƒ“ã‚¹ã‚¨ãƒ³ãƒˆãƒªã€‚ ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å—ã‘å–ã‚‹ QueryResource ã‹ã‚‰ã€‚ // presto-server/src/main/java/com/facebook/presto/server/QueryResource.java:L89 @POST @Produces(MediaType.A
muddydixon 2014/03/13
presto

database

query

hadoop
ãƒªãƒ³ã‚¯
kibanaã§ä½¿ãˆã‚‹lucene query - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
muddydixon 2014/01/31
elasticsearch

lucene

kibana

query
ãƒªãƒ³ã‚¯
db tech showcase Tokyo 2013 - A35 ç‰¹æ¿ƒJPOUGï¼šæ½®æºœã¾ã‚Šã§ã‚¸ãƒ£ãƒ–ã‚¸ãƒ£ãƒ–ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
db tech showcase Tokyo 2013 - A35 ç‰¹æ¿ƒJPOUGï¼šæ½®æºœã¾ã‚Šã§ã‚¸ãƒ£ãƒ–ã‚¸ãƒ£ãƒ–ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°AI-enhanced description æœ¬æ–‡ç”±Michael Hiroshi Sekiguchiæ’°å†™ï¼ŒæŽ¢è®¨äº†SQLè°ƒä¼˜ä¸çš„ä¸€äº›å¸¸è§é—®é¢˜ï¼Œå¦‚è¿‡åº¦è¿‡æ»¤å’ŒæŸ¥è¯¢åˆ†è£‚ï¼Œå¹¶é€šè¿‡å…·ä½“çš„SQLå®žä¾‹é˜è¿°äº†å¦‚ä½•è¿›è¡Œä¼˜åŒ–ã€‚ä½œè€…åˆ†äº«äº†åœ¨OLTPå’Œåˆ†å¸ƒå¼æ•°æ®åº“çŽ¯å¢ƒä¸å¤„ç†SQLæŸ¥è¯¢çš„ç»éªŒï¼ŒæœŸæœ›é€šè¿‡è°ƒæ•´SQLè¯å¥æ¥æ”¹å–„æ€§èƒ½ã€‚æœ¬æ–‡ä¸ºæ•°æ®åº“å·¥ç¨‹å¸ˆæä¾›äº†å®žç”¨çš„è°ƒä¼˜å»ºè®®å’ŒSQLæŸ¥è¯¢çš„ç†è§£ã€‚
muddydixon 2013/12/09
ãƒœãƒªãƒ¥ãƒ¼ãƒ åŠç«¯ãªã„

database

sql

query

performance

tuning
ãƒªãƒ³ã‚¯
MySQL 5.1ã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°
MySQL 5.1ã§è¿½åŠ ã•ã‚ŒãŸãƒ¡ã‚¸ãƒ£ãƒ¼ãªæ©Ÿèƒ½ã®å½±ã«éš ã‚ŒãŸã€åœ°å‘³ã ãŒä¾¿åˆ©ãªæ”¹å–„ãŒã‚ã‚‹ã€‚ãã‚ŒãŒã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã«é–¢ã™ã‚‹ä»•æ§˜ã§ã‚ã‚‹ã€‚MySQL 5.0ã¾ã§ã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã¯1ç§’æœªæº€ã®ã‚¯ã‚¨ãƒªã‚’æ•æ‰ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ãªã‹ã£ãŸã€‚ãŒã€MySQL 5.1ã§ã¯1ãƒžã‚¤ã‚¯ãƒç§’ã¾ã§ã®ã‚¯ã‚¨ãƒªã‚’è¨˜éŒ²ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚å¾“ã£ã¦ã€0.5ç§’ã‹ã‹ã‚‹ã‘ã©å¤§é‡ã«å®Ÿè¡Œã•ã‚Œã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’ä¸Žãˆã¦ã„ã‚‹ï¼ã¨ã„ã†ã‚ˆã†ãªã‚¯ã‚¨ãƒªã®ç™ºè¦‹ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚1ç§’æœªæº€ã®ã‚¯ã‚¨ãƒªã‚’è¿½è·¡ã—ãŸã„å ´åˆã€ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ãªè¨å®šã‚’ã™ã‚‹ã€‚ [mysqld] slow_query_log=ON slow_query_log_file=mysql-slow.log long_query_time=0.1 MySQL 5.0ã¾ã§ã¯log_slow_queryã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã ã£ãŸã®ãŒã€MySQL 5.1ã§ã¯slow_query_logã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³å
muddydixon 2013/05/07
mysql

slow

query

data
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³5ã®å¾©ç¿’ MySQL 5.5 ãƒãƒ¼ãƒˆç·¨ï¼†å‹‰å¼·ä¼šã®ãŠçŸ¥ã‚‰ã› - SH2ã®æ—¥è¨˜
ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®@zakiã•ã‚“ã‚’ä¸å¿ƒã«ä¼ç”»ã€é‹å–¶ã•ã‚Œã¦ã„ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚æŒ‡å®šã•ã‚ŒãŸç’°å¢ƒã‚’ç”¨ã„ã¦OSã‚„ã‚µãƒ¼ãƒå‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã„ã€æ€§èƒ½ã‚’ç«¶ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚2013å¹´1æœˆã«è¡Œã‚ã‚ŒãŸç¬¬5å›žã§ã¯MySQLãŒãƒ†ãƒ¼ãƒžã ã£ãŸã¨ã„ã†ã“ã¨ã§ã€æœ¬æ—¥ã¯ã“ã‚Œã®å¾©ç¿’ã‚’ã—ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆï¼ã€ŒTuningathonã€ç¬¬5å¼¾ï¼ #tuningathon : ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®åºƒå ±ãƒ–ãƒã‚° 2013å¹´æœ€åˆã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¯MySQLï¼â€•â€•ç¬¬5å¼¾ï¼ ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã€ãƒ¬ãƒãƒ¼ãƒˆï¼šãƒ¬ãƒãƒ¼ãƒˆï½œgihyo.jp â€¦ æŠ€è¡“è©•è«–ç¤¾ Tuningathon#5 - Togetter ã—ã°ã‚‰ãçœŸé¢ç›®ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãŸã®ã§ã™ãŒæ€ã„ã®ã»ã‹é›£ã—ã‹ã£ãŸã®ã§ã€ä»Šå›žã¯ã¡ã‚‡ã£ã¨ã‚ºãƒ«ã‚’ã—ã¦å„ª
muddydixon 2013/03/05
ã™ã”ã„ï¼

database

mysql

tuning

performance

query

cache

proxy
ãƒªãƒ³ã‚¯
fluent-plugin-mysqlslowquerylog ã‚’æ›¸ã„ãŸ - Studio3104::BLOG.new
MySQLã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°(è¤‡æ•°è¡Œ)ã‚’ä¸€ã¤ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã¨ã—ã¦em itã™ã‚‹Outputãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ãã¾ã—ãŸã€‚ åŒã˜ã‚ˆã†ãªã“ã¨ã‚’ã—ã¦ãã‚Œã‚‹Inputãƒ—ãƒ©ã‚°ã‚¤ãƒ³*1ãŒã™ã§ã«ã‚ã£ã¦ã€ãŒã£ã¤ã‚Šä½¿ã£ã¦ã„ãŸã®ã§ã™ãŒã€å…¥åŠ›ã«fluent-agent-liteã‚’ä½¿ã„ãŸã‹ã£ãŸãŸã‚ã«ä½œæˆã—ã¾ã—ãŸã€‚ fluent-plugin-mysqlslowquerylog | RubyGems.org | your community gem host studio3104/fluent-plugin-mysqlslowquerylog Â· GitHub ãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ ã“ã‚“ãªæ„Ÿã˜ã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ãŒã€ # Time: 130107 11:36:21 # User@Host: root[root] @ localhost [] # Query_time: 0.000378 Lock_time: 0.000111 Rows
muddydixon 2013/01/08
mysql

fluentd

slow

query
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
muddydixon 2012/10/24
dht

query

database
ãƒªãƒ³ã‚¯
Hadoopã‚’ã‚ˆã‚Šä¾¿åˆ©ã«ä½¿ã†ï¼Hiveã§ã®MapReduceã¾ã¨ã‚ - Y's note
ç›®æ¬¡ Hiveã¨ã¯ Hiveã®è¨å®š HiveQLæ§‹æ–‡(DDL) DataBase/SCHEMAã®ä½œæˆ Database/SCHEMAã®å‰Šé™¤ Tableã®ä½œæˆ Tableã®å‰Šé™¤ Tableåå¤‰æ›´ Partitionä½œæˆ Partitionã®å‰Šé™¤ Columnã®å¤‰æ›´ Columnã®è¿½åŠ /ç½®ãæ›ãˆ Tableã®Propertyå¤‰æ›´ SerDe Propertyã®è¿½åŠ HiveQLæ§‹æ–‡(SQL) ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§è¡¨ç¤º ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†…å®¹ã‚’è¡¨ç¤º åŸºæœ¬çš„ãªSELECTæ–‡ WHEREå¥(æ¡ä»¶æŒ‡å®š) DISTINCT(é‡è¤‡å‰Šé™¤) ORDER BY / SORT BYå¥(ã‚½ãƒ¼ãƒˆ) GROUP BYå¥(ã‚°ãƒ«ãƒ¼ãƒ—åŒ–) HAVINGå¥(ã‚°ãƒ«ãƒ¼ãƒ—åŒ–å¾Œã®æ¡ä»¶) LIMITå¥ JOIN(ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ) æŠ½å‡ºã‚«ãƒ©ãƒ ã‚’æ£è¦è¡¨ç¾ã§æŒ‡å®š UNION(çµæžœã®çµåˆ) SUBQUERY LOAD(ãƒ‡ãƒ¼ã‚¿ã®èªã¿è¾¼ã¿) Hiveã‚’ä½¿ã† äº‹å‰æº–å‚™
muddydixon 2012/08/27
hive

query
ãƒªãƒ³ã‚¯
Query Execution in Column-Oriented Database Systems by Daniel J. Abadi [email protected] M.Phil. Computer Speech, Text, and Internet Technology, Cambridge University, Cambridge, England (2003) & B.S. Computer Science and Neuroscience, Brandeis University
Query Execution in Column-Oriented Database Systems by Daniel J. Abadi dna@csail.mit.edu M.Phil. Computer Speech, Text, and Internet Techno logy, Cambridge University, Cambridge, England (2003) & B.S. Computer Science and Neuroscience, Brandeis University, Waltham, MA, USA (2002) Submitted to the Department of Electrical Engineering and Computer Science in partial fulï¬llment of the requirements fo
muddydixon 2012/08/13
pdf

dht

query

paper
ãƒªãƒ³ã‚¯
1