Search Discussions
-
Hi Hive users :-) Does anybody have experience of using Hive with MS SQL Server 2005? I’m currently stumped with the following issue https://issues.apache.org/jira/browse/HIVE-1391 where Hive (or ...
Shared
Mar 24, 2011 at 3:02 pm
Mar 30, 2011 at 8:15 am -
Hi Guys, I'm writing a UDAF to run against hive 0.5 or hive 0.7. The documentation I can find says to implement UDAFEvaluator and ensure that you implement init() , aggregate() and evaluate(). ...
Christopher, Pat
Mar 11, 2011 at 1:30 am
Mar 12, 2011 at 2:11 pm -
Hello, I am trying to execute a query that joins two large tables (3 million and 20 million records). I am getting the Hadoop error code 2 during execution. This happens mainly while the reducers are ...
Hadoop n00b
Mar 16, 2011 at 10:33 am
Mar 17, 2011 at 2:56 pm -
Hi, I am a hive newbie.I just finished setting up hive on a cluster of two servers for my organisation.As a test drill, we operated some simple queries.It took the standard map-reduce algorithm ...
Abhishek pathak
Mar 7, 2011 at 9:19 am
Mar 11, 2011 at 2:54 pm -
Hi, I loaded a data set which has 1 million rows into both Hive and HBase tables. For the HBase table, I created a corresponding Hive table so that the data in HBase can be queried from Hive QL. Both ...
Biju Kaimal
Mar 8, 2011 at 6:00 am
Mar 9, 2011 at 9:51 pm -
I have the following join that takes 4.5 hours (with 12 nodes) mostly because of a single reduce task that gets the bulk of the work: SELECT ... FROM T LEFT OUTER JOIN S ON T.timestamp = S.timestamp ...
Igor Tatarinov
Mar 20, 2011 at 6:55 am
Mar 21, 2011 at 3:22 am -
I want to have a function that returns the hour information from a date string (wiz not a known format supported by current date functions, but basically this is just a use case example). In pig, you ...
Michael Jiang
Mar 28, 2011 at 6:13 pm
Mar 29, 2011 at 2:24 am -
Hi, I am working on building a MR job that generates RCFiles that will become partitions of a hive table. I have most of it working however only strings (Text) are being deserialized inside of Hive. ...
Severance, Steve
Mar 17, 2011 at 10:45 pm
Mar 19, 2011 at 4:02 am -
my eng is very poor. i set up hive env use http://wiki.apache.org/hadoop/Hive/GettingStarted#Apache_Weblog_Data but i catch a exception when i run "SHOW TABLES;" script somebody can help me ? thanks ...
徐厚道
Mar 7, 2011 at 6:24 am
Mar 16, 2011 at 6:36 am -
Hi! I'm trying to gather statistics for tables by using the autogather functionality. It works for the size of the table and the number of files, but when I use the ANALYZE command, it tells me ...
Anja Gruenheid
Mar 4, 2011 at 3:29 am
Mar 5, 2011 at 5:58 pm -
Hi Experts I'm currently working with hive 0.7 mostly with JOINS. In all permissible cases i'm using map joins by setting the hive.auto.convert.join=true parameter. Usage of local map joins have made ...
Bejoy Ks
Mar 31, 2011 at 2:26 pm
Apr 1, 2011 at 2:18 pm -
Want to extend RegexSerDe to parse apache web log: for each log entry, need to convert it into multiple entries. This is easy in streaming. But new to serde, wondering if it is doable and how? Thanks!
Michael Jiang
Mar 30, 2011 at 6:56 pm
Mar 31, 2011 at 2:13 am -
Hi, My hive version is 0.6.0, I can query data like this: select * from table1; OK 1 wss 2 chenliang Time taken: 7.366 seconds But when the sql is ‘select id from table1;’, hive throws a exception: ...
王世森
Mar 22, 2011 at 8:32 am
Mar 23, 2011 at 9:21 am -
Hi, Does hive support dynamic configuration? For example: is it possible to write a hive script with some ${PARAM} variables and let hive replace these parameters with their values at runtime. Eg. ...
Amit jaiswal
Mar 21, 2011 at 3:11 pm
Mar 21, 2011 at 11:28 pm -
Hi, I have a hive script [given below] which calls a python script using transform and for large datasets [ 100M rows ], the reducer is not able to start the python process and the error message is ...
Irfan Mohammed
Mar 1, 2011 at 4:22 pm
Mar 2, 2011 at 2:54 pm -
As we prepare Hive for use by general business analysts and other end-users, I am wondering what the community's experience is with clients for end users? My user base currently is using tools such ...
Sunderlin, Mark
Mar 18, 2011 at 8:25 pm
Mar 24, 2011 at 9:49 pm -
Hey guys, I have a hive partitioned table. First I ran a query that look like this: Select count(*) Where field like '%bla%' and (partition '10' and partition < '20') For this query I got Some ...
Guy Doulberg
Mar 17, 2011 at 8:46 am
Mar 17, 2011 at 2:24 pm -
Hi Experts I'm facing a hurdle in transforming a SQL query to equivalent Hive QL with SQL NOT IN functionality. My SQL query would like this INSERT INTO Table1 ...
Bejoy Ks
Mar 8, 2011 at 8:43 am
Mar 8, 2011 at 11:53 am -
I've checked the mysql connection with a separate java file with the same string. Also, I've checked the code works by running it against the original derby metastore. Thanks, Ajo. Some of the ...
Ajo Fod
Mar 2, 2011 at 2:16 pm
Mar 3, 2011 at 1:30 pm -
Hey all, I bet someone has already asked this question before, but I couldn't a thread with an answer to it, I want to give analysts in my organization access to hive in a readonly way, I.E, I don't ...
Guy Doulberg
Mar 30, 2011 at 1:29 pm
Apr 4, 2011 at 2:04 pm -
Hello, I have a hive query which does a simple select and writes the results to a local file system. For example, a query like this, INSERT OVERWRITE LOCAL DIRECTORY ...
V.Senthil Kumar
Mar 30, 2011 at 3:53 am
Mar 30, 2011 at 8:19 pm -
Hey all, We use Amazon's elastic mapreduce and Hive 0.7 to run analytics queries, and I'm having problems dynamically adding functions for use in the thrift server. I want to add a jar, add a ...
Matthew Rathbone
Mar 24, 2011 at 8:36 pm
Mar 28, 2011 at 3:18 pm -
Hi, I am trying to connect the hive shell running on my laptop to a remote hadoop / hbase cluster and test out the HBase/Hive integration. I manage to connect and create the table in hbase from ...
Abhijit Sharma
Mar 16, 2011 at 4:52 pm
Mar 16, 2011 at 5:29 pm -
Hi, Just curious, has anybody experience on or is aware of an OLAP tool that works directly on Hive? OLAP4Cloud claims that ability on HBase but I don't have much details on that. Cheers!
Hadoop n00b
Mar 11, 2011 at 5:41 am
Mar 14, 2011 at 7:51 am -
Hi All, I was trying out hbase 0.89.20100924 with hive trunk with hadoop 0.20.2 When I'm running a simple insert I get this: java.lang.RuntimeException: Error in configuring object at ...
Bennie Schut
Mar 9, 2011 at 9:40 am
Mar 29, 2011 at 8:31 am -
Tim Kaldewey
Mar 24, 2011 at 9:30 pm
Mar 25, 2011 at 7:26 pm -
Met a problem that data in an external table didn't get read by hive. Here's how the table was created and data loaded. - Created an external table w/ a partition, pointing to an existing location in ...
Michael Jiang
Mar 23, 2011 at 7:41 pm
Mar 23, 2011 at 10:12 pm -
i down load hive 0.6 source tar.gz package. unzip and create project by myeclipse. but error occur. Severity and Description Path Resource Location Creation Time Id The project was not built since ...
徐厚道
Mar 23, 2011 at 8:32 am
Mar 23, 2011 at 10:34 am -
Hi, I am using hbase 0.90 and Hive 0.7 and would like to try the hive/hbase integration. From the Wiki Doc I could see that I have to rebuild the the handler: "If you are not using hbase-0.89.0, you ...
Jean-Charles Thomas
Mar 22, 2011 at 3:40 pm
Mar 23, 2011 at 2:23 am -
Hi all, I am testing RCFile on S3. I could execute queries which don't specify columns such as "select * from table". But, I could not execute queries which specify columns such as "select id from ...
Shunsuke Mikami
Mar 22, 2011 at 2:28 pm
Mar 23, 2011 at 12:47 am -
Hi! I've tried to run a create table statement via the HiveCLI in Eclipse and it fails with the following exception: FAILED: Error in metadata: MetaException(message:Got exception: ...
Anja Gruenheid
Mar 21, 2011 at 11:10 pm
Mar 22, 2011 at 12:54 pm -
Hi,all.Is it possible to generate mutiple records in one SerDe? I mean if I can return more than one rows in deserialize? Thanks!
幻
Mar 21, 2011 at 11:56 am
Mar 22, 2011 at 3:16 am -
Hi, I've been searching for a info on changing the Hive tracking url that shows up during processing, for example: Starting Job = job_201103091819_0073, Tracking URL = ...
Swinney, Austin
Mar 15, 2011 at 3:43 pm
Mar 15, 2011 at 5:02 pm -
Hi all Can someone please tell me how to achieve the following in a single hive script? set original_value = mapred.reduce.tasks; set mapred.reduce.tasks=1; ... do stuff set ...
Tim Robertson
Mar 12, 2011 at 6:46 pm
Mar 12, 2011 at 7:26 pm -
Hi Everyone I'm facing an issue with hive on a relatively larger query which involves joins on six hive tables. My query is running fine without any errors, all the map reduce jobs run to completion ...
Bejoy Ks
Mar 4, 2011 at 3:14 pm
Mar 8, 2011 at 8:27 am -
Let us say my log data that I want to place a log file into hive. And the log file itself looks something like this: Event_time, event_type, event_data_blob And the blob data looks like ...
Sunderlin, Mark
Mar 2, 2011 at 2:28 pm
Mar 2, 2011 at 4:02 pm -
Hi all, Recently, i have met a problem, and i can not solve it after some efforts. So I wanna look for help here, and any help will be appreciated. Thanks! My case is depicted as below: I want to ...
Jianhua Wang
Mar 1, 2011 at 2:18 am
Mar 1, 2011 at 2:55 am -
Hi, I'm trying to compare adding files to hdfs for Hive usage using Hive inserts vs. adding to the hdfs directly then using Hive. Any comments, blogging about this? Thanks a lot, David Zonsheine
David Zonsheine
Mar 30, 2011 at 1:31 pm
Mar 30, 2011 at 7:07 pm -
I haven't found a good description on this setting and the costs in setting it too high. Hope somebody can explain. I have about a year's worth of data partitioned by date. Using 10 nodes and setting ...
Igor Tatarinov
Mar 30, 2011 at 5:39 pm
Mar 30, 2011 at 6:23 pm -
Hi, We are looking at the NNN TB HBase cluster (owned by a client) and are considering HBase-Hive integration. Before we go there, we are wondering if this integration is successfully used by anyone ...
Otis Gospodnetic
Mar 29, 2011 at 3:03 am
Mar 30, 2011 at 5:17 pm -
hey guys, I want to extract some information from an apache web log. It does more than just extracting fixed fields that appear at certain location such as host and request. One task is to extract ...
Michael Jiang
Mar 30, 2011 at 12:36 am
Mar 30, 2011 at 12:50 am -
My desire is to be able to run a query on the existing RDBMS (SQLServer) to de-normalise the required data into single rows that can then be imported into a hive table partitioned by date. ...
Ryan Greenhall
Mar 23, 2011 at 10:30 am
Mar 27, 2011 at 10:30 am -
Hi, Can anyone comment on the state of Hive's JDBC and Web interfaces? Are they still being developed and relied upon? I'm mainly asking because I noticed their Wiki pages have not been updated since ...
Otis Gospodnetic
Mar 24, 2011 at 9:55 pm
Mar 25, 2011 at 1:45 am -
Hi! I'm trying to set up a test environment locally on my laptop and it works if I use the standard embedded derby driver. As soon as I add a hive-site.xml, I tried both MySQL and Derby with servers ...
Anja Gruenheid
Mar 20, 2011 at 7:17 pm
Mar 21, 2011 at 4:25 pm -
Hi, I am trying to use this: add jar ../build/contrib/hive_contrib.jar; CREATE TABLE apachelog ( host STRING, identity STRING, user STRING, time STRING, request STRING, status STRING, size STRING, ...
Bichonfrise74
Mar 18, 2011 at 10:40 pm
Mar 19, 2011 at 12:20 am -
I understand that Hive and Hadoop are meant to run many jobs at once. As a result, most tuning parameters are meant to increase the throughput of a Hadoop cluster rather than latency. In our case, we ...
Igor Tatarinov
Mar 9, 2011 at 7:51 pm
Mar 14, 2011 at 9:26 pm -
I know hive mestore use DBCP to connection mysql, I want to use short connection to connection mysql, how can I close DBCP configuration? Thanks, LiuLei**
Lei liu
Mar 14, 2011 at 2:44 am
Mar 14, 2011 at 2:56 am -
We're upgrading our Hadoop cluster (including Hive) to CDH3B4 on our dev cluster. After doing so, we see some concerning WARN logs, when connecting via the embedded hive JDBC connector. It doesn't ...
Andrew Harrison
Mar 10, 2011 at 8:52 pm
Mar 10, 2011 at 8:59 pm -
Hi, I am a hive newbie.I am managing a setup where data is regularly fed into HDFS using flume.However, hive does not show the data that is recently added to the HDFS.It used to earlier,but somehow ...
Abhishek pathak
Mar 10, 2011 at 11:35 am
Mar 10, 2011 at 12:46 pm -
Hey guys, I'm thinking about writing a native Ruby client that can be used to connect to a running Hive server and issue queries and get back results. I know that there's a native JDBC API. Could ...
Ryan LeCompte
Mar 7, 2011 at 6:25 pm
Mar 7, 2011 at 7:03 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 77 |
posts | 265 |
users | 84 |
website | hive.apache.org |
84 users for March 2011
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)