Search Discussions
-
I migrated from Hive-0.30 to Hive-trunk (r802989 compiled against Hadoop 0.18.3), copied over metastore_db & the conf directory. Output compression used to work with my earlier Hive installation, but ...
Saurabh Nanda
Aug 13, 2009 at 4:14 am
Aug 25, 2009 at 12:18 pm -
Here's what I'm trying: ResultSet rs=st.executeQuery("show tables"); while(rs.next()) { System.out.println(rs.getString(1)); } The while loop never terminates, after going through the list of tables, ...
Saurabh Nanda
Aug 4, 2009 at 7:48 am
Aug 7, 2009 at 2:08 am -
When I run hive in cli mode, I add the hive_contrib.jar file using this command: hive add jar lib/hive_contrib.jar Is there a way to do this automatically when running hive in hwi or hiveserver ...
Vijay
Aug 23, 2009 at 2:19 am
Aug 27, 2009 at 3:30 am -
In the Hive paper <Hive - A Warehousing Solution Over a MapReduce Framework , the section 5 describes the FUTURE WORK of Hive. I want to get more detail of following tow points: (1) Hive currently ...
Schubert Zhang
Aug 5, 2009 at 7:06 am
Aug 10, 2009 at 7:35 pm -
Hi I was wondering if anyone has thought about the possibility of having dynamic partitioning in Hive? Right now you typically use LOAD DATA or ALTER TABLE to add new partitions. It would be great ...
Chris Goffinet
Aug 11, 2009 at 6:16 pm
Sep 28, 2009 at 4:47 pm -
Hi, I built a UDF function to decode the URLs from the log files. When I run the script in Hive, i get the following error message. Is there something I should be catching beside the NULL values? ...
Ray Duong
Aug 20, 2009 at 11:29 pm
Aug 25, 2009 at 4:55 pm -
Is the "add file" command not supported in the JDBC API? I need to use it for subsequent custom map/reduce scripts in various queries. The file is available locally to the Hive server. 09/08/10 ...
Saurabh Nanda
Aug 10, 2009 at 5:12 am
Aug 12, 2009 at 4:47 am -
This probably explains the failure of those links. ASF infra is already looking at it. Ashish -----Original Message----- From: Giridharan Kesavan Sent: Wednesday, August 05, 2009 8:46 PM To: ...
Ashish Thusoo
Aug 6, 2009 at 6:12 pm
Aug 11, 2009 at 4:00 am -
Hi, I'm trying to set up a MySQL metastore for Hive and I'm getting the exceptions shown below. If anyone could shed some insight as to why this is happening, it would be greatly appreciated. My ...
Bill Graham
Aug 5, 2009 at 5:38 pm
Aug 5, 2009 at 6:49 pm -
I've finally given up waiting for the nightly builds and have decided to build Hive from trunk. Here's the command that I'm using: ant -Dhadoop.version=0.18.3 package When I've instructed to build ...
Saurabh Nanda
Aug 11, 2009 at 5:38 am
Aug 11, 2009 at 9:01 am -
Hi all, It seems SerDe read files line by line. And each time I only get one line. But in my files, some lines actually do not represent records, e.g. some lines just represent the meta data of ...
Zhang jianfeng
Aug 5, 2009 at 10:20 am
Aug 6, 2009 at 7:36 am -
I thought one map only job is ok. try hive explain insert overwrite table tmp partition(dt=1) select bar, foo from pokes; Thanks, Min -- My research interests are distributed systems, parallel ...
Min Zhou
Aug 4, 2009 at 3:02 am
Aug 6, 2009 at 4:27 am -
Hi Ashish, thanks for help! 1) regarding the group-by-week, it was entirely my fault... I miswrote the function... to get grouping by week one needs to have FIELD: date_add('2007-12-31', ...
Andraz Tori
Aug 4, 2009 at 2:22 pm
Aug 5, 2009 at 3:15 pm -
Can I pass parameters to custom map/reduce scripts like this: from try_hits select transform ip_address, aid, uid using 'parse_logs.rb MY_PARAM_HERE' as ip_address, aid, uid I've tried it, and it ...
Saurabh Nanda
Aug 4, 2009 at 12:43 pm
Aug 4, 2009 at 6:21 pm -
I am getting this error... 09/08/28 23:19:56 WARN mortbay.log: Failed startup of context org.mortbay.jetty.webapp.WebAppContext@203c31{/hwi,${HIVE_HOME}/lib/hive-hwi.war} ...
Edward Capriolo
Aug 29, 2009 at 3:32 am
Sep 10, 2009 at 12:46 am -
http://www.hadooper.cn/hadoop/cgi-bin/moin.cgi/thirdcfp Time : Sunday, November 15, 2009 City: Beijing, China Sponsored by Yahoo!, Cloudera Organized by hadooper.cn Website: ...
He Yongqiang
Aug 21, 2009 at 4:22 pm
Sep 2, 2009 at 1:04 am -
The other_properties column in log_table is also of the same type. We are using such a query to merge small files in our tables. We get the following array index out of bounds exceptions from all the ...
Eva Tse
Aug 31, 2009 at 4:07 am
Aug 31, 2009 at 9:58 pm -
Hi, I'm quite new to hive and so far everything has been working very good. I'm able to setup a small vm-based cluster, ingest a lot of our access logs and generate some pretty neat reports mostly to ...
Vijay
Aug 20, 2009 at 11:44 pm
Aug 23, 2009 at 2:50 am -
Hello hive users, I am getting the following exception while running bin/hive java.io.IOException: Permission denied at java.io.UnixFileSystem.createFileExclusively(Native Method) at ...
Vinay gupta
Aug 20, 2009 at 7:30 pm
Aug 21, 2009 at 9:05 am -
I get correct result if I run: hive -e "select count(1) from blah blah" But I get no result if I run: nohup hive -e "select count(1) from blah blah" In both cases, hive exited with 0 (success). Very ...
Steven Wong
Aug 20, 2009 at 10:22 pm
Aug 21, 2009 at 2:24 am -
Hi all, I have some udfs and my own SerDe. Each time I start Hive, I have to execute command: add jar hive_contrib.jar Is there any way to add this jar automatically ? And Can Hive detect the jar ...
Zhang jianfeng
Aug 17, 2009 at 6:42 am
Aug 19, 2009 at 6:09 am -
Hi, I have been using the following tutorial to run hive queries on amazon ec2 hadoop cluster http://wiki.apache.org/hadoop/Hive/Hi... I can ssh into the master node with the following command ssh -i ...
Sumit khanna
Aug 14, 2009 at 5:27 pm
Aug 14, 2009 at 7:12 pm -
Hi, I have some questions about using SELECT with UNION. I have a number of access log files that I want to process to select counts per day matching a specific pattern in the URL. This is very ...
Vijay
Aug 13, 2009 at 11:43 pm
Aug 14, 2009 at 1:00 am -
Hey all, Is there any news on having an 'INSERT APPEND TABLE' rather than forcing use of OVERWRITE? Is there another alternative at present other than INSERT to a temp table and doing a 'copy' of the ...
Neal Richter
Aug 8, 2009 at 6:59 pm
Aug 13, 2009 at 4:05 am -
I have a simple hadoop cluster setup with a couple of machines (one master running everything and one additional slave). I have hive configured with the right hive-site.xml file pointing the ...
Vijay
Aug 12, 2009 at 12:51 am
Aug 12, 2009 at 4:27 am -
We are running a Hive query like the following: from (select sum (c.countrow) as countrow, c.c_id as c_id, f.dt_id as dt_id, f.xid as xid, f.esn as esn, f.hour as hour from session_facts f join ...
Eva Tse
Aug 28, 2009 at 2:09 am
Aug 28, 2009 at 10:20 pm -
I am unable to running a specifc ant test on one q file in contrib... contrib]$ ant -Dtestcase=TestCliDriver -Dqfile=dboutput.q test This does not work: Running from the svn root results in the ...
Edward Capriolo
Aug 26, 2009 at 3:11 pm
Aug 27, 2009 at 12:17 am -
Hi, I just upgraded hive by taking the latest trunk and building it and installing it in the same path as before. But after the upgrade, "show tables;" returns nothing...? Did I miss some step? I ...
Vinay gupta
Aug 26, 2009 at 12:19 am
Aug 26, 2009 at 12:25 am -
There are too many mappers in Hive. Table has approximately 50K rows, number of bytes = 5,654,500. the query is select count(1) from TABLE group by COLUMN There are only 2 nodes. On the Web UI I can ...
Ravi Jagannathan
Aug 25, 2009 at 8:08 pm
Aug 25, 2009 at 8:57 pm -
I have a simple query like this (identify hosts that have more than one request): select host, count(1) as cnt from accesslogs where cnt 1 group by host; and it throws the error Invalid Table Alias ...
Vijay
Aug 21, 2009 at 1:55 am
Aug 21, 2009 at 3:23 am -
Folks, I have a table with this schema: (int key, values MAP<String, String ). I want to fetch the data from the table into local Map in my java code. Following the hive JDBC example, I did : String ...
Michal shmueli
Aug 20, 2009 at 10:01 am
Aug 20, 2009 at 6:18 pm -
Hi, i launched a cluster using hadoo-ec2 scripts. I then sshed into the masternode After i log into hive i tried creating a table hive create external table kv (key int, values string) location ...
Sumit khanna
Aug 14, 2009 at 7:08 pm
Aug 18, 2009 at 7:24 am -
We currently run hive and store all our data in a warehouse on /user/hive/warehouse. Now we want to move the original warehouse from /user/hive/warehouse to new /user/hive/$USER/warehouse and retain ...
Eva Tse
Aug 13, 2009 at 2:19 am
Aug 18, 2009 at 1:24 am -
What is the best way to get debug info to the Hive devs if this happens again? - Neal Starting Job = job_200907281406_0792, Tracking URL = ...
Neal Richter
Aug 9, 2009 at 3:24 pm
Aug 14, 2009 at 5:34 am -
Hi to all Hivers out there! Does Hive currently support column-based storage? For example, can we use HBase tables as Hive table inputs for HQL? Thanks in advance, Haggai
Haggai Roitman
Aug 4, 2009 at 1:14 pm
Aug 4, 2009 at 2:19 pm -
We discovered a problem where loading into a new partition in hive w/o specifying Œoverwrite¹ doesn¹t work. If the specified partition does not exist yet, running the following statement would not ...
Eva Tse
Aug 1, 2009 at 1:28 am
Aug 3, 2009 at 7:08 pm -
Hi all, I’d like to use my own serde to load my data, so I want to first test it in local mode. Does Hive has a local mode like Pig ? So that I can debug the program in eclipse ? Thank you. Jeff zhang
Zhang jianfeng
Aug 2, 2009 at 3:57 pm
Aug 3, 2009 at 4:59 pm -
Hi, We have some old map-reduce scripts that store the results into key - value, value, value pairs. What is the best way to load the data into Hive and then transpose (shuffle) the data into value - ...
Ray Duong
Aug 31, 2009 at 5:24 pm
Aug 31, 2009 at 5:24 pm -
Hadoop Fans, please pardon the short notice, but we wanted to let you know that we are offering a 3 day training program at the end of the month in San Francisco. There is a $300 discount for those ...
Christophe Bisciglia
Aug 14, 2009 at 2:03 am
Aug 14, 2009 at 2:03 am -
G Sent via BlackBerry from Vodafone -----Original Message----- From: hive-user-digest-help@hadoop.apache.org Date: 10 Aug 2009 05:13:06 To: <hive-user@hadoop.apache.org Subject: hive-user Digest 10 ...
Andraž Tori
Aug 12, 2009 at 4:19 pm
Aug 12, 2009 at 4:19 pm -
Hi. Can someone clarify the use of structs as a complex data type for me ? S.x S is a struct returns the x field of S e.g for struct foobar {int foo, int bar} foobar.foo returns the integer stored in ...
Matt Pestritto
Aug 6, 2009 at 3:36 pm
Aug 6, 2009 at 3:36 pm -
When setting HIVE_AUX_JARS_PATH, "hive" starts ok, but "hive --service hiveserver" fails. If HIVE_AUX_JARS_PATH is not set, then hive server starts without problems. What am I doing wrong? Also: when ...
Andraz Tori
Aug 5, 2009 at 9:46 am
Aug 5, 2009 at 9:46 am -
We have added some examples and general guide on how to write a new SerDe and UDF/UDAF. Please see http://www.slideshare.net/ragho/hive-user-meeting-august-2009-facebook Page 59-87 -- Yours, Zheng
Zheng Shao
Aug 5, 2009 at 5:09 am
Aug 5, 2009 at 5:09 am -
Hadoop Fans, it looks like most of you prefer to have this on Thursday (November 5th), so that's what we'll plan for. Anyone is welcome to come to this meetup, even if you don't attend ApacheCon. ...
Christophe Bisciglia
Aug 5, 2009 at 2:31 am
Aug 5, 2009 at 2:31 am
Group Overview
group | user |
categories | hive, hadoop |
discussions | 44 |
posts | 187 |
users | 29 |
website | hive.apache.org |
29 users for August 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)