FAQ

Search Discussions

48 discussions - 143 posts

  • Hello all, This morning we upgraded our cluster to use Hive 0.6.0 from Hive 0.5.0. I ran the Derby DB migration script before upgrading. All of our queries are running fine, however our INSERT ...
    Ryan LeCompteRyan LeCompte
    Dec 7, 2010 at 5:13 pm
    Dec 8, 2010 at 2:55 pm
  • Hey guys, We would like to experiment with some of the features in the current trunk (0.7) release. Do you think at this point it's nearing "production-ready" ? Are there any metastore migration ...
    Ryan LeCompteRyan LeCompte
    Dec 8, 2010 at 2:56 pm
    Feb 8, 2011 at 12:30 am
  • test: [junit] Running org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore [junit] Tests run: 11, Failures: 0, Errors: 0, Time elapsed: 34.192 sec [junit] BR.recoverFromMismatchedToken [junit] ...
    Edward CaprioloEdward Capriolo
    Dec 3, 2010 at 6:50 pm
    Dec 6, 2010 at 1:43 am
  • Hi all, Once the JoinTrees are created by the the semantic analyzer for a query block , a function mergeJoinTree(qb) is called . Can anyone tell me what it does ? Thanks in anticipation, Bharath.V
    Bharath vissapragadaBharath vissapragada
    Dec 23, 2010 at 12:25 pm
    Dec 24, 2010 at 7:02 am
  • I ran into "Unable to determine Hadoop version information" Google found some post referring to some build/dist directory that I can only have if I checkout the source(I downloaded the binary ...
    Hiller, Dean (Contractor)Hiller, Dean (Contractor)
    Dec 29, 2010 at 1:45 pm
    Dec 29, 2010 at 4:43 pm
  • just running a simple select count(1) from a table (using movielens as an example) doesnt seem to work for me. anyone know why this doesnt work? im using hive trunk: hive select avg(rating) from ...
    Sean CurtisSean Curtis
    Dec 21, 2010 at 2:12 am
    Dec 21, 2010 at 4:16 am
  • just wondering if i have a pipe delimited file, how i can just import this data into hive: basically i am using the microlens database, which is pipe separated. for example: user id | age | gender | ...
    Sean CurtisSean Curtis
    Dec 15, 2010 at 4:23 am
    Dec 15, 2010 at 5:19 am
  • I have this query to calculate some averages: select hour, cdn, avg(bitrate) from fact_table group by hour, cdn 1 8 a 1 9 b 2 8 c 3 8 d 3 9 e But I want the output to be in the following format so ...
    Steven WongSteven Wong
    Dec 6, 2010 at 9:02 pm
    Dec 7, 2010 at 6:37 am
  • Hi, I am trying to test creation of an external table using partitions, my files on hdfs are: /user/training/partitions/dt=2/engine /user/training/partitions/dt=2/engine engine are sequence files ...
    David GinzburgDavid Ginzburg
    Dec 28, 2010 at 2:42 pm
    Dec 29, 2010 at 2:56 pm
  • Hi, Hive wiki says "Hive currently does input pruning only if the partition predicates are specified in the WHERE clause closest to the table_reference in the FROM clause..." what does this mean? I ...
    NarendraNarendra
    Dec 28, 2010 at 7:09 am
    Dec 28, 2010 at 10:24 am
  • Hello, there. I found that running hive with sql file caused error messages because of comments. For example, me and data analysts in my company think these sql file is make sense. ...
    Iryoung jeongIryoung jeong
    Dec 20, 2010 at 6:17 am
    Dec 21, 2010 at 4:21 am
  • VlisovskyVlisovsky
    Dec 10, 2010 at 6:47 am
    Dec 11, 2010 at 9:52 pm
  • Hello, Does anyone get a backtrace when running HiveClientTestC? On an EC2 instance with Hive (0.6.0), i checked out the trunk (RELEASE_NOTEST.txt says 0.6.0) of Hive and compiled the client. ant ...
    Saptarshi GuhaSaptarshi Guha
    Dec 1, 2010 at 9:15 pm
    Dec 2, 2010 at 6:31 pm
  • Hello A few questions. Once i get the result from e.g void fetchOne(std::string& _return); how does one parse the bytes in _return? Is this what getSchema is for? Do I call getSchema, figure out the ...
    Saptarshi GuhaSaptarshi Guha
    Dec 1, 2010 at 12:52 am
    Dec 1, 2010 at 5:17 pm
  • Hi All, How to run Hive Server in background ? Currently when i run hive --service hiveserver , it starts hive server on the terminal. Also, how to capture logs written on terminal of hive server ? ...
    Vaibhav negiVaibhav negi
    Dec 30, 2010 at 1:18 pm
    Dec 30, 2010 at 2:13 pm
  • Dear all, I am following all wiki tutorial for configurin Hive with Hbase Integrated. For this I use : Hadoop-0.20.2 Hive-0.6.0 ( By Default Metastore derby) Hbase-0.20.6 Java 1.6_20 I established ...
    Adarsh SharmaAdarsh Sharma
    Dec 29, 2010 at 1:17 pm
    Dec 29, 2010 at 7:30 pm
  • in hive 0.6, we can create view for tables, views are actually run as a subquery when querying data, is it optimized in hive that a view is executed only once in a single query? Thanks in advance! ...
    Neil XuNeil Xu
    Dec 28, 2010 at 8:18 am
    Dec 28, 2010 at 7:22 pm
  • I apologize in advance if this is a basic question... I haven't found a straight answer to the question, though, and am new to Hive so forgive the ignorance. I've done some searching around, and it ...
    Jonathan CoveneyJonathan Coveney
    Dec 27, 2010 at 2:56 pm
    Dec 27, 2010 at 8:44 pm
  • Hi all, I am googled a lot about the below error but can't able to find the root cause. I am selecting data from Hive table website_master but it results in below error : Hibernate: select ...
    Adarsh SharmaAdarsh Sharma
    Dec 16, 2010 at 10:09 am
    Dec 16, 2010 at 11:33 pm
  • Can someone explain what actually happens when you create a table and import data into using "LOAD DATA INPATH..." I noticed that when I load the data from files already existing in HDFS that it ...
    MarkMark
    Dec 15, 2010 at 11:34 pm
    Dec 16, 2010 at 12:49 am
  • I have a lot of tables floating in /user/hive/warehouse. A lot of them get generated in the process of doing some one-off analysis and can safely be dropped; often, however, these tables aren't ...
    Leo AlekseyevLeo Alekseyev
    Dec 15, 2010 at 11:03 pm
    Dec 15, 2010 at 11:29 pm
  • I am trying to write a very simple aggregation function which seems like an overkill for using GenericUDAF as described on the wiki. However, I can't get the code to run. It always throws an ...
    Leo AlekseyevLeo Alekseyev
    Dec 8, 2010 at 5:28 am
    Dec 8, 2010 at 10:46 am
  • 1) When I cancel hive job with Ctrl C, I noticed that java/hive processes still run on some of my nodes. I shutdown hadfoop, and restarted it, but noticed that 2 or 3 java/hadoop processes were still ...
    Tali KTali K
    Dec 7, 2010 at 8:21 pm
    Dec 7, 2010 at 9:43 pm
  • Hi, I have a question regarding securing the hive configuration files. The hive-site.xml has credentials to connect to the mysql server. I will have many users who would like to use Hive from the ...
    Rakesh DavanumRakesh Davanum
    Dec 7, 2010 at 7:20 am
    Dec 7, 2010 at 4:00 pm
  • Hi All, I am getting Could not obtain block: blk_2706642997966533027_4482 file=/user/outputwc425729652_0/part-r-00000 I checked the file is actually there. What I should do? Please help. Could not ...
    Tali KTali K
    Dec 24, 2010 at 12:05 pm
    Dec 28, 2010 at 4:09 pm
  • Often I forget to name a column that results from running an aggregation. Then, I'm stuck: describe table lists those columns by their default names, i.e. something like _c1, but I can't seem to ...
    Leo AlekseyevLeo Alekseyev
    Dec 20, 2010 at 11:23 pm
    Dec 20, 2010 at 11:36 pm
  • I need to get rows from table A where the key is not present in table B. Something like SELECT a.val1, a.val2, a.key, b.val FROM a LEFT OUTER JOIN b ON (a.key=b.key) WHERE b.val IS NULL seems to ...
    Leo AlekseyevLeo Alekseyev
    Dec 16, 2010 at 2:10 am
    Dec 17, 2010 at 9:49 pm
  • Can someone explain what partitioning is and why it would be used.. example? Thanks
    MarkMark
    Dec 15, 2010 at 9:52 pm
    Dec 15, 2010 at 10:02 pm
  • Dear all, I am using Hadoop-0.20.2 and Hadoopdb Hive on a 5 node cluster. I am connecting Hive through Eclipse but I got the error below : Hive history ...
    Adarsh SharmaAdarsh Sharma
    Dec 14, 2010 at 10:49 am
    Dec 14, 2010 at 11:43 am
  • Hi all, I hunted around a bit, but didn't see any mention of a projected release date for 0.7. Is there one? Thanks, Kirk
    Kirk TrueKirk True
    Dec 13, 2010 at 4:51 pm
    Dec 13, 2010 at 6:01 pm
  • Hi, I am new to Hive, I am trying to use struct data type. I am able to create table successfully. I would like to know how to give the data format for the strct data type to avail this facility. My ...
    Saravanan RajendranSaravanan Rajendran
    Dec 13, 2010 at 7:52 am
    Dec 13, 2010 at 9:32 am
  • Hi, I am a newbie to hive. When I am trying to import data to HBase via a table managed by Hive. I am getting following errors: mismatched input 'Timestamp' expecting Identifier in column ...
    Vivek MishraVivek Mishra
    Dec 10, 2010 at 9:58 am
    Dec 10, 2010 at 11:38 am
  • When one loads data to hive , if the file is in hdfs, it is moved into the Hive-controlled file system namespace. and deleted from hdfs. Is it possible to change it so , file wouldn't be moved, but ...
    Tali KTali K
    Dec 9, 2010 at 7:54 pm
    Dec 9, 2010 at 9:58 pm
  • Hi, Currently I am facing random behavior while trying to create a java client for Hive hbase integration. Case: I am trying to create a hive table for existing HBase table. So i have started ...
    Vivek MishraVivek Mishra
    Dec 3, 2010 at 8:19 am
    Dec 3, 2010 at 9:31 am
  • I finally have hive working. I can create tables and it makes complete since that hive stores the metadata since hbase is completly open, but how do I mount an existing table which already has 13gig ...
    Hiller, Dean (Contractor)Hiller, Dean (Contractor)
    Dec 29, 2010 at 8:34 pm
    Dec 29, 2010 at 8:34 pm
  • Hi Hive users and developers, Any reason why change proposed in https://issues.apache.org/jira/browse/HADOOP-4097 is absent in current version? When speculative execution is on I see ...
    Shrijeet PaliwalShrijeet Paliwal
    Dec 29, 2010 at 12:33 am
    Dec 29, 2010 at 12:33 am
  • Hi, In my DFS home page, display the message below WARNING : There are about 7179 missing blocks. Please check the log or run fsck. who can tell me what this message and how to fix than? bcoz so far ...
    SingoWongSingoWong
    Dec 26, 2010 at 10:48 am
    Dec 26, 2010 at 10:48 am
  • Hi all, I'm excited to announce that Amazon Elastic MapReduce is now hosting the Google Books n-gram dataset in Amazon S3. The data has been converted to SequenceFile format to make it easy to ...
    Andrew HitchcockAndrew Hitchcock
    Dec 24, 2010 at 12:49 am
    Dec 24, 2010 at 12:49 am
  • Hi all, I am going through the src code of the hive trunk and Iam not clear about the usage of "org.apache.hadoop.hive.ql.parse.RowResolver" . Can anyone help me with this ? Thanks Bharath.V 4th Year ...
    Bharath vissapragadaBharath vissapragada
    Dec 21, 2010 at 5:31 pm
    Dec 21, 2010 at 5:31 pm
  • Hi, I made HIVE-1850 a week ago, but I just realized that of course, this is a bit more generic. Any alter table operation may put hive in a state which you cannot get out of today. For instance, I ...
    Terje MarthinussenTerje Marthinussen
    Dec 21, 2010 at 1:07 pm
    Dec 21, 2010 at 1:07 pm
  • In jira we have ~ 600 scheduled issues. These issues range from unconfirmed bugs, general wish list items, very complex additions such as new syntax or new expanding the scope of hive. Almost ...
    Edward CaprioloEdward Capriolo
    Dec 11, 2010 at 4:53 pm
    Dec 11, 2010 at 4:53 pm
  • Is it safe to share a 0.7 metastore between 0.7 clients/servers and 0.5 clients/servers? Thanks.
    Steven WongSteven Wong
    Dec 11, 2010 at 2:59 am
    Dec 11, 2010 at 2:59 am
  • Hello, I just came across the GenericUDFDBOutput and was able to successfully write data to a mysql db. I tried modifying the connection string to a sql server using jtds library and for some reason ...
    Viral BajariaViral Bajaria
    Dec 10, 2010 at 2:12 am
    Dec 10, 2010 at 2:12 am
  • Hello, I have Eucalyptus 1.6.2 installed on ubuntu 10.04 using source installation with kvm. Currently I have ten nodes in my cloud in a single cluster architecture. Also I have tested Hadoop on VM's ...
    Adarsh SharmaAdarsh Sharma
    Dec 9, 2010 at 10:26 am
    Dec 9, 2010 at 10:26 am
  • Hello, could anyone enlighten me as how the logging in Hive is working? I see that a hive-exec-log4j.properties has been added but the JavaDoc says it is only used for local mode. I found other ...
    Lars FranckeLars Francke
    Dec 4, 2010 at 11:30 pm
    Dec 4, 2010 at 11:30 pm
  • Hello Fellow Mappers and Reducers, We are meeting at 7:15 pm on December 2nd at the University Heights Community Center 5031 University Way NE Seattle WA 98105 Room #110 The meetings are informal and ...
    Sean jensen-greySean jensen-grey
    Dec 2, 2010 at 4:58 am
    Dec 2, 2010 at 4:58 am
  • Greetings, The Seattle Scalability Meetup isn't slacking for the holidays. We've got an awesome lineup for Wed, December 8 at 7pm: http://www.meetup.com/Seattle-Hadoop-HBase-NoSQL-Meetup/ -Jake ...
    Bradford StephensBradford Stephens
    Dec 1, 2010 at 5:30 am
    Dec 1, 2010 at 5:30 am
  • Hi All We have improved the join performance in Hive and Hive can automatically convert join into map join based on input data size. So users don’t need to give the hint for the query. Here is the ...
    Liyin TangLiyin Tang
    Dec 1, 2010 at 3:44 am
    Dec 1, 2010 at 3:44 am
Group Navigation
period‹ prev | Dec 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions48
posts143
users46
websitehive.apache.org

46 users for December 2010

Edward Capriolo: 18 posts Ryan LeCompte: 13 posts Tali K: 8 posts John Sichi: 7 posts Adarsh Sharma: 6 posts Leo Alekseyev: 6 posts Saptarshi Guha: 6 posts Steven Wong: 5 posts Carl Steinbach: 4 posts Hiller, Dean (Contractor): 4 posts Sean Curtis: 4 posts Viral Bajaria: 4 posts Vivek Mishra: 4 posts Bharath vissapragada: 3 posts Kirk True: 3 posts Namit Jain: 3 posts Narendra: 3 posts Ning Zhang: 3 posts Pavan Yara: 3 posts Ashutosh Chauhan: 2 posts
show more
Archives