Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 1 to 10 from 17 (0.213s).
Loading phrases to help you
refine your search...
Re: Setting limits for hive users - Hive - [mail # user]
...I would recommend looking at Hive Strict Mode first. It helps users thinkabout their queries by throwing errors for certain operations that may beunexpectedly bad, like a full table scan ove...
   Author: Matt Tucker, 2014-04-23, 14:44
[HIVE-5904] HiveServer2 JDBC connect to non-default database - Hive - [issue]
...When connecting to HiveServer to via the following URLs, the session uses the 'default' database, instead of the intended database.jdbc://localhost:10000/customDbjdbc:///customDb...
http://issues.apache.org/jira/browse/HIVE-5904    Author: Matt Tucker, 2014-03-23, 17:49
Re: Dynamic columns in Hive Table - Best Design for the problem - Hive - [mail # user]
...It looks like you're essentially doing a pivot function. Your best bet is to write a custom UDAF or look at the windowing functions available in recent releases.  Matt On Dec 28, 2013 1...
   Author: Matt Tucker, 2013-12-28, 19:46
Re: HQL *_utc_timestamp functions' timezone parameter? - Hive - [mail # user]
...Hi Mark,  I ran into the same issue last week, and ended up writing a small app to print the results of getAvailableIDs()in java.util.TimeZone.  Having to convert from GMT to Pacif...
   Author: Matt Tucker, 2013-06-07, 20:14
Re: .sql vs. .hql - Hive - [mail # user]
...Hi Keith,  In regards to filename conventions, there isn't a hard requirement to use a specific extension.  Aside from the two extensions already mentioned ('.hql','.sql'), there i...
   Author: Matt Tucker, 2013-05-31, 21:01
Re: Variable Substitution - Hive - [mail # user]
...I'm fine with the variable placeholder not being removed in cases where the variable is not defined (until I change my mind). When I define var2 and var3, though, their placeholders aren't s...
   Author: Matt Tucker, 2013-03-06, 21:50
HIVE-2915: Partitioned Tables in Hive Metastore - Hive - [mail # user]
...Hi,  I'm currently using CDH3u3 and Hive 0.7.1, and I'm looking into how the metadata is stored for partitioned tables within the RDBMS.  The issue that I see is that for tables wi...
   Author: Matt Tucker, 2013-01-17, 16:03
Re: hive regular expression - Hive - [mail # user]
...Parse_url and str_to_map may offer an alternative worth looking into.  On Dec 26, 2012, at 1:50 PM, Dean Wampler  wrote:  ...
   Author: Matt Tucker, 2012-12-26, 21:00
Re: Any existing UDTF to flatten map - Hive - [mail # user]
...I ended up getting an error (Hive 0.7.1), but I would have thought something like the following would work:  SELECT     user_id,     obj_key,     obj[obj_k...
   Author: Matt Tucker, 2012-11-30, 19:39
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
Hive (17)
mail # user (16)
issue (1)
last 7 days (1)
last 30 days (1)
last 90 days (2)
last 6 months (3)
last 9 months (17)
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 (157)
Kevin Wilfong (152)
He Yongqiang (139)
Xuefu Zhang (135)
Matt Tucker