Grokbase Groups Hive user July 2010
FAQ

Search Discussions

53 discussions - 161 posts

  • Hi, I suspect this is true but wanted to confirm: If I start a thrift metastore service as user "joe" then all internal tables created will have directories under the warehouse directory owned by ...
    Pradeep KamathPradeep Kamath
    Jul 13, 2010 at 9:06 pm
    Jul 21, 2010 at 7:33 pm
  • Hi, Is there some way to load csv file into hive? Vaibhav Negi
    Vaibhav negiVaibhav negi
    Jul 26, 2010 at 7:33 am
    Jul 27, 2010 at 8:49 am
  • Hi, I have a problem with calling a simple UDF function in Hive query. I compiled the function and created a jar file on my local pc. Then the jar file is sent to a remote Hive cluster and deployed. ...
    Ping ZhuPing Zhu
    Jul 21, 2010 at 10:54 pm
    Jul 22, 2010 at 7:15 pm
  • Hello everybody, I just start working on HIVE so maybe my question will be stupid but for the moment I am completely stuck so ... I try to create a Java app, and try to launch some query on my Hive ...
    Francois LAGIERFrancois LAGIER
    Jul 28, 2010 at 8:00 pm
    Jul 29, 2010 at 11:55 pm
  • Hi, I have data with complex types (map, struct, array of maps) stored as a text file. I am able to successfully create an external table based on this data and further build a lateral view on it: ...
    Pradeep KamathPradeep Kamath
    Jul 7, 2010 at 11:49 pm
    Jul 9, 2010 at 3:41 am
  • Hi, I wanted to implement a UDF which takes the entire row of input as argument. Unfortunately when I call it using select myudf(*) from my table, I get : FAILED: Parse Error: line 1:16 mismatched ...
    Pradeep KamathPradeep Kamath
    Jul 7, 2010 at 11:39 pm
    Jul 8, 2010 at 7:51 pm
  • +hive-user For the last contributor meeting, we had a teleconference setup, but it burned a bit of time on technical difficulties and ended up not even being used. So going forward we will skip this ...
    John SichiJohn Sichi
    Jul 21, 2010 at 7:27 pm
    Jul 27, 2010 at 8:31 pm
  • Is there away to do a hbase key lookup using the Hive-Hbase integration without doing a full scan? Since I'm specifying the key='foo' in the where condition, shouldn't it be a fast lookup? thanks, ...
    Ray DuongRay Duong
    Jul 1, 2010 at 5:36 pm
    Jul 22, 2010 at 2:21 am
  • Hi there I would like to know if there is anyone who has done some kind of modelling on Hive, and is willing to share some experiences please. Today is my first day with Hive, and I have several ...
    Renato Marroquín MogrovejoRenato Marroquín Mogrovejo
    Jul 15, 2010 at 9:53 pm
    Jul 21, 2010 at 8:16 pm
  • Hi, Are there are any built-in functions in Hive to check whether a string is UTF8-encoding? I did some research about this issue but did not find useful resources. Thanks for your suggestions and ...
    Ping ZhuPing Zhu
    Jul 20, 2010 at 7:04 pm
    Jul 21, 2010 at 4:03 pm
  • Hi Everyone, my hive interactive shell query returns with empty results when there should be some results. I noticed this from time to time. Has this happened to anybody? and if so what can I do to ...
    Matias SilvaMatias Silva
    Jul 19, 2010 at 11:36 pm
    Jul 20, 2010 at 11:47 pm
  • Hi All, I've been working with UDFs in hive a lot lately, usually to implement some manner of small lookup which isn't worth the overhead of a join, or which for some other reason is preferable as a ...
    Mark TozziMark Tozzi
    Jul 19, 2010 at 8:28 pm
    Jul 19, 2010 at 10:10 pm
  • Sorry I did not get to listen to the event. So one topic of interest for me is: "Several people voiced concerns that developers/users are less likely to update the documentation if doing so requires ...
    Edward CaprioloEdward Capriolo
    Jul 15, 2010 at 2:32 pm
    Jul 15, 2010 at 9:30 pm
  • Hi, I am new to Hive and Hadoop in general. I have a table in Oracle that has millions of rows and I'd like to export it into HDFS so that I can run some Hive queries. My first question is, is it ...
    Todd LeeTodd Lee
    Jul 8, 2010 at 12:51 am
    Jul 8, 2010 at 1:30 am
  • Hi, I have a question about the JOIN operation in Hive. For example, I have a query, like select tmp7.* from tmp7 join tmp2 on (tmp7.c2 = tmp2.c1); Clearly, there is a JOIN involved in the statement. ...
    Yan qiYan qi
    Jul 1, 2010 at 4:51 pm
    Jul 1, 2010 at 8:23 pm
  • We are importing hadoop logs inside hive, but are running in some issues. Sample log lines: 2010-02-25 14:27:18,000 INFO org.apache.hadoop.mapred.TaskTracker: SHUTDOWN_MSG: Query: SELECT * FROM ...
    Anurag PhadkeAnurag Phadke
    Jul 31, 2010 at 1:58 am
    Jul 31, 2010 at 6:51 am
  • We are working with a trunk of hive hive-0.6.0-957988. Dynamic partitions are working for us in testing, we tested with about 100 dynamic partitions. For our production run we have about 1000 ...
    Edward CaprioloEdward Capriolo
    Jul 26, 2010 at 2:49 pm
    Jul 26, 2010 at 7:40 pm
  • Hi, I am trying to understand the differences between managed Vs external tables. From http://wiki.apache.org/hadoop/Hive/StorageHandlers#Terminology: "A managed table is one for which the definition ...
    Pradeep KamathPradeep Kamath
    Jul 21, 2010 at 5:12 pm
    Jul 21, 2010 at 7:18 pm
  • Hello, I was wondering if anyone can help me out with Hive InputFormat / Deserializer. I am trying to implement a custom file format which is similar to Avro: Each file will have the "schema" in the ...
    Alex RovnerAlex Rovner
    Jul 18, 2010 at 4:34 am
    Jul 19, 2010 at 5:42 pm
  • Hi everyone, I'm trying to setup HBase/Hive integration using HBase 0.20.3 and the latest HIVE source from svn. I have one machine acting as HBase Master+ZooKeeper with HIVE on it and two ...
    Gal BarneaGal Barnea
    Jul 12, 2010 at 3:00 pm
    Jul 15, 2010 at 12:58 pm
  • Hi all, I was wondering if anyone is using Hive with protocol buffers. The Hadoop wiki links to http://www.slideshare.net/ragho/hive-user-meeting-august-2009-facebook for SerDe examples; there it ...
    Leo AlekseyevLeo Alekseyev
    Jul 13, 2010 at 12:10 am
    Jul 13, 2010 at 3:47 am
  • I read on the VLBD hive paper "Hive - A Warehousing Solution Over a Map-Reduce Framework" that Partitions could have different schemas : (section 3.1 MetaStore) " Partition - Each partition can have ...
    YangYang
    Jul 1, 2010 at 11:43 pm
    Jul 2, 2010 at 4:30 am
  • Hi, I am using hadoop version 0.20 . I created a table in hive ,then i opened another terminal and entered "show tables" command, but it showed no tables. then i created another table with same table ...
    Vaibhav negiVaibhav negi
    Jul 28, 2010 at 11:36 am
    Jul 28, 2010 at 11:46 am
  • Hi, Please suggest Hadoop-Hive books/ebooks/sites/docs/pdfs for datawarehousing using Hive. Best Regards, Vaibhav Negi
    Vaibhav negiVaibhav negi
    Jul 26, 2010 at 10:54 am
    Jul 26, 2010 at 12:19 pm
  • hive describe spect; describe spect; OK url string key string crawler struct<domain:string,component:string,http_headers:string,machine:string,proxy:string,crawl_time:bigint dust ...
    Sagar NaikSagar Naik
    Jul 19, 2010 at 3:13 am
    Jul 19, 2010 at 3:17 am
  • I got an Avro map/reduce job that generates an output file on HDFS. The reducer of the job is an subclass of AvroReducer<GenericRecord, GenericRecord . I would like to query data on the output file ...
    Ey-chih chowEy-chih chow
    Jul 18, 2010 at 2:14 am
    Jul 18, 2010 at 2:20 am
  • Hi Folks This issue occurs on Hive 0.4 and 0.5. I wanted to wait on opening a JIRA ticket until I ran it by the community first. I'm testing Hive 0.5 running on Apache Hadoop 0.20.2 which is using ...
    Stephen WattStephen Watt
    Jul 16, 2010 at 4:18 pm
    Jul 16, 2010 at 11:57 pm
  • Hi all, I have recently connected Hive with MySQL (as a metastore) from my admin account. http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin If all users use my hive-site.xml, all of them ...
    Viraj BhatViraj Bhat
    Jul 12, 2010 at 4:47 pm
    Jul 12, 2010 at 5:03 pm
  • Hi. Something I noticed is that when I run an insert overwrite table... for sequence files the key is empty. This works as expected for further hive queries because as I understand, hive only reads ...
    Matt PestrittoMatt Pestritto
    Jul 9, 2010 at 4:38 pm
    Jul 9, 2010 at 4:44 pm
  • *hive SELECT L.key, sum(C.quantity) FROM TA L JOIN TB C ON L.key=C.key GROUP BY L.key ORDER BY L.key;* ** *FAILED: Error in semantic analysis: line 1:89 Invalid Table Alias or Column Reference L* In ...
    何翔何翔
    Jul 2, 2010 at 11:09 am
    Jul 2, 2010 at 9:47 pm
  • Hi all, I have a large number of small files, in some partitions as Hive does not support merging small files when using dynamic partitioning. To process these small files, I try to use the set ...
    Viraj BhatViraj Bhat
    Jul 2, 2010 at 8:01 am
    Jul 2, 2010 at 6:52 pm
  • Hi, We are currently using Derby in server mode and would like to migrate to MySql, but we would prefer to not have to re-create all of our tables in MySql. I have tried the following with no success ...
    Bill BejeckBill Bejeck
    Jul 30, 2010 at 2:07 pm
    Jul 30, 2010 at 2:07 pm
  • Dear Hive Experts, I am relatively new to Hadoop and Hive. I have written some hive scripts for gathering a subset of data. I have a new requirement and I need your advice on how to proceed and ...
    Raman YakkalaRaman Yakkala
    Jul 29, 2010 at 11:20 pm
    Jul 29, 2010 at 11:20 pm
  • Hi All, We are planning to hold the next Hadoop India User Group meet up on 31st July 2010 in Noida, India. The registration and event details are available at - ...
    Sanjay SharmaSanjay Sharma
    Jul 29, 2010 at 5:52 pm
    Jul 29, 2010 at 5:52 pm
  • I can succeed doing DDL operations like "create table" and other command query related to metastore_db like "decribe","show tables" as the metastore_db is located at local host which I think is the ...
    ShanganShangan
    Jul 29, 2010 at 9:28 am
    Jul 29, 2010 at 9:28 am
  • Hi all, We are using mysql as hive metastore db. The hive.log prints lots of exceptions *Table 'default.DELETEMEXXXXXXXXXXX' doesn't exist* every day. We used to ignore that exception, untill ...
    Ted XuTed Xu
    Jul 26, 2010 at 3:53 am
    Jul 26, 2010 at 3:53 am
  • So I'm new to hadoop and hive, but I have a 4 node cluster up and running, the sample apps work great on it. But when I run my query, it doesn't seem to actually "distribute" the compute to all the ...
    Bryan DennstedtBryan Dennstedt
    Jul 22, 2010 at 7:02 pm
    Jul 22, 2010 at 7:02 pm
  • I have some Hadoop SequenceFiles that contain key/value pairs of 2 Java classes. The 2 classes each have many Java primitive types. Class A - this is the key Class B - this is the value I need to ...
    Rodriguez, JohnRodriguez, John
    Jul 21, 2010 at 7:41 pm
    Jul 21, 2010 at 7:41 pm
  • Hi all, Disclosure: I have been an active member of the Hadoop / HBase / Hive mailing lists for some time. I am not a recruiter, but looking to increase a development team that I lead. I sincerely ...
    Tim RobertsonTim Robertson
    Jul 20, 2010 at 2:53 pm
    Jul 20, 2010 at 2:53 pm
  • Is there a reason for this? After dropping the partition, the directory for the partition is left behind in HDFS but contains no data (empty directory). Is it safe to manually delete the directory ...
    Ryan LeCompteRyan LeCompte
    Jul 16, 2010 at 1:39 pm
    Jul 16, 2010 at 1:39 pm
  • greetings - I'm looking to migrate gobs of ProtocolBuffer logs to Hive, and tweek the Java servlet that writes these logs to just store directly to SerDe format....It'll be interesting to see how ...
    Chris NicholasChris Nicholas
    Jul 15, 2010 at 6:03 pm
    Jul 15, 2010 at 6:03 pm
  • Hi All, We are planning to hold the next Hadoop India User Group meet up on 31st July 2010 in Noida, India. The registration and event details are available at - ...
    Sanjay SharmaSanjay Sharma
    Jul 15, 2010 at 3:22 pm
    Jul 15, 2010 at 3:22 pm
  • hi I have few questions on hive and its use case. 1. hive-on-hadoop-20 accessing/processing data stored on hadoop-18-dfs The actual files are on hadoop-18 dfs and then I will create external table on ...
    Sagar NaikSagar Naik
    Jul 14, 2010 at 11:46 pm
    Jul 14, 2010 at 11:46 pm
  • I got into puppet recently and I have started using it to make a semi-automated trunk- production deployment system. http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/hive_via_puppet Regards, ...
    Edward CaprioloEdward Capriolo
    Jul 13, 2010 at 8:45 pm
    Jul 13, 2010 at 8:45 pm
  • I'm excited to announce the first Seattle Hadoop Day, on August 14th! Get your tickets at http://hadoopday2010.eventbrite.com. Hadoop Day is a day-long community-organized event where we gather to ...
    Bradford StephensBradford Stephens
    Jul 12, 2010 at 9:57 pm
    Jul 12, 2010 at 9:57 pm
  • This is a question I should go and test out myself but was wondering if anyone has a quick answer. We have map/reduce jobs that produce lots of smaller files to a folder. We also have a hive external ...
    Edward CaprioloEdward Capriolo
    Jul 9, 2010 at 9:43 pm
    Jul 9, 2010 at 9:43 pm
  • Hi All I am facing a hard problem. I am running a map reduce job using streaming but it fails and it gives the following error. Caught: java.lang.OutOfMemoryError: Java heap space at ...
    Shuja RehmanShuja Rehman
    Jul 9, 2010 at 5:16 pm
    Jul 9, 2010 at 5:16 pm
  • Today is your last chance to submit a CFP abstract for the 2010 Surge Scalability Conference. The event is taking place on Sept 30 and Oct 1, 2010 in Baltimore, MD. Surge focuses on case studies that ...
    Jason DixonJason Dixon
    Jul 9, 2010 at 3:07 pm
    Jul 9, 2010 at 3:07 pm
  • Hi, I am new to Hive and Hadoop in general. I have a table in Oracle that has millions of rows and I'd like to export it into HDFS so that I can run some Hive queries. My first question is, is it ...
    Todd LeeTodd Lee
    Jul 7, 2010 at 9:55 pm
    Jul 7, 2010 at 9:55 pm
  • Dear all, I recently launched a Q+A site about scalability, and someone posted a question about Hive: http://scale.metaoptimize.com/questions/26/use-cases-for-hive As part of the launch of my site, ...
    Joseph TurianJoseph Turian
    Jul 7, 2010 at 7:42 pm
    Jul 7, 2010 at 7:42 pm
Group Navigation
period‹ prev | Jul 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions53
posts161
users57
websitehive.apache.org

57 users for July 2010

Pradeep Kamath: 16 posts Edward Capriolo: 15 posts John Sichi: 14 posts Ping Zhu: 11 posts Paul Yang: 9 posts Vaibhav negi: 7 posts Todd Lee: 6 posts Viraj Bhat: 6 posts Ashish Thusoo: 4 posts Yang: 4 posts Zheng Shao: 4 posts Alex Rovner: 3 posts Francois LAGIER: 3 posts Renato Marroquín Mogrovejo: 3 posts Yongqiang he: 3 posts Amogh Vasekar: 2 posts Anurag Phadke: 2 posts Chris Nicholas: 2 posts Gal Barnea: 2 posts Jason Dixon: 2 posts
show more
Archives