Search Discussions
-
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 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, 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, 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 ...
Vijay
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 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 ...
Vijay
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 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 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 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 ...
Luocanrao
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 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)?
Bcotton3
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 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 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 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, 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 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 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 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 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 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 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 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 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 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 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 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, Lee
Dec 15, 2009 at 11:09 pm
Dec 15, 2009 at 11:09 pm -
0
Test
Test. Pls disregard.Michael 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 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 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 Barclay
Dec 1, 2009 at 1:07 am
Dec 1, 2009 at 1:07 am
Group Overview
group | user |
categories | hive, hadoop |
discussions | 32 |
posts | 110 |
users | 33 |
website | hive.apache.org |
33 users for December 2009
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)