Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 21 to 30 from 108 (0.138s).
Loading phrases to help you
refine your search...
Re: Slow performance on queries with aggregation function - Hive - [mail # user]
...Hi Jone,um.  i can say for sure something is wrong. :)i would _start_ by going to the tasktracker. this is your friend.  findyour job and look for failed reducers.  That's the...
   Author: Stephen Sprague, 2014-02-22, 04:25
[expand - 1 more] - Re: Hive Query :: Implementing case statement - Hive - [mail # user]
...Hi Yogesh,i overlooked one thing and for completeness we should make note of it here.change:   select a.* from TABLE_SQL a join NEW_BALS b on (a.key=b.key) whereb.NEW_BALANCE is nu...
   Author: Stephen Sprague, 2014-02-20, 05:16
[expand - 9 more] - Re: Issue with Hive and table with lots of column - Hive - [mail # user]
...ok. thanks.so given everything we know the choices i see are:1. increase your heapsize some more. (And of course confirm your processthat your reported the -Xmx8192M is the HiveServer2 proce...
   Author: Stephen Sprague, 2014-02-19, 15:54
Re: Views and partitions and performance - Hive - [mail # user]
...great questions, Burak.  Personally, I had not before seen the "create view... partition on" construct. Not that that means anything but thanks forbringing bringing out into the forefro...
   Author: Stephen Sprague, 2014-02-11, 19:10
Re: FUNCTION HIVE to DAYS OF WEEK - Hive - [mail # user]
...oddly enough i don't see one here:https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctionshowever, you're not the only one finding something like t...
   Author: Stephen Sprague, 2014-02-10, 21:39
Re: Finding Hive and Hadoop version from command line - Hive - [mail # user]
...I like:hive version:  $ schematool -info -dbType hadoop version:  $ hadoop versionLefty recently plugged schematool not long ago so props to her on that one.Under the covers you'll...
   Author: Stephen Sprague, 2014-02-09, 21:11
Re: Joins between databases - Hive - [mail # user]
...ahh. we got ourselves a bona-fide head banger.  Welcome to the club!! :)select    a.col1 as foo,    a.col2 as bar,    a.col3 as bazfrom ...
   Author: Stephen Sprague, 2014-02-07, 01:10
Re: Hive Query Error - Hive - [mail # user]
...file this one under RTFM.On Wed, Feb 5, 2014 at 9:11 AM, Nitin Pawar  wrote:> its create table xyz stored as sequencefile as select blah from table>>> On Wed, Feb 5, 2014 at...
   Author: Stephen Sprague, 2014-02-05, 21:15
Re: FW: Big table join optimization - Hive - [mail # user]
...lets see the minimal query that shows your problem with some comments aboutcardinality of the tables in the join. maybe there could be a crudeworkaround using a temp table or some such devic...
   Author: Stephen Sprague, 2014-01-31, 01:43
Re: DESCRIBE EXTENDED show numRows=0 - Hive - [mail # user]
...the answer to this would seemingly be no.  i just tried it in hive v0.12.numRows=0 before and numRows=0 after my running of "analyze table compute statistics"other values are populated ...
   Author: Stephen Sprague, 2014-01-30, 05:38
Hive (108)
Kafka (1)
mail # user (105)
mail # dev (3)
last 7 days (0)
last 30 days (1)
last 90 days (4)
last 6 months (5)
last 9 months (108)
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)
Stephen Sprague