| clear query|facets|time |
Search criteria: .
Results from 51 to 60 from
66 (0.326s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Find TOP 10 using HiveQL - Hive - [mail # user]
|
|
...I am trying that solution. Currently I am running my query to see what result I am getting back with UDF. *Raihan Jamal* On Tue, Jul 10, 2012 at 12:13 AM, Nitin Pa...
|
|
|
Author: Raihan Jamal,
2012-07-10, 07:15
|
|
|
Re: Find TOP 10 using HiveQL - Hive - [mail # user]
|
|
...Problem with that approach is, with LIMIT 10, If I am putting after desc, then it will get only 10 rows irrespective of BUYER_ID. But I need specifically for each BUYER_ID 10 latest rows. &n...
|
|
|
Author: Raihan Jamal,
2012-07-10, 07:08
|
|
|
Re: Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...I was not able to understand, This is my below qiuery that I am using currently- SELECT buyer_id, item_id, created_time FROM ( SELECT buyer_id, item_id, rank(buyer_id) as...
|
|
|
Author: Raihan Jamal,
2012-07-10, 07:00
|
|
|
Re: Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...Thanks for commenting out. Yes I figured that out, its a UDF. So now I have created a new UDF Rank and added to classpath also. But when I am again running the below query- SELECT buye...
|
|
|
Author: Raihan Jamal,
2012-07-10, 06:42
|
|
|
Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...What's wrong with the below query. SELECT buyer_id, item_id, created_time FROM ( SELECT buyer_id, item_id, rank(buyer_id) as rank, created_time FROM testin...
|
|
|
Author: Raihan Jamal,
2012-07-10, 05:40
|
|
|
Re: Find TOP 10 using HiveQL - Hive - [mail # user]
|
|
...This is my below requirement. I need- *Find `TOP 10` data for each `BUYER_ID, *So I cannot use LIMIT 10 here in this case. This is the below table CREATE TABL...
|
|
|
Author: Raihan Jamal,
2012-07-10, 03:06
|
|
|
Find TOP 10 using HiveQL - Hive - [mail # user]
|
|
...When I run this query, SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer_id, created_time DESC; I always get error as- *FAILED: Parse Error: line 1:7 cannot recognize ...
|
|
|
Author: Raihan Jamal,
2012-07-10, 02:30
|
|
|
Re: What's wrong with this query? - Hive - [mail # user]
|
|
...Yup that worked for me. I figure that out after reading the docs, INNER JOIN means JOIN in HiveQL. *Raihan Jamal* On Mon, Jul 9, 2012 at 2:48 PM, Roberto Sanabria ...
|
|
|
Author: Raihan Jamal,
2012-07-10, 00:11
|
|
|
Custom Mapper and Reducer vs HiveQL in terms of Performance - Hive - [mail # user]
|
|
...*Problem Statement:-* I need to compare two tables Table1 and Table2 and they both store same thing. So I need to compare Table2 with Table1 as Table1 is the main table through which c...
|
|
|
Author: Raihan Jamal,
2012-07-09, 22:37
|
|
|
What's wrong with this query? - Hive - [mail # user]
|
|
...I wrote this query but everytime I get the below error. select * from (select t2.buyer_id, t2.item_id, t2.created_time as created_time, subq.user_id, subq.product_id, sub...
|
|
|
Author: Raihan Jamal,
2012-07-09, 18:42
|
|
|
|
