FAQ

Hive > user > December 2009

Search Discussions

32 discussions - 110 posts

  • Hi, I'm revisiting Hive after a long hiatus, so I may not be aware of any new developments. I had written a script some time back to import webserver logs for a day into a new partition. The same ...
    Saurabh NandaSaurabh Nanda
    Dec 30, 2009 at 5:57 am
    Jan 4, 2010 at 8:26 pm
  • I am trying to insert data into table ZZ with an outer join result of A and B, the Join is a LIKE b/t a filed from table A and a field from table B: INSERT OVERWRITE TABLE ZZ SELECT VOTF_REQUEST_ID , ...
    Sagi, LeeSagi, Lee
    Dec 15, 2009 at 11:09 pm
    Dec 16, 2009 at 12:58 am
  • Is there a way to throttle hive queries? For example, I want to tell hive to not use more then 1000 mappers and 5 reducers for a particular query (or session).
    Sagi, LeeSagi, Lee
    Dec 17, 2009 at 6:58 pm
    Dec 19, 2009 at 8:20 pm
  • Can anyone share their ETL workflow experiences with Hive? For example, how do you transform data from log files to Hive tables? Do you use hive with map/reduce scripts or do you use hive ...
    VijayVijay
    Dec 14, 2009 at 9:00 pm
    Dec 16, 2009 at 9:48 pm
  • Hi all I am totally new to hive..... I am trying to get a remote connection to hive using jdbc. I am using the example provided in the documentation. I have copied all the jars required to my class ...
    Ronan TobinRonan Tobin
    Dec 14, 2009 at 12:29 pm
    Dec 15, 2009 at 11:08 pm
  • Amazon Elastic MapReduce version of Hive seems to have a nice feature called "Variables." Basically you can define a variable via command-line while invoking hive with -d DT=2009-12-09 and then refer ...
    VijayVijay
    Dec 20, 2009 at 2:29 am
    Dec 30, 2009 at 8:26 pm
  • I'm running into errors where CombinedHiveInputFormat is combining data from two different tables which is causing problems because the tables have different input formats. It looks like the problem ...
    David LermanDavid Lerman
    Dec 15, 2009 at 12:44 am
    Dec 22, 2009 at 3:24 pm
  • All: I've been setting up Hive using Derby in Server Mode as per the instructions here: http://wiki.apache.org/hadoop/HiveDerbyServerMode After I've got everything finished I attempt to start Hive ...
    Nathan RaschNathan Rasch
    Dec 23, 2009 at 8:18 pm
    Jan 5, 2010 at 3:58 pm
  • Hi, I have installed hadoop-0.19.2 on my system in a pseudo-distributed mode and I am using hive to access data. When I am trying to access data by executing a query (i. g. select * from ...
    Mohan AgarwalMohan Agarwal
    Dec 21, 2009 at 4:58 am
    Dec 22, 2009 at 1:51 am
  • when I use select command in hive cosole SELECT pv_gender_sum.* FROM pv_gender_sum , all chinese words display wrong I guess is Character coding problem. Any body can give me some help? but if i use ...
    LuocanraoLuocanrao
    Dec 27, 2009 at 8:03 am
    Dec 28, 2009 at 12:33 pm
  • ODBC driver. Indeed! Hive's appeal is that it provides an SQL-familiar view of Hadoop data operators and operands. Familair desktop tools for interacting w/ these data views (Excel, Acess, SqlDbx, ...
    Ben CottonBen Cotton
    Dec 8, 2009 at 7:41 pm
    Dec 8, 2009 at 10:11 pm
  • Does there exist a driver that can be used to define a DSN that connects Windows desktop apps to Hive (via ODBC DataSource)?
    Bcotton3Bcotton3
    Dec 8, 2009 at 4:44 pm
    Dec 8, 2009 at 7:21 pm
  • Hey there, After some basic experimentation for this feature, I've written up a wiki page with some of the issues to be resolved during development: http://wiki.apache.org/hadoop/Hive/ViewDev If you ...
    John SichiJohn Sichi
    Dec 22, 2009 at 1:21 am
    Dec 22, 2009 at 3:40 am
  • Hello, I'd like to store my log file data that's imported into Hive in compressed format. I was following some steps outlined by Zheng on how to do that, where he says: CREATE TABLE texttable (...) ...
    Ken BarclayKen Barclay
    Dec 17, 2009 at 2:16 am
    Dec 21, 2009 at 8:47 am
  • Hi, I'm looking for a way to change a table's collection and map-key delimiters -- I've found hints that it might be possible, but I can't figure out how to actually do it. I started by creating a ...
    Owen RaccugliaOwen Raccuglia
    Dec 30, 2009 at 5:35 pm
    Dec 31, 2009 at 8:17 pm
  • I'm trying to create a local os file from a hive query: INSERT OVERWRITE LOCAL DIRECTORY '../../dwh_out/click_term_20091219.dat' SELECT a.date_key, a.deal_id, a.is_roi, a.search_query, ...
    Sagi, LeeSagi, Lee
    Dec 22, 2009 at 12:46 am
    Dec 22, 2009 at 1:18 am
  • Hello all, The cluster has a capacity of 28 concurrent mappers. It looks like on larger tables Hive will use all 28 mappers, but on a smaller table it only uses 4 mappers maximum. Any idea how to ...
    Ryan LeCompteRyan LeCompte
    Dec 10, 2009 at 9:45 pm
    Dec 11, 2009 at 12:26 am
  • Hi, When the "LOAD DATA INPATH" is issued, does Hive modify the metastore data, or do anything else special besides just moving the files in HDFS? I've got a daily MR job that runs before I need to ...
    Bill GrahamBill Graham
    Dec 9, 2009 at 6:04 am
    Dec 9, 2009 at 6:13 am
  • I looked in hive.log while doing the CREATE TABLE and found: 2009-11-30 17:51:53,240 WARN serde2.RegexSerDe (RegexSerDe.java:deserialize(179)) - 1 unmatched rows are found: Nov 2 23:00:04 sf45-cc2 ...
    Ken BarclayKen Barclay
    Dec 1, 2009 at 2:11 am
    Dec 1, 2009 at 3:51 am
  • Issue Navigator [ Permlink<https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=12310843&status=1&fixfor=12314156&sorter/field=issuekey&sorter/order=DESC ] Displaying issues 1 to ...
    Namit JainNamit Jain
    Dec 28, 2009 at 7:05 pm
    Dec 28, 2009 at 7:05 pm
  • The current JDBC driver depends too many other modles of Hive, thus, it cannot be delivered as a independent jar to JDBC-based SQL client.
    Schubert ZhangSchubert Zhang
    Dec 24, 2009 at 10:10 am
    Dec 24, 2009 at 10:10 am
  • I often tune mapred.map.tasks & mapred.reduce.tasks per Hive query. For example. set mapred.map.tasks=31; set mapred.reduce.tasks=11; FROM Pageviews2 p join client_ip c on c.id = p.clientip_id insert ...
    Edward CaprioloEdward Capriolo
    Dec 23, 2009 at 7:32 pm
    Dec 23, 2009 at 7:32 pm
  • All, I am going to be speaking at the NYC BSD users group. Though this presentation is geared for hadoop first timers, but I am going to speak a bit about Hive. ...
    Edward CaprioloEdward Capriolo
    Dec 23, 2009 at 6:47 pm
    Dec 23, 2009 at 6:47 pm
  • All: I have a number of Hadoop jobs that push their results into the Hive warehouse and then create Hive tables to query against the data. So far this works great for a single user, but our end goal ...
    Nathan RaschNathan Rasch
    Dec 21, 2009 at 9:38 pm
    Dec 21, 2009 at 9:38 pm
  • Hadoop Fans, it's been a few weeks since we've hosted public training sessions, and now we're happy to announce three sessions in three cities over the next three months. These sessions are all ...
    Christophe BiscigliaChristophe Bisciglia
    Dec 21, 2009 at 9:07 pm
    Dec 21, 2009 at 9:07 pm
  • I remember trying it early in the metastore development and had couple of problems but didn't really try to debug them. I would like you to try it and report any issue though. From: David Lerman ...
    Prasad ChakkaPrasad Chakka
    Dec 21, 2009 at 6:24 pm
    Dec 21, 2009 at 6:24 pm
  • Hi Folks, We have release the rc3 candidate as Hive 0.4.1. You can find download it from the download page. http://hadoop.apache.org/hive/releases.html#Download Thanks, Zheng
    Zheng ShaoZheng Shao
    Dec 17, 2009 at 10:37 pm
    Dec 17, 2009 at 10:37 pm
  • Sagi, Lee would like to recall the message, "connecting remotely to hive via jdbc".
    Sagi, LeeSagi, Lee
    Dec 15, 2009 at 11:09 pm
    Dec 15, 2009 at 11:09 pm
  • Test. Pls disregard.
    Michael HamrickMichael Hamrick
    Dec 8, 2009 at 4:29 am
    Dec 8, 2009 at 4:29 am
  • The "datancucleus.transactionIsolation" setting in hive-default.xml is "read-committed". This doesn't work in our setup (read-committed isn't compatible with statement based replication in mysql 5.1) ...
    David LermanDavid Lerman
    Dec 2, 2009 at 8:52 pm
    Dec 2, 2009 at 8:52 pm
  • I have made a release candidate Hive 0.4.1-rc3. Location http://people.apache.org/~zshao/hive-0.4.1-candidate-3/ svn: https://svn.apache.org/repos/asf/hadoop/hive/tags/release-0.4.1-rc3/ We've fixed ...
    Zheng ShaoZheng Shao
    Dec 1, 2009 at 10:25 pm
    Dec 1, 2009 at 10:25 pm
  • Hello, I'm getting only NULLs when trying to read data from an external table for which the data was staged. I'm using Cloudera's hive-0.4.0+14.tar.gz with hadoop-0.20.1+152.tar.gz on a Centos ...
    Ken BarclayKen Barclay
    Dec 1, 2009 at 1:07 am
    Dec 1, 2009 at 1:07 am
Dec 2009
Group Navigation
period‹ prev | Dec 2009 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions32
posts110
users33
websitehive.apache.org

33 users for December 2009

Sagi, Lee: 14 posts Zheng Shao: 13 posts Saurabh Nanda: 8 posts Edward Capriolo: 6 posts Namit Jain: 6 posts Vijay: 6 posts Ken Barclay: 5 posts Carl Steinbach: 5 posts David Lerman: 5 posts Mohan Agarwal: 4 posts Prasad Chakka: 4 posts John Sichi: 3 posts Luocanrao: 3 posts Ronan Tobin: 3 posts Todd Lipcon: 3 posts Ben Cotton: 2 posts Nathan Rasch: 2 posts Owen Raccuglia: 2 posts Ryan LeCompte: 2 posts 김영우: 1 post
show more
Archives