Grokbase › Groups › Hive › user › March 2011
FAQ

Hive > user > March 2011

Search Discussions

77 discussions - 265 posts

  • 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 ...
    SharedShared
    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, PatChristopher, 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 n00bHadoop 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 pathakAbhishek 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 KaimalBiju 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 TatarinovIgor 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 JiangMichael 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, SteveSeverance, 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 GruenheidAnja 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 KsBejoy 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 JiangMichael 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 jaiswalAmit 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 MohammedIrfan 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, MarkSunderlin, 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 DoulbergGuy 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 KsBejoy 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 FodAjo 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 DoulbergGuy 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 KumarV.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 RathboneMatthew 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 SharmaAbhijit 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 n00bHadoop 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 SchutBennie Schut
    Mar 9, 2011 at 9:40 am
    Mar 29, 2011 at 8:31 am
  • Tim KaldeweyTim 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 JiangMichael 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 ThomasJean-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 MikamiShunsuke 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 GruenheidAnja 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, AustinSwinney, 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 RobertsonTim 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 KsBejoy 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, MarkSunderlin, 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 WangJianhua 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 ZonsheineDavid 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 TatarinovIgor 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 GospodneticOtis 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 JiangMichael 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 GreenhallRyan 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 GospodneticOtis 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 GruenheidAnja 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, ...
    Bichonfrise74Bichonfrise74
    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 TatarinovIgor 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 liuLei 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 HarrisonAndrew 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 pathakAbhishek 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 LeCompteRyan LeCompte
    Mar 7, 2011 at 6:25 pm
    Mar 7, 2011 at 7:03 pm
Mar 2011
12
Group Navigation
period‹ prev | Mar 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions77
posts265
users84
websitehive.apache.org

84 users for March 2011

Edward Capriolo: 27 posts Michael Jiang: 15 posts Ajo Fod: 9 posts Anja Gruenheid: 8 posts Bejoy Ks: 8 posts Christopher, Pat: 8 posts 徐厚道: 8 posts Abhishek pathak: 7 posts Aurora Skarra-Gallagher: 7 posts Bennie Schut: 7 posts Shared: 7 posts Yongqiang he: 7 posts Igor Tatarinov: 6 posts Otis Gospodnetic: 5 posts 幻: 5 posts Carl Steinbach: 4 posts Chinna: 4 posts Guy Doulberg: 4 posts Hadoop n00b: 4 posts John Sichi: 4 posts
show more
Archives