| clear query|facets|time |
Search criteria: .
Results from 11 to 20 from
51 (0.347s).
|
|
|
Loading phrases to help you
refine your search...
|
|
Re: Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...This is a little tricky but this is how it works: SELECT buyer_id, item_id, rank(item_id), created_time FROM ( SELECT buyer_id, item_id, created_time FROM t...
|
|
|
Author: Vijay,
2012-07-10, 23:01
|
|
|
Re: What's wrong with this query? - Hive - [mail # user]
|
|
...to_date(from_unixtime(cast(timestamps as int))) On Tue, Jul 10, 2012 at 1:33 PM, Raihan Jamal wrote:...
|
|
|
Author: Vijay,
2012-07-10, 20:41
|
|
|
Re: What's wrong with this query? - Hive - [mail # user]
|
|
...You need to use from_unixtime() On Tue, Jul 10, 2012 at 1:01 PM, Raihan Jamal wrote:...
|
|
|
Author: Vijay,
2012-07-10, 20:28
|
|
|
Re: Invalid Function rank in HiveQL - Hive - [mail # user]
|
|
...hive has no built-in rank function. you'd need to use a user-defined function (UDF) to simulate it. there are a few custom implementations on the net that you can leverage. On Mon, Jul...
|
|
|
Author: Vijay,
2012-07-10, 05:51
|
|
|
Re: Always mysterious "Could not obtain block" error for large jobs [Hive 0.8.1/ Hadoop 1.0.0 on Mac Mini Cluster] - Hive - [mail # user]
|
|
...Another critical variable to check is dfs.datanode.max.xcievers. The default value is 256. You should bump that up to 4096 or higher. -Vijay On Thu, Mar 1, 2012 at 7:07 PM, Abhis...
|
|
|
Author: Vijay,
2012-03-02, 22:50
|
|
|
Re: Regex and serde with hive - Hive - [mail # user]
|
|
...If the format is simply delimited like this, you don't need to use the RegexSerde. Hive's default format with the right "FIELDS TERMINATED BY" setting will work great. -Vijay On ...
|
|
|
Author: Vijay,
2011-12-23, 07:30
|
|
|
Cannot use explode with sub queries? - Hive - [mail # user]
|
|
...I can't seem to use explode with subqueries. This is what I'm trying: select user, requestid from ( select user, requestid_list from logs where ... ) t lateral view explo...
|
|
|
Author: Vijay,
2011-11-03, 23:36
|
|
|
Re: SerDe question - Hive - [mail # user]
|
|
...There are a couple of problems. First of all, input.regex needs to be "(\\w+)". Please note the case. The bigger problem though, is that, with this (and most) serdes, you can only expect one...
|
|
|
Author: Vijay,
2011-09-28, 04:18
|
|
|
Re: Help with last 30 day unique user query - Hive - [mail # user]
|
|
...Thanks Alex! That is exactly what I thought was the limitation but wanted to make sure I'm not missing anything. On Fri, Oct 15, 2010 at 10:51 AM, Alex Boisvert wrote: ...
|
|
|
Author: Vijay,
2010-10-15, 18:19
|
|
|
Re: Help with last 30 day unique user query - Hive - [mail # user]
|
|
...Thanks, Ning! Finding the date which is 30 days before/later was easy enough but my problem is beyond that. I need to find unique users based on these last 30 days for a range of days. Does ...
|
|
|
Author: Vijay,
2010-10-15, 16:43
|
|
|
|
