Home | About | Sematext search-lucene.com search-hadoop.com
clear query|facets|time Search criteria: .   Results from 1 to 10 from 16 (0.061s).
Loading phrases to help you
refine your search...
[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
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
Hive (16)
mail # user (15)
issue (1)
last 7 days (0)
last 30 days (1)
last 90 days (1)
last 6 months (2)
last 9 months (16)
Namit Jain (645)
Carl Steinbach (419)
Zheng Shao (382)
Brock Noland (294)
Edward Capriolo (291)
Ashutosh Chauhan (261)
Navis (248)
John Sichi (212)
Gunther Hagleitner (197)
Thejas M Nair (178)
Ning Zhang (170)
Lefty Leverenz (159)
Kevin Wilfong (152)
He Yongqiang (139)
Xuefu Zhang (134)
Matt Tucker