Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 11 to 18 from 18 (0.081s).
Loading phrases to help you
refine your search...
Re: need help on writing hive query - Hive - [mail # user]
...I did a similar query a few months ago.  In short, I left-padded the page na me with the time stamp, grouped with collect_set, and then used sort_array() .  There was some other cl...
   Author: Matt Tucker, 2012-10-31, 21:53
Re: HIVE NOT EXISTS - Hive - [mail # user]
...Hi Mohit,    Hive doesn’t support correlated subqueries.  In this instance, you  can do a left outer join to find values that are not in a table.    SELECT &nbs...
   Author: Matt Tucker, 2012-10-01, 22:43
Re: Load XML file into HIVE - Hive - [mail # user]
...Hi,  I was working on this several months ago, and ended up having to flatten eac h XML document to one root node per line. I believe that the other option wo uld be to write a custom I...
   Author: Matt Tucker, 2012-08-30, 23:25
Re: Passing date as command line arguments - Hive - [mail # user]
...Hi,  In the command line, you want to wrap 20120709 in double-quotes, as they get  stripped when being passed into the hiveconf variable.  Matt    On Aug 3, 2012, at...
   Author: Matt Tucker, 2012-08-04, 02:15
Re: Dates in Hive - Hive - [mail # user]
...I don't have the language manual in frot of me, but I would suggest casting d ateint to string, then using the unix_timestamp function. From_unixtime shou ld get it back into a date time str...
   Author: Matt Tucker, 2012-06-26, 00:10
Re: Partition deletion w/out using a literal partition value - Hive - [mail # user]
...Hive 0.8.0 has metadata optimizations ([HIVE-1003]), but your best bet is to write a shell script that executes 'show partitions ;', and then loop through the results and drop any partitions...
   Author: Matt Tucker, 2012-02-05, 22:40
Re: move tables into different database - Hive - [mail # user]
...Someone recently posted a command to convert a managed table to an external t able. If you also use that command, there's no expensive copy operation.  You'd probably want to move the d...
   Author: Matt Tucker, 2012-01-31, 01:52
Re: split into less files - Hive - [mail # user]
...It sounds like you want to look at setting hive.merge.mapredfiles to true in  your hive-site.xml.  Just be aware that it will likely add another map step to your jobs to conso lida...
   Author: Matt Tucker, 2011-11-09, 03:05
Hive (18)
mail # user (17)
issue (1)
last 7 days (0)
last 30 days (0)
last 90 days (0)
last 6 months (3)
last 9 months (18)
Namit Jain (645)
Carl Steinbach (416)
Brock Noland (391)
Zheng Shao (382)
Ashutosh Chauhan (338)
Edward Capriolo (297)
Navis (288)
Gunther Hagleitner (231)
Thejas M Nair (217)
Lefty Leverenz (214)
John Sichi (212)
Xuefu Zhang (204)
Ning Zhang (171)
Kevin Wilfong (152)
Sergey Shelukhin (148)
Harish Butani (143)
He Yongqiang (139)
Jason Dere (130)
Thejas Nair (126)
Eugene Koifman (123)
Szehon Ho (119)
Nitin Pawar (112)
Eric Hanson (108)
Vaibhav Gumashta (108)
Prasad Mujumdar (106)
Matt Tucker