hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Namit Jain <nj...@facebook.com>
Subject RE: Problem about 'like' condition
Date Tue, 13 Apr 2010 01:28:10 GMT
I meant hive/hadoop conf.


From: 朱鹤群 [mailto:zhuhequn@baixing.com]
Sent: Monday, April 12, 2010 5:59 PM
To: hive-user@hadoop.apache.org
Subject: Re: Problem about 'like' condition

Do you mean hadoop conf of hive DDL?
在 2010年4月13日 上午8:39,Namit Jain <njain@facebook.com<mailto:njain@facebook.com>>写道:
Can you send your conf ?

From: 朱鹤群 [mailto:zhuhequn@baixing.com<mailto:zhuhequn@baixing.com>]
Sent: Monday, April 12, 2010 5:35 PM

To: hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org>
Subject: Re: Problem about 'like' condition

Hi namit,

No, I'm using TEXTFILE input format.
Yes. My files are gzip files.

Thanks,
Gary
在 2010年4月13日 上午2:20,Namit Jain <njain@facebook.com<mailto:njain@facebook.com>>写道:
Are you using CombineHiveInputFormat ?
And are you using compressed text files ?


Thanks,
-namit


From: 朱鹤群 [mailto:zhuhequn@baixing.com<mailto:zhuhequn@baixing.com>]
Sent: Monday, April 12, 2010 12:53 AM
To: hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org>
Subject: Problem about 'like' condition

Hi,

Has anybody got problem when query in hive with condition (field like '%string%')?
I got problem that the return records are duplicated.

My hadoop cluster has 1 namenode, 1 jobtracker and 3 slaves. On each slave, there is 2 mappers
and 2 reducers.
All data are kept in gz file.
In this case, the record duplicated for 15 times.
Will anybody give some clue? Thanks.

--
Best Regards,
Gary Zhu



--
Best Regards,
Gary Zhu 朱鹤群



--
Best Regards,
Gary Zhu 朱鹤群
Mime
View raw message