[B! hive] sessanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sessan id:sessan

hiveã«é–¢ã™ã‚‹sessanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

HiveQL SerDeãƒ¡ãƒ¢(Hishidama's Apache Hive SerDe Memo)
æ¦‚è¦ Hiveã§ã¯SequenceFileã§ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿æ›¸ãã§ãã‚‹ãŒã€ãƒ•ã‚¡ã‚¤ãƒ«å†…ã®å®Ÿãƒ‡ãƒ¼ã‚¿ã¯1è¡ŒãŒ1ã¤ã®Textã¨ãªã‚‹ã€‚ Textã§ãªãè‡ªåˆ†ã§ä½œã£ãŸWritableã‚’ãƒ‡ãƒ¼ã‚¿ã«ã—ãŸã„å ´åˆã«ã€Hiveã®SerDeã‚’å®šç¾©ã™ã‚‹ã€‚ SerDeã¯Serialize/Deserializeã®ç•¥ã§ã€ãƒ‡ãƒ¼ã‚¿ã‚’å…¥å‡ºåŠ›ã§ãã‚‹å½¢å¼ã«å¤‰æ›ã™ã‚‹ã‚¯ãƒ©ã‚¹ã®ã“ã¨ã€‚ SerDeã‚’ä½œã‚‹ã«ã¯org.apache.hadoop.hive.serde2.SerDeã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã‚’å®Ÿè£…ã™ã‚‹ã€‚ ãã—ã¦CREATE TABLEã§SerDeã‚¯ãƒ©ã‚¹ã‚’æŒ‡å®šã™ã‚‹ã€‚ Writableã‚¯ãƒ©ã‚¹ ä¸€ç•ªæœ€åˆã«ã€ãƒ‡ãƒ¼ã‚¿ä¿å˜ã«ä½¿ã†Writableã‚¯ãƒ©ã‚¹ã‚’ä½œã£ã¦ãŠãã€‚ ä»Šå›žã¯ä¾‹ã¨ã—ã¦WordCountã®ãƒ‡ãƒ¼ã‚¿ï¼ˆå˜èªžã¨å˜èªžæ•°ï¼‰ã‚’ä¿æŒã™ã‚‹Writableã‚’ç”¨æ„ã—ã¦ã¿ãŸã€‚ package sample.writable; import java.io.DataIn
sessan 2012/02/15
hiveã®SerDeã®èª¬æ˜Žã€‚æ—¥æœ¬èªžã€éžå…¬å¼æƒ…å ±ã€‚ã§ã‚‚ã€è©³ã—ãæ›¸ã‹ã‚Œã¦ã„ã‚‹ã€‚

hive
ãƒªãƒ³ã‚¯
http://svn.apache.org/repos/asf/hive/trunk/jdbc/src/java/org/apache/hadoop/hive/jdbc/HiveQueryResultSet.java
sessan 2012/02/14
Hiveã®JDBCã®ä¸ã§retrieving next rowã‚’æŠ•ã’ã¦ã„ã‚‹ã‚¯ãƒ©ã‚¹ã€‚å®Ÿè£…ãŒæ€ªã—ã„ã€‚ã€‚173è¡Œç›®ã§ä¾‹å¤–ãŒç™ºç”Ÿã™ã‚‹ã€‚

hive
ãƒªãƒ³ã‚¯
[HIVE-2381] SQLException thrown when the resultset becomes empty. - ASF JIRA
sessan 2012/02/14
Hiveã®JDBCãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã®ãƒã‚°å ±å‘ŠHive-2381ã€‚Error retrieving next rowãŒå‡ºãŸæ™‚ã®ãƒã‚°ã€‚

pentaho

hive
ãƒªãƒ³ã‚¯
[jira] Updated: (HIVE-567) jdbc: integrate hive with pentaho report designer
sessan 2012/02/13
ã“ã‚Œã‚‚pentaho-hiveæŽ¥ç¶šã®ã‚¨ãƒ©ãƒ¼æƒ…å ±ã€‚

pentaho

hive
ãƒªãƒ³ã‚¯
HiveJDBCInterface - Apache Hive - Apache Software Foundation
sessan 2012/02/01
Hive JDBC Driverã‚’Pentahoã«è¨å®šã™ã‚‹æƒ…å ±ãŒè¼‰ã£ã¦ã„ã‚‹å…¬å¼ã‚µã‚¤ãƒˆã€‚

hive
ãƒªãƒ³ã‚¯
HiveServer - Apache Hive - Apache Software Foundation
Thrift Hive ServerHiveServer is an optional service that allows a remote clientÂ to submit requests to Hive, using a variety of programming languages, and retrieve results. HiveServer is built on Apache ThriftTM (http://thrift.apache.org/), therefore it is sometimes called the Thrift server although this can lead to confusion because a newer service named HiveServer2 is also built on Thrift. Since
sessan 2012/02/01
HiveServerã®å…¬å¼èª¬æ˜Ž

hive
ãƒªãƒ³ã‚¯
HiveClient
sessan 2012/02/01
hive clientã®å…¬å¼ãƒšãƒ¼ã‚¸

hive
ãƒªãƒ³ã‚¯
1