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

2012-04-13 Thread Bing Li
Are the failures ONLY caused by Test case? 在 2012年4月14日 上午1:14,Bing Li 写道: > thanks, Andes > > > 2012/4/13 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 >> -- >> ** >

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

2012-04-13 Thread Bing Li
thanks, Andes 2012/4/13 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 > ** > -- >

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

2012-04-13 Thread ylyy-1985
I had tried this, but not work. and the sys works with '|'. 2012-04-13 Best Regards Andes Email:ylyy-1...@163.com 发件人:Tucker, Matt 发送时间:2012-04-13 21:32 主题:RE: to change hive delimiter->'||' 收件人:"user@hive.apache.org" 抄送: I’m not sure how multiple-character delimiters work with Hive, but

Re: to change hive delimiter->'||'

2012-04-13 Thread Edward Capriolo
You can not have a '||' with the delimted serde. Just insert dummy columns in your DML. id - name 5 || bob create table people ( id int, dummy1 string , name string) On Fri, Apr 13, 2012 at 9:30 AM, Tucker, Matt wrote: > I’m not sure how multiple-character delimiters work with Hive, but you mi

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

2012-04-13 Thread Tucker, Matt
I’m not sure how multiple-character 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

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

Re: Incremental import from PostgreSQL to Hive having issues

2012-04-13 Thread Nitin Pawar
Hi Roshan, I guess you are using sqoop version older than 17. You are facing similar issue mentioned in SQOOP-216 You can try to delete the directory already existing. Thanks, Nitin On Fri, Apr 13, 2012 at 6:12 PM, Roshan Pradeep wrote: > Hadoop

回复: 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: Incremental import from PostgreSQL to Hive having issues

2012-04-13 Thread Roshan Pradeep
Hadoop - 0.20.2 Hive - 0.8.1 Thanks. On Fri, Apr 13, 2012 at 5:03 PM, Nitin Pawar wrote: > can you tell us what is > 1) hive version > 2) hadoop version that you are using? > > > > > > On Fri, Apr 13, 2012 at 12:23 PM, Roshan Pradeep wrote: > >> Hi >> >> I want to import the updated data from my

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

2012-04-13 Thread Bing Li
Hi, guys I ran Hive-0.8.0 UT with - Hadoop-1.0.0 ( applied patches for HIVE-2631 and HIVE-2629) - HBase-0.92.0 - Zookeeper-3.4.2 But got the following error message: [echo] Project: hbase-handler [junit] Running org.apache.hadoop.hive.cli.TestHBaseCliDriver [junit] org.apache.hadoop.

Can hive-0.8.0 could work with HBase-0.92.0 and Zookeeper-3.4.2

2012-04-13 Thread Bing Li
Hi, guys Currently, I run hive-0.8.0 UT with - hadoop-1.0.0 (apply patchs for HIVE-2631 and HIVE-2629 - hbase-0.92.0 - zookeeper-3.4.2 But got the following error messages: [echo] Project: hbase-handler [junit] Running org.apache.hadoop.hive.cli.TestHBaseCliDriver [junit] org.apache.

Re: Incremental import from PostgreSQL to Hive having issues

2012-04-13 Thread Nitin Pawar
can you tell us what is 1) hive version 2) hadoop version that you are using? On Fri, Apr 13, 2012 at 12:23 PM, Roshan Pradeep wrote: > Hi > > I want to import the updated data from my source (PostgreSQL) to hive > based on a column (lastmodifiedtime) in postgreSQL > > *The command I am using