Search Discussions
-
Hi all, we had a query joining two tables, one of which had about 1 billions pieces of records while the other had less than 20k. below is our query: set hive.mapjoin.cache.numrows=20000; select /*+ ...
Min Zhou
Jun 15, 2009 at 4:24 am
Jun 18, 2009 at 1:52 am -
Hi all, Any helps? thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: ...
Min Zhou
Jun 4, 2009 at 5:31 am
Jun 5, 2009 at 10:12 am -
Hi, I am new to Hive. I would like to know what is the easiest way to get the difference between two sets. For example, how can I convert the following SQL query to Hive? select user from page_views ...
Rakesh Setty
Jun 29, 2009 at 11:03 pm
Jun 30, 2009 at 12:28 am -
I'm trying to build a tool which runs a query and writes the results into an automatically generated Hive table. It's all very straightforward, except that I can't find a good way to determine the ...
David Lerman
Jun 28, 2009 at 4:07 pm
Jun 29, 2009 at 7:03 pm -
We get this error when having ³cast (tablename.properties['time'] as int)/3600.0² in the select clause of a hive query (with join). Is this a known problem/limitation? BTW, this only happens when ...
Eva Tse
Jun 15, 2009 at 12:34 am
Jun 22, 2009 at 11:42 pm -
We have a requirement to write an udf returning map/list values. pseudo code of this udf like below public class MyUDF extends UDF { public Map<?,? evaluate(String lhs, String rhs) { ... } } will it ...
Min Zhou
Jun 10, 2009 at 11:17 am
Jun 12, 2009 at 2:26 am -
I have a query like below, SELECT a.subid, a.id, t.url FROM tbl t JOIN aux_tbl a ON t.url rlike a.url_pattern WHERE t.dt='20090609' AND a.dt='20090609'; and parser reported 'FAILED: Error in semantic ...
Min Zhou
Jun 10, 2009 at 6:38 am
Jun 10, 2009 at 8:38 am -
Hi all, Yuntao Jia, our intern this summer, did a simple performance benchmark for Hadoop, Hive and Pig based on the queries in the SIGMOD 2009 paper: A Comparison of Approaches to Large-Scale Data ...
Zheng Shao
Jun 19, 2009 at 4:30 am
Jun 19, 2009 at 6:08 pm -
Hi all, How can generate plan files like those .q.xml files exist in ql/src/test/results/compiler/plan/** for checking my plan? Thanks, Min -- My research interests are distributed systems, parallel ...
Min Zhou
Jun 1, 2009 at 6:43 am
Jun 1, 2009 at 4:34 pm -
trying to run the following query: insert overwrite table imp_test3 partition(ds="20090513") select d["query_string"] from imp where imp.ds="20090513" and imp.hour="00"; causes all of the tasks in ...
Larry Ogrodnek
Jun 30, 2009 at 11:44 pm
Jul 1, 2009 at 5:07 pm -
We are using hive 0.3.0 and are getting the following when joining on Integer fields. We are also getting a very similar problem using the case UDF is this a known problem? java.io.IOException: ...
Bill Craig
Jun 15, 2009 at 10:17 pm
Jun 16, 2009 at 12:30 am -
Hi guys, Driver.getSchema() obtains current result's tableDesc and assemble it to a String. I found if do select all queries on a table contains partitions, a null pointer exception will happens. See ...
Min Zhou
Jun 19, 2009 at 7:18 am
Jun 19, 2009 at 10:56 pm -
Hi, I have this error * FAILED: Unknown exception : Wrong FS: hdfs:// 10.1.1.3:9000/tmp/hive-hadoop/1201106067, expected: hdfs://slave:9000* when i tried to do select statement in hive. I have loaded ...
PORTO aLET
Jun 13, 2009 at 5:05 am
Jun 13, 2009 at 8:52 am -
Hi, For the second time in two weeks I'm getting errors that blocks that once existed have gone missing from HDFS and I'm baffled as to the cause, or even how to troubleshoot the issue. Any help ...
Bill Graham
Jun 12, 2009 at 7:55 pm
Jun 12, 2009 at 8:27 pm -
Most probably metastore died. What were you doing when this happened and also what is the log on metastore side? Prasad from bberry ----- Original Message ----- From: Bill Craig <bcraig7@gmail.com ...
Prasad Chakka
Jun 4, 2009 at 7:38 pm
Jun 4, 2009 at 7:52 pm -
Hi, I've been testing the Hive JDBC client and I think I've come a across a few bugs, but I wanted to double check my understanding of the expected behavior before opening JIRAs. I'm running the hive ...
Bill Graham
Jun 1, 2009 at 10:19 pm
Jun 1, 2009 at 11:18 pm -
We have several openings for engineers who can help us build a data warehouse on top of hadoop + hive. We've been running a 30 node cluster for the past year using streaming and cascading and are now ...
David J. O'Dell
Jun 30, 2009 at 5:04 pm
Jun 30, 2009 at 5:04 pm -
Bay Area Hadoop Fans, We're excited to hold our first Hadoop User Group at Cloudera's office in Burlingame (just south of SFO). We pushed the start time back 30 minutes to allow a little extra time ...
Christophe Bisciglia
Jun 25, 2009 at 12:04 am
Jun 25, 2009 at 12:04 am -
Hi facebook guys, Can you synchronise your fb303 thrift code? $thrift -gen java -I metastore/include -I . service/if/hive_service.thrift ...
Min Zhou
Jun 16, 2009 at 8:25 am
Jun 16, 2009 at 8:25 am -
I've been able to piece together a rough guide for implementation from various blogs / jiras, but does anyone have a basic example publicly available? There are stubs in the wiki but unfortunately ...
James warren
Jun 12, 2009 at 11:07 pm
Jun 12, 2009 at 11:07 pm -
Some progress on getting JDBC to work with Hive using MySQL. The problem was: [java] 09/06/02 08:31:33 INFO metastore.ObjectStore: jpox.properties not found. The jpox default for NontransactionalRead ...
Bcraig7
Jun 2, 2009 at 3:20 pm
Jun 2, 2009 at 3:20 pm -
Hadoop Fans, I'm happy to announce a new tool from the Cloudera team. We often found our customers wanting to import data from RDBMSs so they could conduct deeper analysis. To facilitate this, we ...
Christophe Bisciglia
Jun 1, 2009 at 5:10 pm
Jun 1, 2009 at 5:10 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 23 |
posts | 106 |
users | 25 |
website | hive.apache.org |
25 users for June 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)