FAQ

Search Discussions

46 discussions - 215 posts

  • Hi, I am new to hive so pardon me if this is something very obvious which I might have missed in the documentation. I have an application where I am joining a small inner table with a really large ...
    Sudipto DasSudipto Das
    Sep 9, 2009 at 9:02 pm
    Sep 11, 2009 at 11:43 pm
  • TIA if anyone can point me in the right direction on this. I'm running a simple Hive query (a count on an external table comprising 436 files, each of ~2GB). The cluster's mapred-site.xml specifies ...
    Brad HeintzBrad Heintz
    Sep 11, 2009 at 9:07 pm
    Sep 17, 2009 at 2:37 pm
  • We are planning to start enabling ad-hoc querying on our hive warehouse and we tested some of the concurrent queries and found the following issue: Query 1 ­ doing Œinsert overwrite table yyy .... ...
    Eva TseEva Tse
    Sep 9, 2009 at 5:18 am
    Sep 12, 2009 at 1:21 am
  • Dear Hive list, I am processing a large volume of files (many files, roughly 500M compressed ) with Hive that reside in an S3 bucket. Although the files share the same schema, they have individual ...
    Avram AelonyAvram Aelony
    Sep 16, 2009 at 5:49 pm
    Sep 16, 2009 at 7:37 pm
  • I¹m curently working on an application that connects to hive via the thrift ruby libraries. Does hive support creation of sessions using those libraries. If so, how? Royce
    Royce RollinsRoyce Rollins
    Sep 8, 2009 at 8:06 pm
    Sep 8, 2009 at 11:37 pm
  • Hi guys, I've been working on integrating hive with a legacy file format we use here. I wrote the appropriate InputFormat and SerDe and everything works, but it's painfully slow. The reason is that ...
    Roberto CongiuRoberto Congiu
    Sep 29, 2009 at 1:58 am
    Feb 2, 2010 at 5:21 pm
  • Is there a way in hive to enforce use of partition column before accepting the query for execution? Often user make mistake and don't specify them and then end-up waiting a lot more than expected.... ...
    Abhijit PolAbhijit Pol
    Sep 8, 2009 at 5:07 pm
    Sep 11, 2009 at 4:55 pm
  • I'm having trouble getting the hive jdbc driver to work on Windows. I'm following the Squirrel SQL Client setup from the Hive/HiveJDBCInterface wiki page. Everything works great when Squirrel SQL ...
    VijayVijay
    Sep 15, 2009 at 9:14 pm
    Sep 17, 2009 at 5:48 am
  • Hi all, we've tried newest one from trunk and r760184, both of them can't produce the same code with hive trunk. which thrift reversion do you use ? Thanks, Min -- My research interests are ...
    Min ZhouMin Zhou
    Sep 11, 2009 at 8:21 am
    Sep 14, 2009 at 5:06 am
  • Hey all, I am going to be at hadoop world nyc. I know several other hivers are going to be there speaking as well.I am pretty excited as I am an east coast guy and many of you are on the west ...
    Edward CaprioloEdward Capriolo
    Sep 21, 2009 at 11:04 pm
    Sep 21, 2009 at 11:35 pm
  • I have a file in HDFS which has the following format: c1<space c2<space c3<space c4<tab c5<space c6<space c7 where cX represents column X. Can someone please show me how I can create a table in Hive ...
    Mayuran YogarajahMayuran Yogarajah
    Sep 10, 2009 at 4:15 am
    Sep 11, 2009 at 4:10 am
  • Hi, I tried to begin a discussion along these lines earlier but that kind of went into a digression. My plan is to build a custom front-end for hive. Hive cli and hwi are great for the needs of ...
    VijayVijay
    Sep 15, 2009 at 4:58 am
    Sep 17, 2009 at 3:45 am
  • We have our files in HDFS laid out by day like this: 2009-09-01/files 2009-09-02/files 2009-09-03/files Loading this data into Hive would mean creating a new table per day! I'm thinking this might be ...
    Mayuran YogarajahMayuran Yogarajah
    Sep 11, 2009 at 7:20 pm
    Sep 11, 2009 at 8:22 pm
  • Does current Hive trunk support hadoop-0.20.0?
    Schubert ZhangSchubert Zhang
    Sep 4, 2009 at 9:18 am
    Sep 5, 2009 at 4:11 pm
  • All, I am looking to integrate HWI with https://issues.apache.org/jira/browse/HIVE-795 Should all Processors return a DriverResponse? the web interface allows a list of commands as the CLI would ...
    Edward CaprioloEdward Capriolo
    Sep 30, 2009 at 2:43 am
    Sep 30, 2009 at 9:02 pm
  • Hi, I am trying to issue hive queries using hive server. I am using hive 0.4, hadoop 0.18.3, and JDBC client as is from Hive Client Wiki page. The hive server is running at default port 10000. For ...
    Abhijit PolAbhijit Pol
    Sep 29, 2009 at 2:10 am
    Sep 30, 2009 at 5:50 am
  • Hi, This query is with reference to the Indexing patch mentioned in the following link. https://issues.apache.org/jira/browse/HIVE-678 I applied the patch (hive-678-2009-07-25) on the Hive revision ...
    Rutuja RaghojiRutuja Raghoji
    Sep 21, 2009 at 8:57 am
    Sep 21, 2009 at 10:51 am
  • hi,i am a newer to use hive ,and i found that hive pages dont contain hadoop0.20.0 ,but only from svn . so i follow introduction do this $ svn co http://svn.apache.org/repos/asf/hadoop/hive/trunk ...
    梁景明梁景明
    Sep 20, 2009 at 9:40 am
    Sep 20, 2009 at 10:51 am
  • Hi all, Currently, debugging a streaming written in other languages like python is very difficult for us. We ofen come up against such problems, we passed running python scripts in local mode, but ...
    Min ZhouMin Zhou
    Sep 7, 2009 at 3:54 am
    Sep 17, 2009 at 6:07 pm
  • I have a table with: ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' When I do a select on the table with a WHERE clause it runs a mapred job which fails with the following: ...
    Mayuran YogarajahMayuran Yogarajah
    Sep 11, 2009 at 4:10 am
    Sep 11, 2009 at 5:20 am
  • For one of the hive table I switched from TextFile to SequenceFile format. This is how I created the new table: CREATE EXTERNAL TABLE IMPRESSIONS ( A STRING, B STRING) PARTITIONED BY(DATA_DATE STRING ...
    Abhijit PolAbhijit Pol
    Sep 18, 2009 at 9:55 pm
    Oct 5, 2009 at 6:45 pm
  • Hi guys, First of all: I'm new around here, so hello! Good work on Hive - it's a great tool. Now, to the question: I am performing a join between 6 tables and keep experiencing OutOfMemoryErrors on ...
    Charles ACharles A
    Sep 29, 2009 at 2:38 pm
    Sep 29, 2009 at 4:42 pm
  • I am dumping files into a hive partion on five minute intervals. I am using LOAD DATA into a partition. weblogs web1.00 web1.05 web1.10 ... web2.00 web2.05 web1.10 .... Things that would be useful.. ...
    Edward CaprioloEdward Capriolo
    Sep 16, 2009 at 6:16 pm
    Sep 17, 2009 at 2:41 pm
  • does hive support queries over multiple tables stored in different formats? for example tableA is stroed as TEXTFILE and table B is stored as SEQUENCEFILE and query has tableA join tableB.
    Abhijit PolAbhijit Pol
    Sep 16, 2009 at 6:04 pm
    Sep 16, 2009 at 6:13 pm
  • I¹m trying to limit the deletion or modification of hive tables by username. I noticed the table TBLS has the owner field and gets set to the username who created it. BL_ID | CREATE_TIME | DB_ID | ...
    Royce RollinsRoyce Rollins
    Sep 16, 2009 at 12:14 am
    Sep 16, 2009 at 1:26 am
  • Hi, I have a scenario where in a query, I need to split up a single row and output 3 different rows. Is this supported by Hive, and if yes, can someone point me to the syntax? Thanks Sudipto PhD ...
    Sudipto DasSudipto Das
    Sep 11, 2009 at 6:05 pm
    Sep 11, 2009 at 6:41 pm
  • Hey all, I'm trying to write a UDAF as follows, borrowing heavily from the UDAF example on slide 84 from this deck: http://www.slideshare.net/ragho/hive-user-meeting-august-2009-facebook <snip public ...
    Jason MichaelJason Michael
    Sep 10, 2009 at 12:44 am
    Sep 10, 2009 at 5:05 am
  • Yeah, you are correct. It is a bug. It will be great if you can submit a patch. Prasad From: David Lerman <dlerman@videoegg.com Reply-To: <hive-user@hadoop.apache.org Date: Fri, 4 Sep 2009 13:19:28 ...
    Prasad ChakkaPrasad Chakka
    Sep 4, 2009 at 8:26 pm
    Sep 4, 2009 at 8:48 pm
  • Including hive-user in case someone has any experience with this.. Thanks -Matt ---------- Forwarded message ---------- From: Matt Pestritto <matt@pestritto.com Date: Tue, Sep 29, 2009 at 5:26 PM ...
    Matt PestrittoMatt Pestritto
    Sep 30, 2009 at 1:51 pm
    Sep 30, 2009 at 9:29 pm
  • I have some files with mixed characters from all over the world. utf-8, latin1, latin9, and like 10 others. These are international files of raw IM logs. Is there a way to load these files as is into ...
    Tom kersnickTom kersnick
    Sep 25, 2009 at 9:58 pm
    Sep 27, 2009 at 12:25 am
  • Is it possible to write a hive UDF that has an access to distributed cache OR a way to look up information from a file in an evaluate function? Are there any examples around? Thanks, Abhi
    Abhijit PolAbhijit Pol
    Sep 25, 2009 at 9:19 pm
    Sep 26, 2009 at 2:17 am
  • Hi, I am trying to save a table into a local file as a text file (as opposed to binary file). I use the following command INSERT OVERWRITE LOCAL DIRECTORY '/path/to/file' SELECT * FROM table1; ...
    Avishay LivneAvishay Livne
    Sep 17, 2009 at 12:55 pm
    Sep 20, 2009 at 10:15 am
  • Hi, I'm trying to get hive jdbc work with DBVisualizer. I added a new driver using DBVisualizer driver interface and specified all the relevant jar files. DBVisualizer can register the driver fine, ...
    VijayVijay
    Sep 18, 2009 at 9:32 pm
    Sep 18, 2009 at 9:51 pm
  • I have a table which has a partition that I load data into with: LOAD DATA INPATH 'filepath' INTO TABLE summary PARTITION('..'); However, this moves the file addressed by /filepath/ into the table or ...
    Mayuran YogarajahMayuran Yogarajah
    Sep 15, 2009 at 10:32 pm
    Sep 16, 2009 at 7:24 pm
  • I have created another release candidate for Hive. https://svn.apache.org/repos/asf/hadoop/hive/tags/release-0.4.0-rc1/ Let me know if it is OK to publish this release candidate. The only change from ...
    Namit JainNamit Jain
    Sep 15, 2009 at 8:32 pm
    Sep 15, 2009 at 11:41 pm
  • Hi, everyone. I am surveying whether Hive is integrated with Hbase. I mean, does Hive support some query and other operations like create \write\append to HBase tables directly? I found ...
    Liu XianglongLiu Xianglong
    Sep 10, 2009 at 1:42 pm
    Sep 11, 2009 at 4:55 am
  • I encountered this behavior twice today, but before filing a JIRA I thought I'd seek confirmation this is indeed a bug and not a potential configuration issue. While running queries of the form ...
    James warrenJames warren
    Sep 9, 2009 at 5:45 am
    Sep 9, 2009 at 5:04 pm
  • Hi. I was wondering if you could replace the Tab and LF to a string <TAB and <LF in the describe extended output ? I have tables defined delimited with \t and breaks using \n so the output of ...
    Matt PestrittoMatt Pestritto
    Sep 8, 2009 at 11:50 pm
    Sep 9, 2009 at 12:20 am
  • I can see error code propagated in HWI. Is there a way to propagate error message all the way up to the user interface? Often user make an error entering query and they only get to know the error ...
    Abhijit PolAbhijit Pol
    Sep 8, 2009 at 11:19 pm
    Sep 8, 2009 at 11:47 pm
  • Hi, I am trying to learn Hive, but am having problems as I am getting a lot of error messages that do not hint at how to resolve whatever problem is occurring in my setup. I can successfully create a ...
    Ryan RosarioRyan Rosario
    Sep 6, 2009 at 7:07 pm
    Sep 8, 2009 at 7:11 am
  • Hello, I've built and installed hive-trunk with hadoop 0.20.0. But I cannot execute query on it. I was able to create table 'pokes' in example and load data into it successfully. But when I execute ...
    Shotaro KamioShotaro Kamio
    Sep 7, 2009 at 7:57 am
    Sep 8, 2009 at 4:18 am
  • Hi, When using the INSERT OVERWRITE TABLE ... FROM SELECT syntax, you can specify partition information for the inserts. However, these partition values can only be literals. This seems too ...
    VijayVijay
    Sep 5, 2009 at 4:09 am
    Sep 5, 2009 at 8:23 am
  • Hive supports column based storage using RC files. https://issues.apache.org/jira/browse/HIVE-352 The question is: if I store hive tables in this format and once in a while would like run some custom ...
    Abhijit PolAbhijit Pol
    Sep 4, 2009 at 11:48 pm
    Sep 5, 2009 at 12:18 am
  • Hadoop Fans, we're getting down to the wire for Hadoop World. We couldn't be happier with how the schedule has come together. For a full list of speakers and registration details, see ...
    Christophe BiscigliaChristophe Bisciglia
    Sep 15, 2009 at 9:41 pm
    Sep 15, 2009 at 9:41 pm
  • Hi all, I has used Pig for several months. And now I am very interested in Hive, and would like to investigate Hive and compare these two amazing products. Also I hope I can contribute to Hive. And ...
    Jeff ZhangJeff Zhang
    Sep 8, 2009 at 3:42 pm
    Sep 8, 2009 at 3:42 pm
  • Hi, We have 2 tables that need to be merged into third table (TableMerged). TableOld :CREATE TABLE TableOld (userid STRING, terms MAP<STRING, DOUBLE ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ...
    Michal shmueliMichal shmueli
    Sep 7, 2009 at 6:56 am
    Sep 7, 2009 at 6:56 am
Group Navigation
period‹ prev | Sep 2009 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions46
posts215
users40
websitehive.apache.org

40 users for September 2009

Edward Capriolo: 22 posts Namit Jain: 19 posts Zheng Shao: 17 posts Abhijit Pol: 16 posts Prasad Chakka: 15 posts Sudipto Das: 11 posts Vijay: 10 posts Mayuran Yogarajah: 9 posts Ashish Thusoo: 8 posts Brad Heintz: 8 posts Avram Aelony: 7 posts Bill Graham: 7 posts Eva Tse: 6 posts Min Zhou: 6 posts Raghu Murthy: 6 posts He Yongqiang: 5 posts Royce Rollins: 5 posts David Lerman: 3 posts Jason Michael: 3 posts Matt Pestritto: 3 posts
show more
Archives