Grokbase › Groups › Hive › user › June 2011
FAQ

Hive > user > June 2011

Search Discussions

52 discussions - 149 posts

  • 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 ChungW 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 BenderJon 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 LeeKennon 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 GreenClint 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 YamadaSatoshi 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 SinhaAyon 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 KumarPraveen 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 sSangeetha 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 SichiJohn 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 GautamRaghav 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 KatkarVikramsinh 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 KsBejoy 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 LiShouguo 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 naikSagar naik
    Jun 11, 2011 at 1:56 am
    Jun 12, 2011 at 10:49 pm
  • 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 WEILLGuillaume 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 SichiJohn 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 RPrashanth 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 YanJunxian 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 ScalisiSal Scalisi
    Jun 28, 2011 at 11:31 pm
    Jun 29, 2011 at 3:35 pm
  • Sent from my iPhone
    Mapred LearnMapred 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 SinhaAyon 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 TatarinovIgor 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 duJinhang 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 duJinhang 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 TatarinovIgor 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 SinhaAyon 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 ...
    ChinnaChinna
    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 RathboneMatthew 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 SinhaAyon 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 ServicesPublic 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 LiHuan 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, MarkSunderlin, 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 WongSteven 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 PowellTravis 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 ...
    AltanisAltanis
    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, MarkSunderlin, 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 LearnMapred 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 SichiJohn 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 FrielLiam 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 LearnMapred 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 SteinbachCarl 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 KimballAaron 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 XieZhiyong 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 ...
    PraveenPraveen
    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 SichiJohn 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 WongSteven 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 ChungW 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 RReju 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 WEILLGuillaume 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 sagarSanjeev sagar
    Jun 3, 2011 at 11:50 pm
    Jun 3, 2011 at 11:50 pm
Jun 2011
12
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions52
posts149
users60
websitehive.apache.org

60 users for June 2011

Steven Wong: 10 posts Ayon Sinha: 8 posts John Sichi: 8 posts Shouguo Li: 8 posts Igor Tatarinov: 7 posts Mapred Learn: 6 posts Jinhang du: 5 posts W S Chung: 5 posts Martin Konicek: 4 posts Sun, Michael: 4 posts Bejoy Ks: 3 posts Clint Green: 3 posts Edward Capriolo: 3 posts Guillaume WEILL: 3 posts Junxian Yan: 3 posts Praveen Kumar: 3 posts Sanjeev sagar: 3 posts Time Less: 3 posts Tim Spence: 3 posts Christopher, Pat: 2 posts
show more
Archives