Re: Find TOP 10 using HiveQL

2012-07-10 Thread Wouter de Bie
09 > > > > > 08:23:17 > > > > > 345122015656232360 2012-07-09 07:28:47 > > > > > 345122015639158173 (tel:5639158173) 2012-07-09 > > > > > 06:58:47 > > > > > 34512201

Re: Find TOP 10 using HiveQL

2012-07-10 Thread Raihan Jamal
5868222883 2012-07-09 08:23:17 >>>> 345122015656232360 2012-07-09 07:28:47 >>>> 345122015639158173 2012-07-09 06:58:47 >>>> 345122014645350592 2012-07-09 06:38:47 >>>> 34512201 242205

Re: Find TOP 10 using HiveQL

2012-07-10 Thread Nitin Pawar
;> 345122012422054205 2012-07-09 06:09:56 >>> 1015826235 2100024480352012-07-09 22:21:11 >>> 1015826235 2600035533822012-07-09 19:40:39 >>> 1015826235 2200030380672012-07-09 19:40:21 >>> 1015826235

Re: Find TOP 10 using HiveQL

2012-07-10 Thread Raihan Jamal
33842012-07-09 07:28:47 >> 1015826235 2600035533812012-07-09 07:09:56 >> 1015826235 2600035533832012-07-09 06:58:47 >> 1015826235 2600035533892012-07-09 06:54:37 >> >> >> *Raihan Jamal* >> >&

Re: Find TOP 10 using HiveQL

2012-07-10 Thread Abhishek Tiwari
2012-07-09 07:09:56 > 1015826235 2600035533832012-07-09 06:58:47 > 1015826235 2600035533892012-07-09 06:54:37 > > > *Raihan Jamal* > > > > On Mon, Jul 9, 2012 at 7:56 PM, Andes wrote: > >> ** >> hello, you can use &qu

Re: Find TOP 10 using HiveQL

2012-07-09 Thread Raihan Jamal
--------- > *发件人:*Raihan Jamal > *发送时间:*2012-07-10 10:31 > *主题:*Find TOP 10 using HiveQL > *收件人:*"user" > *抄送:* > > When I run this query, > > SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer_id, created_time > DESC; > > > I

回复: Find TOP 10 using HiveQL

2012-07-09 Thread Andes
hello, you can use "desc" and "limit 10" to filter the top 10. 2012-07-10 Best Regards Andes 发件人:Raihan Jamal 发送时间:2012-07-10 10:31 主题:Find TOP 10 using HiveQL 收件人:"user" 抄送: When I run this query, SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer