回复: Re: Hive-Hadoop compatibility

2012-05-09 Thread ylyy-1985
can work, but not perfect. If you want to use hive thrift server, I suggest using hadoop 0.20, and this will save you a lot of time. 2012-05-10 Best Regards Andes 发件人:ljh flf 发送时间:2012-05-10 08:47 主题:Re: Hive-Hadoop compatibility 收件人:"user" 抄送: Hive 0.8.1 can work with hadoop 1.0.0 On T

possible to accelerate hive query?

2012-04-25 Thread ylyy-1985
hi all, I think it possible to accelerate hive query by set hive.mapper.reduce to a bigger number. But according to some doc, the setting is only available in one session. how can I make it global available? 2012-04-26 Best Regards Andes

how to manage the result set?

2012-04-18 Thread ylyy-1985
I have managed to get the hbase table throught hive using: ResultSet rs = stmt.executeQuery("select split(value,',') from table1"); but how is the result set look like? and if I want to put this result set back to hive table,how to mangage this using java code? thanks in advanced! 2012-04-19

回复: Re: how to split the value of hbase into hive

2012-04-18 Thread ylyy-1985
quot;user" 抄送: you can use the inbuilt udf split(string str, string pat) to split the string with the separator you want. It returns the array and you can access the array and insert array elements in the hive table On Wed, Apr 18, 2012 at 1:06 PM, ylyy-1985 wrote: hi,all; I have a pr

回复: Re: how to split the value of hbase into hive

2012-04-18 Thread ylyy-1985
string str, string pat) to split the string with the separator you want. It returns the array and you can access the array and insert array elements in the hive table On Wed, Apr 18, 2012 at 1:06 PM, ylyy-1985 wrote: hi,all; I have a problem. I have an hbase table, with key-value pair like

回复: RE: to change hive delimiter->'||'

2012-04-13 Thread ylyy-1985
er delimiters work with Hive, but you might try escaping each pipe (“\|\|”). I had a similar issue with using pipes in str_to_map(). Matt Tucker From: ylyy-1985 [mailto:ylyy-1...@163.com] Sent: Friday, April 13, 2012 9:24 AM To: hive_user Subject: to change hive delimiter->'||'

to change hive delimiter->'||'

2012-04-13 Thread ylyy-1985
hi, all. I see something strange. the defaule delimiter is \001 and I want to change to '||'. So I just run my command : CREATE TABLE table1( channelid INT,serviceno STRING,regid STRING,pageurl STRING,urlext STRING,pagetitle STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '||' stored as textf

回复: Can hive-0.8.0 could work with HBase-0.9.2 and Zookeeper-3.4.2?

2012-04-13 Thread ylyy-1985
I would tell that system works with : hadoop0.20,hbase-0.90.3,hibve-0.8.1 and zookeeper-3.3.3. good luck 2012-04-13 Best Regards Andes Email:ylyy-1...@163.com 发件人:Bing Li 发送时间:2012-04-13 18:35 主题:Can hive-0.8.0 could work with HBase-0.9.2 and Zookeeper-3.4.2? 收件人:"dev","user" 抄送: Hi, guys

回复: Re: cannot start the thrift server

2012-04-10 Thread ylyy-1985
not like the hive command disable. The console will only produce output when you have a job running through thrift server. If you want to use CLI, just run $HIVE_PATH/bin/hive Best regards Nguyen Thanh Binh (Mr) Cell phone: (+84)98.226.0622 From: ylyy-1985 [mailto:ylyy-1...@163.com] Sent: Wednesday

回复: RE: Re: cannot start the thrift server

2012-04-10 Thread ylyy-1985
t;, "mine"); 2012-04-11 Andes 发件人:binhnt22 发送时间:2012-04-11 10:13 主题:RE: Re: cannot start the thrift server 收件人:"user" 抄送: Hi ylyy You should add hadoop-core-*.jar file in hadoop distribution directory into your project Best regards Nguyen Thanh Binh (Mr) From: ylyy-19