Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 21 to 30 from 40 (0.072s).
Loading phrases to help you
refine your search...
[expand - 2 more] - 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
[expand - 1 more] - 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 (416)
Brock Noland (399)
Zheng Shao (382)
Ashutosh Chauhan (348)
Edward Capriolo (298)
Navis (292)
Gunther Hagleitner (235)
Thejas M Nair (221)
Xuefu Zhang (216)
Lefty Leverenz (214)
John Sichi (212)
Ning Zhang (171)
Sergey Shelukhin (158)
Kevin Wilfong (152)
Thejas Nair (149)
Harish Butani (145)
He Yongqiang (139)
Jason Dere (136)
Eugene Koifman (125)
Szehon Ho (121)
Vaibhav Gumashta (116)
Nitin Pawar (113)
Alan Gates (110)
Eric Hanson (108)
Igor Tatarinov