[B! Hive] jay777ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

jay777 id:jay777

Hiveã«é–¢ã™ã‚‹jay777ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

Hiveã¨Impalaã®ãŠã„ã—ã„ã¨ã“å–ã‚Š
1. Copyright Â© CELLANT Corp. All Rights Reserved. h t t p : / / w w w . c e l l a n t . j p / 1 1 Hiveã¨Impalaã®ãŠã„ã—ã„ã¨ã“å–ã‚Š ã€Žãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° Hiveã€ã€ŽHadoop ç¬¬3ç‰ˆã€ åˆŠè¡Œè¨˜å¿µ Hadoopã‚»ãƒŸãƒŠãƒ¼ 2013å¹´ï¦Ž7â½‰æœˆ24â½‡æ—¥ æ ªå¼ä¼šç¤¾ã‚»ãƒ©ãƒ³ R&Dæˆ¦ç•¥ï¥¶å®¤ Â é ˆâ½¥ç”°å¹¸æ†² 3. Copyright Â© CELLANT Corp. All Rights Reserved. h t t p : / / w w w . c e l l a n t . j p / vï¶â€¯é ˆâ½¥ç”°å¹¸æ†²ï¼ˆ@sudabon) vï¶â€¯æ ªå¼ä¼šç¤¾ã‚»ãƒ©ãƒ³ Â R&Dæˆ¦ç•¥ï¥¶å®¤ Â å®¤â»‘â¾§é•· vï¶â€¯çµŒæ´ lï¬â€¯1997ã€œï½ž2004 Â NEC Â ä¸å¤®ç ”ç©¶æ‰€ Â / Â ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®ç ”ç©¶ lï¬â€¯2005ã€œï½ž2006 Â B
jay777 2013/07/25
Hadoop

Hive

Impala
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚»ãƒŸãƒŠãƒ¼ Hiveå…¥é–€ #oreilly0724
2. è‡ªå·±ç´¹ä»‹ â€¢â€¯ å¶‹å†…ã€€ç¿”(ã—ã¾ã†ã¡ ã—ã‚‡ã†) â€¢â€¯ 2011å¹´4æœˆã«Clouderaã®æœ€åˆã®æ—¥æœ¬äººç¤¾å“¡ã¨ã—ã¦å…¥ ç¤¾ â€¢â€¯ ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚µãƒãƒ¼ãƒˆæ¥å‹™ã‚’ãƒ¡ã‚¤ãƒ³ã«ã€æ—¥æœ¬ã«ãŠã‘ã‚‹æŠ€ è¡“ã«é–¢ä¿‚ã™ã‚‹æ¥å‹™å…¨èˆ¬ã‚’æ‹…å½“ 2 3. Apache Hadoop Hadoopã¯ã€ 1.â€¯ å˜ä¸€ã‚µãƒ¼ãƒã§å‡¦ç†ã—ãã‚Œãªã„ã»ã©å¤§é‡ãªãƒ‡ãƒ¼ã‚¿ã‚’ 2.â€¯ ã‚³ãƒ¢ãƒ‡ã‚£ãƒ†ã‚£ã‚µãƒ¼ãƒã‚’ä¸¦ã¹ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ 3.â€¯ åˆ†æ•£å‡¦ç†åŠã³ä¿å˜ã™ã‚‹ãŸã‚ã® 4.â€¯ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ 3 4. Hadoopã‚·ã‚¹ãƒ†ãƒ ã®å…¨ä½“æ§‹æˆ 4 Hadoop å¤–éƒ¨ã‚·ã‚¹ãƒ†ãƒ RDBMS Webã‚µãƒ¼ãƒç‰ã® ãƒã‚°ã‚’ç”Ÿæˆã™ã‚‹ã‚µãƒ¼ãƒ æºå¸¯ç«¯æœ«ã® é€šä¿¡ãƒã‚° APIã‚¢ã‚¯ã‚»ã‚¹ ãƒã‚°åŽé›† ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ ã‚¤ãƒ³ãƒãƒ¼ãƒˆ åˆ†æ•£ãƒãƒƒãƒå‡¦ç† æ©Ÿæ¢°å¦ç¿’ å¤–éƒ¨ã‚·ã‚¹ãƒ†ãƒ APIã‚¢ã‚¯ã‚»ã‚¹ ãƒ¦ãƒ¼ã‚¶ DWH ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ BIãƒ„ãƒ¼ãƒ« + JDBC/ODBC æ¤œç´¢ SQL 5. Ha
jay777 2013/07/25
Hadoop

