Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 21 to 30 from 40 (0.092s).
Loading phrases to help you
refine your search...
Re: changing field delimiter for an existing table? - Hive - [mail # user]
...That's exactly what I was looking for! Thanks!  On Fri, May 11, 2012 at 5:34 PM, David Kulp  wrote:  ...
   Author: Igor Tatarinov, 2012-05-12, 06:28
create external table as select with location? - Hive - [mail # user]
...Is it possible to do something like this:  CREATE EXTERNAL TABLE T LOCATION 's3://...' AS SELECT ...;  I would rather not fix the schema for T so that I can easily change the SELEC...
   Author: Igor Tatarinov, 2012-04-04, 17:33
Re: order by having no effect?! - Hive - [mail # user]
...You have attributevalue in quotes which makes it a constant literal.  igor decide.com  On Tue, Mar 13, 2012 at 1:54 PM, Keith Wiley  wrote:  ...
   Author: Igor Tatarinov, 2012-03-13, 20:57
Re: create table LIKE for external tables? - Hive - [mail # user]
...Thanks, I should have tried adding "external" before asking :)  Although, it doesn't work in EMR Hive. Table B is still 'described' as managed so I had to run  alter table B set tb...
   Author: Igor Tatarinov, 2012-03-06, 06:39
Re: Last value for a column - Hive - [mail # user]
...I don't think there is a better way to implement your query using the standard SQL/Hive.  A python reducer (or a java UDF) is the way to go.  I don't think clustering would help si...
   Author: Igor Tatarinov, 2012-01-26, 20:08
dropping an "external" table without deleting the data - Hive - [mail # user]
...I keep making the same mistake of creating an external table without saying "EXTERNAL". As a result, as you can imagine, I am stuck with a table that I cannot drop or I'll lose the external ...
   Author: Igor Tatarinov, 2012-01-24, 23:54
Re: Performance problems with Hive script - Hive - [mail # user]
...To compute moving averages, you should implement a custom reducer instead of doing a big join. That will work *much* faster.  Also, Hive already has date_add(). Why did you have to impl...
   Author: Igor Tatarinov, 2012-01-24, 07:26
Re: Help with a table located on s3n - Hive - [mail # user]
...Also, in EMR the default file system for reading regular files is s3 rather than s3n (the latter is a block file system requiring its own bucket or something like that). Basically, s3 and s3...
   Author: Igor Tatarinov, 2011-12-16, 06:48
Re: Confusion about IN clause - Hive - [mail # user]
...I think the doc refers to an IN subquery WHERE x IN (SELECT blah FROM ...)  the simple WHERE col IN ('x', 'y', 'z') works fine.  I  imagine none of these work: http://www.dba-...
   Author: Igor Tatarinov, 2011-12-13, 06:19
Re: CombineHiveInputFormat and Merge files not working for compressed text files - Hive - [mail # user]
...I might be wrong but I think EMR inserts a reduce job when writing data into S3. At least in my case, I am able to create a single output file by  SET mapred.reduce.tasks = 1; INSERT OV...
   Author: Igor Tatarinov, 2011-11-30, 08:07
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 (418)
Zheng Shao (382)
Brock Noland (292)
Edward Capriolo (292)
Ashutosh Chauhan (263)
Navis (248)
John Sichi (212)
Gunther Hagleitner (197)
Thejas M Nair (181)
Ning Zhang (170)
Lefty Leverenz (159)
Kevin Wilfong (152)
He Yongqiang (139)
Xuefu Zhang (135)
Igor Tatarinov