clear query| facets| time Search criteria: .   Results from 11 to 20 from 75 (0.0s).
Loading phrases to help you
refine your search...
[expand - 2 more] - Invalid Function rank in HiveQL - Hive - [mail # user]
...In that case, wouldn't this work:  SELECT buyer_id, item_id, rank(buyer_id), created_time FROM (     SELECT buyer_id, item_id, created_time     FROM testingtable1 &n...
   Author: Vijay , 2012-07-10, 23:37
[expand - 1 more] - 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: > I need only the date not the hours and second, so that is the reason I w...
   Author: Vijay , 2012-07-10, 20:41
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
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
Having trouble using regex serde - Hive - [mail # user]
...The log lines are in some kind of JSON format though. The regex needs to literally match the log lines.  On Fri, Sep 30, 2011 at 8:52 PM, Jonathan  wrote: > Hi, > I am  tryin...
   Author: Vijay , 2011-10-01, 04:14
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
[expand - 1 more] - Problem with non-generic UDAFs and sub queries - Hive - [mail # dev]
...I digged into this more and it doesn't look like this has anything to do with my own UDAFs. All the built-in UDAFs seem to have the same problem. The query below always fails with the except...
   Author: Vijay , 2011-08-01, 18:25
Questions about Hive Database/Schema support - Hive - [mail # dev]
...Hive 0.6 has support for multiple databases/schemas. Is this feature mature enough to be used in production? Are there any particular features known to not work with databases (I know you ca...
   Author: Vijay , 2011-03-29, 01:26
Hive & MS SQL Server - Hive - [mail # user]
...If this is important enough you should probably patch the source code to get this working and then submit a patch so those changes can be rolled into a future version of hive.  My 2 cen...
   Author: Vijay , 2011-03-28, 21:08