Hive
ãƒªãƒ³ã‚¯
ã‚„ã£ãŸãƒ¼ï¼è¶…ã‚ãƒ¥ãƒ¼ãƒˆãªHiveãƒã‚´ã‚’æ„›ã§ãªãŒã‚‰ãƒ–ãƒ©ã‚¦ã‚¸ãƒ³ã‚°ã§ãã‚‹Chromeæ‹¡å¼µã§ããŸã‚ˆãƒ¼ï¼¼(^o^)ï¼ - ãƒ€ãƒ¡äººé–“ã‚ªãƒ³ãƒ©ã‚¤ãƒ³
http://www.apache.org/ äº‹ã®ç™ºç«¯ @tagomorisã•ã‚“ãŒHiveãƒã‚´ãŒãƒ—ãƒªãƒ³ãƒˆã•ã‚ŒãŸTã‚·ãƒ£ãƒ„ã‚’ç€ã¦ãŸ â†“ èƒŒä¸å´ãŒç‹‚æ°—ã«æº€ã¡ã¦ã‚‹ã¨æ„Ÿã˜ãŸ â†“ kowai â†“ å¤¢ã«å‡ºã¦ããŸ â†“ èµ·ããŸã‚‰Hiveãƒã‚´ãŒã¨ã¦ã‚‚æ„›ãŠã—ãæ„Ÿã˜ã‚‹ã‚ˆã†ã«ãªã£ã¦ãŸ â†“ ã‚‚ã£ã¨é•·ã„æ™‚é–“çœºã‚ã¦ã„ãŸã„ï¼ â†“ ã©ã®ãƒšãƒ¼ã‚¸è¦‹ã¦ã‚‚Hiveãƒã‚´ãŒç›®ã«å…¥ã‚‹ã‚ˆã†ã«ã™ã‚Œã°ãˆãˆã‚“ã‚„ï¼ï¼ @tagomorisã•ã‚“ãŒç€ã¦ãŸTã‚·ãƒ£ãƒ„ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã¯ã“ã¡ã‚‰ Hadoop Conference Japan 2013 Winter ã«ã„ã£ã¦ããŸï¼†ã—ã‚ƒã¹ã£ã¦ããŸ - tagomorisã®ãƒ¡ãƒ¢ç½®ãå ´ âŠ‚äºŒäºŒäºŒï¼ˆ ï¼¾Ï‰ï¼¾ï¼‰äºŒâŠƒ dameninngenn/chrome-ext-bu-------n Â· GitHub ã‚„ã£ãŸãƒ¼ï¼ã‹ãƒ¼ã‚ãƒ¼ã„ãƒ¼ã„ãƒ¼ï¼ï¼ ãŸã å¤§é‡ã«ç™ºç”Ÿã•ã›ã™ãŽã‚‹ã¨CPUãŒã‚¦ã‚©ãƒ¼ãƒ¼ãƒ¼ã£ã¦ãªã£ã¦ãƒ•ã‚¡ãƒ³ãŒãƒ•ã‚¡ãƒ¼ãƒ¼ãƒ¼ãƒ¼ãƒ¼ã£ã¦ãªã‚‹ã€‚ã€‚ ä½™è«‡
jay777 2013/06/13
ã‚ã¨ã§èªã‚€

Hive
ãƒªãƒ³ã‚¯
mixi ã®è§£æžåŸºç›¤ã¨Apache Hive ã§ã® JSON ãƒ‘ãƒ¼ã‚µã®æ´»ç”¨ã®ç´¹ä»‹ - mixi engineer blog
ã“ã‚“ã«ã¡ã¯ï¼Žæœ€è¿‘ãƒ”ã‚¯ãƒ«ã‚¹ä½œã‚Šã§ç²¾ç¥žçµ±ä¸€ã‚’ã—ã¦ã„ã‚‹ï¼ŒãŸã‚“ã½ã½ã‚°ãƒ«ãƒ¼ãƒ—è§£æžãƒãƒ¼ãƒ ã®çŸ³å·æœ‰ã§ã™ï¼Ž ã“ã®ãƒ–ãƒã‚°ã§ã¯ãŠé¦´æŸ“ã¿ã®ãŸã‚“ã½ã½ã‚°ãƒ«ãƒ¼ãƒ—ã§ã™ãŒï¼Œ"No More ã€Œåˆºèº«ã®ä¸Šã«ã‚¿ãƒ³ãƒãƒã‚’ã®ã›ã‚‹ä»•äº‹ã€ - å˜ç´”ä½œæ¥ã®ç¹°ã‚Šè¿”ã—ã§é–‹ç™ºè€…ã®æ™‚é–“ã‚’æµªè²»ã—ãªã„ãŸã‚ã«ã€‚"ã¨ã„ã†ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚’æŒã£ã¦ã„ã¾ã™ï¼Žãã®ä¸ã§è§£æžãƒãƒ¼ãƒ ã¯ï¼Œãƒ‡ãƒ¼ã‚¿è§£æžåŸºç›¤ã®æ§‹ç¯‰ï¼Œãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ï¼Œãƒ‡ãƒ¼ã‚¿è§£æžã®ç¤¾å†…ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã‚’è¡Œãªã„æŠ€è¡“ã‹ã‚‰ã®æ”¹å–„ã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ï¼Ž ä»Šå›žã®è¨˜äº‹ã§ã¯ï¼Œmixi ã«ãŠã‘ã‚‹è§£æžåŸºç›¤ã«ã¤ã„ã¦ç°¡å˜ã«è§¦ã‚ŒãŸã‚ã¨ï¼Œãã®åŸºç›¤ã«ãŠã‘ã‚‹ã€Œåˆºèº«ã®ä¸Šã«ã‚¿ãƒ³ãƒãƒã‚’ã®ã›ã‚‹ä»•äº‹ã€ã‚’ã©ã†æ¸›ã‚‰ã™ã‹ã®ï¼’ç‚¹ã«ã¤ã„ã¦æ›¸ãã¾ã™ï¼Ž mixi ã®è§£æžåŸºç›¤ ã¾ãšã¯è§£æžç’°å¢ƒã«ã¤ã„ã¦ï¼Œç°¡å˜ã«ãŠè©±ã—ã¾ã™ï¼Ž2012-08 ç¾åœ¨ mixi ã§ã¯ï¼Œä¸»ãªè§£æžç”¨ã®ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã¯ï¼ŒApache Hadoop, Hive ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ï¼Žã¾ãŸã‚ã‚ã›ã¦ï¼Œè‡ªåˆ†ãªã©ä¸€éƒ¨ã®äººã¯ï¼Œ
jay777 2012/08/12
Hive

