Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 11 to 20 from 40 (0.121s).
Loading phrases to help you
refine your search...
Re: Changing table types from managed to external - Hive - [mail # user]
...Try ALTER TABLE  SET TBLPROPERTIES('EXTERNAL'='TRUE');  It worked for me.  igor decide.com  On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth wrote:  ...
   Author: Igor Tatarinov, 2012-08-07, 06:26
Re: schema of hive database - Hive - [mail # user]
...Try describe formatted   igor decide.com  On Thu, Aug 2, 2012 at 12:04 PM, Anson Abraham wrote:  ...
   Author: Igor Tatarinov, 2012-08-02, 19:13
Nested SELECT DISTINCT runs out of memory - Hive - [mail # user]
...I have this query that consistently fails with out-of-memory errors. I know it can be re-written without a nested subquery (using count distinct) and then it runs fine.  Why does this q...
   Author: Igor Tatarinov, 2012-07-26, 18:40
Re: Hive query optimization - Hive - [mail # user]
...Here is my 2 cents. The parameters you are looking at are quite specific. Unless you know what you are doing it might be hard to set them exactly right and they shouldn't make that much of a...
   Author: Igor Tatarinov, 2012-07-24, 04:51
Re: Performance Issues in Hive with S3 and Partitions - Hive - [mail # user]
...Are you using EMR? Have you tried  setting Hive.optimize.s3.query=true  as mentioned in http://docs.amazonwebservices.com/ElasticMapReduce/latest/DeveloperGuide/emr-hive-version-de...
   Author: Igor Tatarinov, 2012-07-24, 04:37
[expand - 2 more] - Re: Something wrong with my query to get TOP 3? - Hive - [mail # user]
...Actually, never mind. Looks like you need to partition by both bid and pid. In that case, your problem is that rank() has to handle a combined bid+pid key. So first you need to create a comb...
   Author: Igor Tatarinov, 2012-07-19, 23:00
Re: Obvious and not so obvious query optimzations in Hive - Hive - [mail # user]
...If you are optimizing for latency (running time) as opposed to throughput, it's best to have a single "wave" of reducers. So if your cluster is setup with a limit of, say, 2 reducers per nod...
   Author: Igor Tatarinov, 2012-06-27, 22:44
Re: some queries actually fail in hive - Hive - [mail # user]
...1) You have to SELECT every column you ORDER BY (id in this case)  2) the query is the same as in 1) - I assume  you actually ran a different query  igor decide.com  On M...
   Author: Igor Tatarinov, 2012-06-25, 16:43
Re: subquery syntax error - Hive - [mail # user]
...The columns you ORDER BY must be SELECTed. If you don't want identifier2 in the output, you will need to wrap your query with another SELECT.  Hope this helps. igor decide.com  On ...
   Author: Igor Tatarinov, 2012-06-06, 06:22
Re: Need help with simple subquery - Hive - [mail # user]
...Try replacing the comma with JOIN  igor decide.com  On Mon, May 28, 2012 at 6:48 AM, shan s  wrote:  ...
   Author: Igor Tatarinov, 2012-05-28, 22:28
Hive (40)
mail # user (40)
last 7 days (0)
last 30 days (0)
last 90 days (0)
last 6 months (0)
last 9 months (40)
Namit Jain (645)
Carl Steinbach (416)
Brock Noland (399)
Zheng Shao (382)
Ashutosh Chauhan (348)
Edward Capriolo (297)
Navis (292)
Gunther Hagleitner (235)
Thejas M Nair (221)
Xuefu Zhang (215)
Lefty Leverenz (213)
John Sichi (212)
Ning Zhang (171)
Sergey Shelukhin (158)
Kevin Wilfong (152)
Thejas Nair (151)
Harish Butani (145)
He Yongqiang (139)
Jason Dere (136)
Eugene Koifman (125)
Szehon Ho (121)
Vaibhav Gumashta (116)
Nitin Pawar (114)
Alan Gates (110)
Eric Hanson (108)
Igor Tatarinov