Search Discussions
-
I submit a question like this before, but somehow that question is never delivered. I can even find my question in google. Since I cannot find any admin e-mail/feedback form on the hive website that ...
W S Chung
Jun 13, 2011 at 10:47 pm
Jun 15, 2011 at 7:47 pm -
Hey all, Just wondering what the best way is to rename specific Hive table partitions. Is there some HiveQL command for this, or will I need to insert into new partitions to reflect the new naming ...
Jon Bender
Jun 2, 2011 at 4:15 pm
Jun 4, 2011 at 4:56 am -
Hello, We're using hive on amazon elastic mapreduce to process logs on s3, and I had a couple basic questions. Apologies if they've been answered already-- I gathered most info from the hive tutorial ...
Kennon Lee
Jun 28, 2011 at 12:50 am
Jun 30, 2011 at 10:49 pm -
Dear Hive User List, I am trying to build indexes on a hive 0.7.1 environment using postgresql as the metastore, but it is failing silently. The following command doesn't generate any errors: hive ...
Clint Green
Jun 22, 2011 at 6:26 pm
Jun 23, 2011 at 1:12 pm -
hi, Is there any way to comment out hive script file? Either "--" or "/* */" does not seem to work. Thanks in advance,satoshi
Satoshi Yamada
Jun 29, 2011 at 12:37 pm
Jul 7, 2011 at 2:28 pm -
https://cwiki.apache.org/confluence/display/Hive/AdminManual+SettingUpHiveServer is empty and the old link is gone. -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked ...
Ayon Sinha
Jun 27, 2011 at 9:32 pm
Jun 27, 2011 at 9:58 pm -
If I have table timestamps: hive desc timestamps; OK ts bigint hive select ts from timestamps order by ts OK 1 2 3 4 5 6 7 8 9 10 30 32 34 36 38 40 42 44 46 48 50 70 74 78 100 105 110 115 and I want ...
Praveen Kumar
Jun 11, 2011 at 5:30 am
Jun 20, 2011 at 9:06 pm -
Hi all, I have setup a hadoop cluster with 4 nodes running on Centos 5.4 machines. Right now I had configured hive in the master node (hadoop server node) and i am able to run hive queries via jdbc ...
Sangeetha s
Jun 4, 2011 at 9:24 am
Jun 5, 2011 at 5:49 am -
Hey there, With some wiki migration magic from Brock Noland (assisted by Gavin from INFRA), we've moved all of the content from MoinMoin to Confluence. The new location is here: ...
John Sichi
Jun 26, 2011 at 11:23 pm
Jun 28, 2011 at 1:09 am -
I used function collect_set(col) on a table got an array as output. I want to cast it to string for furthur processing. Is there a function to accomplish this. With Regards, Raghav.
Raghav Kumar Gautam
Jun 24, 2011 at 12:50 am
Jun 25, 2011 at 4:20 pm -
Hello , I have setup Hive server (0.6.0) in standalone mode with meta-store in MYSQL. While executing JDBC SQL queries, we discovered that 1. create table fails with error as "table already exists", ...
Vikramsinh Katkar
Jun 21, 2011 at 9:56 am
Jun 23, 2011 at 6:51 am -
Hi Hive Experts I'm facing an issue while using hive Dynamic Partitions on larger tables. I tried out Dynamic partitions on smaller tables and it was working fine but unfortunately when i tried the ...
Bejoy Ks
Jun 16, 2011 at 4:35 pm
Jun 21, 2011 at 12:27 pm -
hey guys i added hive package to my hadoop cluster. if i go into hive cli, i can run hive in remote mode. but queries going through hive server runs in local mode which is really slow... the only ...
Shouguo Li
Jun 3, 2011 at 9:29 pm
Jun 15, 2011 at 4:04 am -
Hi , I am trying to do join on same table. I wanted to do a left outer join However, the results are not like left outer join( with no null values) select T1.field1, T1.field2, T1.field3 T2.field10 ...
Sagar naik
Jun 11, 2011 at 1:56 am
Jun 12, 2011 at 10:49 pm -
3
Index
Hi, I want to test the use of indexes in hive. For this I created anindex, I launched a first query above, I changed the settings on Hive and ran my query on my database table: CREATE INDEX index ON ...Guillaume WEILL
Jun 8, 2011 at 9:29 am
Jun 8, 2011 at 7:10 pm -
The Apache Software Foundation (ASF)'s Travel Assistance Committee (TAC) is now accepting applications for ApacheCon North America 2011, 7-11 November in Vancouver BC, Canada. The TAC is seeking ...
John Sichi
Jun 6, 2011 at 6:12 pm
Jun 7, 2011 at 8:55 pm -
Hi, Just throwing this out to get some good ideas. Is anyone aware of any sink for flume that would write / load data directly to the hive tables? If not, one solution that I could think of is dump ...
Prashanth R
Jun 4, 2011 at 8:23 pm
Jun 6, 2011 at 4:22 am -
I saw this in hadoop wiki: http://wiki.apache.org/hadoop/HowManyMapsAndReduces But in my experiment,I see the different result. When I set the CombineHiveInputFormat in hive and by the doc, the ...
Junxian Yan
Jun 1, 2011 at 7:45 am
Jun 2, 2011 at 6:04 pm -
Hi, I'm new to Hive and hoping someone can help me resolve an issue. I've Googled it, but have not been able to find a solution. Below is my configuration info: Windows XP SP3 Cygwin 1.7.9 Hadoop ...
Sal Scalisi
Jun 28, 2011 at 11:31 pm
Jun 29, 2011 at 3:35 pm -
Sent from my iPhone
Mapred Learn
Jun 23, 2011 at 2:25 pm
Jun 27, 2011 at 7:13 pm -
I'm following the instructions on http://wiki.apache.org/hadoop/Hive/HiveJDBCInterface I have the HiveDriver show up in the list but when I try to connect I get: ClassNotFound for ...
Ayon Sinha
Jun 25, 2011 at 8:00 am
Jun 25, 2011 at 9:21 pm -
I have a table with 3 levels of partitioning and about 10,000 files (one file at every 'leaf'). I am using EMR and the table is stored in S3. For some reason, Hive can't even start running a simple ...
Igor Tatarinov
Jun 21, 2011 at 7:20 am
Jun 21, 2011 at 9:31 pm -
Hi all, I want record the output of every commends executed on hive console client. How to do it ? Thanks. -- dujinhang
Jinhang du
Jun 14, 2011 at 11:46 am
Jun 16, 2011 at 5:16 am -
Hi all, I use hive java client to execute hql. Simple queries like 'select * from table' are answered well. However, when i use join in my query ,exceptions occur. Error log : ...
Jinhang du
Jun 14, 2011 at 11:49 am
Jun 15, 2011 at 4:55 am -
I set mapred.reduce.tasks manually to have a single wave of reducers (does that make sense, by the way?) When I save the data, I often end up with a bunch of small files because we use compression ...
Igor Tatarinov
Jun 29, 2011 at 11:16 pm
Jul 1, 2011 at 11:39 pm -
Hi, I can't seem to make Hive find the Thrift SerDe. What do I need to do? hive add jar /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar; Added /usr/lib/hive/lib/hive-serde-0.7.0-cdh3u0.jar to class ...
Ayon Sinha
Jun 28, 2011 at 6:10 am
Jun 29, 2011 at 5:47 am -
Hi all, I am using Hive Server once submitted the query(It will take 60 mins) if Hive Server is down after 50 mins I cannot get the results of the submitted query. In this case I need to submit same ...
Chinna
Jun 21, 2011 at 1:15 pm
Jun 21, 2011 at 4:21 pm -
Hoping someone with more expertise could help on this: I have no idea what's causing this to happen, but here is the exception: java.lang.RuntimeException: ...
Matthew Rathbone
Jun 20, 2011 at 3:07 pm
Jun 20, 2011 at 5:53 pm -
Does the week start on Sunday or Monday for weekofyear() function? -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions.
Ayon Sinha
Jun 18, 2011 at 9:15 pm
Jun 18, 2011 at 9:51 pm -
Hi... I am trying to figure out how Hive parses an input file into a table, to use it as a model for implementing a similar parser. Having had a look at the source code of the ...
Public Network Services
Jun 15, 2011 at 11:48 pm
Jun 18, 2011 at 6:13 am -
I want to take a look at what's the implementations for queries like JOIN/MAPJOIN/SORT BY/ORDER BY... I have source code for hive, but I can not figure out where to start. Any ideas? Thanks, Huan
Huan Li
Jun 17, 2011 at 5:42 am
Jun 17, 2011 at 8:37 am -
Is anyone else having problems with Hue based on Hive 07.0 and Firefox 4.1? My Firefox browser crashes every time I run, but the dreaded I 8.0 runs fine. Any idea where I start? --- Mark E. Sunderlin ...
Sunderlin, Mark
Jun 15, 2011 at 2:34 pm
Jun 15, 2011 at 7:08 pm -
By default, all Hive clients log to the same file called hive.log via DRFA. What I'm seeing is that many log lines are "lost" after hive.log is rolled over to hive.log.YYYY-MM-DD. Is this an issue ...
Steven Wong
Jun 2, 2011 at 1:32 am
Jun 2, 2011 at 9:00 pm -
Hello, What's the plan to support fully aggregated lists reading a table in order? (see below) I have a fairly complex (45 line) SELECT script in Hive with Joins, Unions, etc. to which I have to add ...
Travis Powell
Jun 29, 2011 at 8:29 pm
Jun 29, 2011 at 8:29 pm -
How is memory consumption handled in Hive and Hadoop? If I perform a join with a very large result, how does Hive avoid filling up the nodes' memories? I know that Java's GC prevents programs from ...
Altanis
Jun 29, 2011 at 12:57 pm
Jun 29, 2011 at 12:57 pm -
https://issues.apache.org/jira/browse/HIVE-1734. Did this or an equivalent functionality to return the keys of a key/value pair get implemented into Hive 0/70? If not, does anyone have a hack or ...
Sunderlin, Mark
Jun 28, 2011 at 8:56 pm
Jun 28, 2011 at 8:56 pm -
Hi, I have seq files with key as line number and value is ctrl B delimited text. a sample value is: 45454^B567^Brtrt^B-7.8 56577^B345^Bdrtd^B-0.9 when I create a table like: create table temp_seq ...
Mapred Learn
Jun 27, 2011 at 10:44 pm
Jun 27, 2011 at 10:44 pm -
The location details are on the event page: http://hivecontribday2011.eventbrite.com There are still plenty of seats left for anyone interested. JVS
John Sichi
Jun 27, 2011 at 7:32 pm
Jun 27, 2011 at 7:32 pm -
Hi, looking for some advice from the experts, please. I am new to Hive. I have data files each consisting of scads of very long records, each record being an XML doc in it's own right. These XML docs ...
Liam Friel
Jun 25, 2011 at 12:51 am
Jun 25, 2011 at 12:51 am -
Hi, I have a sequence file where I have delimited data and some data is decimal fields. For eg: decimal(16,6). Sample value : 123.456735. How do I upload such a sequence file and what shud I give in ...
Mapred Learn
Jun 23, 2011 at 1:21 am
Jun 23, 2011 at 1:21 am -
The Apache Hive team is pleased to announce the release of Hive 0.7.1. Apache Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc querying, and analysis of ...
Carl Steinbach
Jun 22, 2011 at 2:01 am
Jun 22, 2011 at 2:01 am -
Hadoop fans, Last week we held another successful San Francisco Hadoop "unconference" meetup at RichRelevance's office. Discussion topics included: * Working with multiple Hadoop clusters * HBase * ...
Aaron Kimball
Jun 15, 2011 at 6:54 pm
Jun 15, 2011 at 6:54 pm -
Hi there, I'm new to Hive, any suggestion or comment on the following installation issue? Thanks a lot! I found the questions asked over google the web, but did not find solution. After installed ...
Zhiyong Xie
Jun 14, 2011 at 7:02 pm
Jun 14, 2011 at 7:02 pm -
Can anyone point me to an example ( including queries, code ) of using hive to sessionize data by time ( eg, a web app clickstream log, where sessions are split where time gaps occur ) ? Thanks, pk ...
Praveen
Jun 11, 2011 at 9:41 pm
Jun 11, 2011 at 9:41 pm -
Hey, signups are now open for this event: http://hivecontribday2011.eventbrite.com/ It's free, but please don't sign up unless you're sure you can make it, because seating is limited. Contributions ...
John Sichi
Jun 8, 2011 at 8:56 pm
Jun 8, 2011 at 8:56 pm -
I get the following ClosedByInterruptException often - but not always - when running a query with hive.exec.parallel=true. It seems to happen only when 2 MR jobs are being launched in parallel. I ...
Steven Wong
Jun 8, 2011 at 7:26 pm
Jun 8, 2011 at 7:26 pm -
I cannot find much written about how hive deal with unit of work control when data is loaded. If when a client crashes in the middle of a 'load data inpath' call, says if the file is not in hdfs, ...
W S Chung
Jun 8, 2011 at 3:33 pm
Jun 8, 2011 at 3:33 pm -
Hi Experts, I need one solution for hive in my project. Actually I have to create a pivot table type of concept in hive. I don't know how to do the same. But I have studied and implemented in hive ...
Reju R
Jun 8, 2011 at 10:17 am
Jun 8, 2011 at 10:17 am -
Hi! When I run the same query several times in Hive, the execution time decreases (1000s,800s, 400s, 300s). That it is due solely to the use of ram? Assuming that the execution time of a request ...
Guillaume WEILL
Jun 6, 2011 at 2:41 pm
Jun 6, 2011 at 2:41 pm -
Hello I'm trying to connect hue/beeswax to my cloudera hadoop cluster master node with Hive running. Hive and Hue both are using the mysql database repository on master node itself. I'm running into ...
Sanjeev sagar
Jun 3, 2011 at 11:50 pm
Jun 3, 2011 at 11:50 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 52 |
posts | 149 |
users | 60 |
website | hive.apache.org |
60 users for June 2011
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)