mixi

Hadoop

JSON

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€ŽHadoop/Hiveã‚’ç”¨ã„ãŸãƒã‚°è§£æžåŸºç›¤ã®æ§‹ç¯‰ã€
ã“ã‚“ã«ã¡ã¯ã€‚Amebaã®ãƒã‚°è§£æžåŸºç›¤ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ICHIROã§ã™ã€‚ ä»Šå›žã¯æ§‹ç¯‰ãƒ»é‹ç”¨ä¸ã®ãƒã‚°è§£æžåŸºç›¤ã€ŒPatriotã€ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ Webã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹å–¶ã—ã¦ã„ã‚‹ã¨æ—¥ã€…å¤§é‡ã®ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¾ã™ã€‚ ä»Šã¾ã§ã¯PVï¼ˆãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼‰ã‚„UUï¼ˆãƒ¦ãƒ‹ãƒ¼ã‚¯ãƒ¦ãƒ¼ã‚¶ï¼‰ãªã©ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ãªã©ã‹ã‚‰å–ã‚Œã‚‹ã€å¤§æž ã®æŒ‡æ¨™ã®ã¿ã‚’è¦‹ã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ã§ã—ãŸã€‚ ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã«åˆã‚ã›ã¦ã‚·ã‚¹ãƒ†ãƒ ã‚’å¢—å¼·ã™ã‚‹ãªã©ã€ã‚·ã‚¹ãƒ†ãƒ å´ã¨ã—ã¦ã¯ååˆ†ã¨ã‚‚è¨€ãˆã‚‹æŒ‡æ¨™ã§ã™ãŒã€åºƒå‘Šã‚„èª²é‡‘ã‚µãƒ¼ãƒ“ã‚¹ã¨ã„ã†è¦–ç‚¹ã‹ã‚‰è¦‹ã‚‹ã¨ååˆ†ã¨ã¯è¨€ãˆã¾ã›ã‚“ã€‚ ä»Šã¾ã§ã¯Amebaå†…ã®å€‹ã€…ã®ã‚µãƒ¼ãƒ“ã‚¹æ‹…å½“è€…ãŒå¿…è¦ã¨ã™ã‚‹æŒ‡æ¨™ã‚’å‡ºã™ãŸã‚ã«ã‚¢ãƒ—ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚„DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«éƒ½åº¦ä¾é ¼ã‚’ã™ã‚‹å½¢ã§ãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ã¦ã„ã¾ã—ãŸã€‚ ä»Šå¾Œã®èª²é‡‘ã‚µãƒ¼ãƒ“ã‚¹ã®ç™ºå±•ãŒè¦‹è¾¼ã¾ã‚Œã€ã‚ˆã‚Šãƒ‡ãƒ¼ã‚¿åˆ†æžã®é‡è¦æ€§ãŒé«˜ã¾ã‚‹ã¨è€ƒãˆãŸç§ã¯ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ãªã„ã‚µãƒ¼ãƒ“ã‚¹æ‹…å½“è€…ï¼ˆä¸»ã«ãƒ—ãƒãƒ‡ãƒ¥ãƒ¼ã‚µï¼‰ãŒã‚ˆã‚Šç°¡å˜
jay777 2012/01/10
Hadoop

Hive
ãƒªãƒ³ã‚¯
1