FAQ

Search Discussions

56 discussions - 231 posts

  • Hi Folks, I propose that we adopt the following bylaws for the Apache Hive Project https://cwiki.apache.org/HIVE/bylaws.html These are basically a cut-and-paste job of the Apache Pig bylaws that were ...
    Ashish ThusooAshish Thusoo
    Oct 22, 2010 at 9:51 pm
    Oct 28, 2010 at 1:31 am
  • Hi, Create table as select queries fail with org.apache.thrift.TApplicationException in our clusters for some queries. Following is the stack trace for the exception : Error in metadata: ...
    Amareshwari Sri RamadasuAmareshwari Sri Ramadasu
    Oct 1, 2010 at 4:26 am
    Oct 11, 2010 at 9:52 pm
  • Hi all, When i am running "select count(1) from searchlogs", I am getting following errors. While "select * from searchlogs" is working properly. ...
    Guru PrasadGuru Prasad
    Oct 11, 2010 at 8:11 am
    Oct 14, 2010 at 6:51 am
  • Hi, I need help with this scenario. We have a table of events which has columns date, event (not important for this discussion), and user_id. It is obviously easy to find number of unique users for ...
    VijayVijay
    Oct 15, 2010 at 6:36 am
    Oct 15, 2010 at 8:06 pm
  • Hi, more partitions than it needs to? For example, my query is something like: INSERT OVERWRITE TABLE daily_fact PARTITION (dt='2010-09-29') SELECT 20100929 as stamp, tagtype, country, ...
    Marc LimotteMarc Limotte
    Oct 1, 2010 at 9:11 pm
    Oct 8, 2010 at 8:40 pm
  • Hi, I'm getting the following error message after upgrading to CDH3b3. Does anyone know how to resolve this? Thanks -ray hive show tables; Exception in thread "main" java.lang.NoClassDefFoundError: ...
    Ray DuongRay Duong
    Oct 24, 2010 at 11:52 pm
    Oct 27, 2010 at 12:47 am
  • Hi, I have a dynamic partition query which generates quite a few small files which I would like to merge: SET hive.exec.dynamic.partition.mode=nonstrict; SET hive.exec.dynamic.partition=true; SET ...
    Sammy YuSammy Yu
    Oct 15, 2010 at 8:44 pm
    Nov 12, 2010 at 9:40 pm
  • This month our system will be released, so I want to use newest hive0.6 version, I want to know hive0.6 whether can be released in next week. Thanks, LiuLei
    Lei liuLei liu
    Oct 15, 2010 at 2:31 am
    Oct 15, 2010 at 6:30 am
  • Hi all, I installed Hadoop 0.20.2 and installed hive 0.5.0. I followed all the instructions on Hive's getting started page for setting up environment variables like HADOOP_HOME When I run from ...
    Hdev mlHdev ml
    Oct 13, 2010 at 9:18 pm
    Oct 14, 2010 at 6:15 am
  • Hi, We are planning to cut the first release candidate for Hive 0.6.0 on Friday. At this point all of the tickets that were marked as blockers for the the 0.6.0 release have been committed and ...
    Carl SteinbachCarl Steinbach
    Oct 7, 2010 at 5:12 am
    Oct 13, 2010 at 7:53 pm
  • Hi, insert overwrite directory "$dir" select * from xxx; creates files of type attempt_201008201925_165088_r_000000_0.gz insert overwrite table "$table" select * from xxx; creates file of type ...
    Gaurav jainGaurav jain
    Oct 6, 2010 at 3:44 am
    Oct 6, 2010 at 8:52 pm
  • Hi, I was wondering how I can query data stored in HBase and remembered Hive's HBase integration: http://wiki.apache.org/hadoop/Hive/HBaseIntegration After watching John Sichi's video ...
    Otis GospodneticOtis Gospodnetic
    Oct 13, 2010 at 8:08 pm
    Oct 13, 2010 at 11:08 pm
  • Hi, I ran a simple Hive query inserting data into a target table from a source table. The number of records loaded to the target table (say number A), which is returned by running this query, is ...
    Ping ZhuPing Zhu
    Oct 1, 2010 at 5:23 pm
    Oct 2, 2010 at 5:44 am
  • There is one table, I use one timer to create one new partition for the table every day, now I want to create one view, use the view to search the newest partition of the table,how can I receive the ...
    Lei liuLei liu
    Oct 21, 2010 at 1:29 am
    Oct 21, 2010 at 11:55 am
  • Hi all, I installed hadoop-0.21.0 and hive-0.5.0-bin and it is giving me following error when trying to run hive CLI Is there anything wrong that I am doing? [user@machine bin]$ ./hive Exception in ...
    Hdev mlHdev ml
    Oct 5, 2010 at 7:01 pm
    Oct 5, 2010 at 9:00 pm
  • I see that https://issues.apache.org/jira/browse/HIVE-675 is committed and Hive now has support for databases and related operations associated with it. But I am unable to find any user facing ...
    Ashutosh ChauhanAshutosh Chauhan
    Oct 28, 2010 at 5:56 pm
    Dec 11, 2010 at 4:20 am
  • Hi all, As all of us know that Hadoop considers the user who starts the hadoop cluster as superuser. It provides all access to HDFS to that user. But know I want to know that how we can R/W access to ...
    Adarsh SharmaAdarsh Sharma
    Oct 29, 2010 at 6:14 am
    Oct 29, 2010 at 7:15 am
  • I use JDBC to run "dfs -lsr hdfs://hdpnn:9000/group/hive/" command, but ResultSet don't return value, the code like below: Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); hiveConnection = ...
    Lei liuLei liu
    Oct 25, 2010 at 1:04 pm
    Oct 25, 2010 at 6:03 pm
  • I define one UDF function, like as below : public class TestUDF extends GenericUDF{ private ObjectInspector[] argumentOIs; @Override public Object evaluate(DeferredObject[] arguments) throws ...
    Lei liuLei liu
    Oct 19, 2010 at 8:41 am
    Oct 19, 2010 at 9:17 pm
  • Hi, I got some question after deploy hadoop-0.21.0 need to help. There is a new deploy not update, and i execute start-hdfs.sh, start-mapred.sh, got the message in the log file below: 2010-10-14 ...
    SingoWongSingoWong
    Oct 14, 2010 at 9:04 am
    Oct 18, 2010 at 6:22 am
  • Hi, I'd like to write a multiple-insert select statement where I need to call different UDTFs and perform several levels of aggregation based on the result of the initial table, e.g., FROM (SELECT * ...
    Alex BoisvertAlex Boisvert
    Oct 15, 2010 at 6:00 pm
    Oct 15, 2010 at 6:27 pm
  • Is there a way I can use the "in" list of values in a query condition like "select col1 from table1 where col1 in ('abc','xyz')"? I use Hive 0.6. Regards, Karthik.
    KarthikKarthik
    Oct 12, 2010 at 12:42 am
    Oct 12, 2010 at 5:37 pm
  • We use the following Hadoop stack distribution: HDFS - Cloudera 0.20.1+169.89 Hive - Cloudera 0.5.1 OS - RHEL 4 Hive server(Thrift server) has been started using: nohup hive --service hiveserver & We ...
    Regunath BalasubramanianRegunath Balasubramanian
    Oct 31, 2010 at 12:06 pm
    Nov 2, 2010 at 5:29 am
  • Hi, Are there any good scheduling tools out there suitable for the dependencies you may get in Hive? Specific example I have right now: - 2 tables with event logs from different sources - 1 table ...
    Terje MarthinussenTerje Marthinussen
    Oct 28, 2010 at 4:16 am
    Oct 28, 2010 at 4:35 am
  • All, Part of the move to TLP will require us moving our SVN. https://issues.apache.org/jira/browse/INFRA-3036 Infra is going to tackle item #2 soon. After creates the new svn, we need to do the svn ...
    Edward CaprioloEdward Capriolo
    Oct 7, 2010 at 5:45 pm
    Oct 27, 2010 at 12:05 am
  • If you have outstanding checkouts (including ones with changes) you can update them using svn switch: svn switch https://svn.apache.org/repos/asf/hive/trunk The above assumes you have trunk checked ...
    John SichiJohn Sichi
    Oct 26, 2010 at 8:47 pm
    Oct 26, 2010 at 9:20 pm
  • Hi, I need to get Hive working on a 0.21.0 Hadoop cluster. Can someone please let me know how it can be done. I tried HIVE-1612 but it did not work for me. Am I missing something? Thanks and Regards, ...
    Sonal GoyalSonal Goyal
    Oct 23, 2010 at 5:35 am
    Oct 26, 2010 at 5:10 am
  • I use the "nohup ./hive --service hiveserver 10000&" command to start hive server. But after some time, I find the hive server process is killed. I error message like below : 2010-10-25 19:00:05,030 ...
    Lei liuLei liu
    Oct 25, 2010 at 11:29 am
    Oct 25, 2010 at 6:08 pm
  • We are running into the issue reported in HIVE-1597 (Hive CLI returns MasterNotRunningException with HBase 0.89.x) when using Hive from trunk and HBase 0.89.20100830, StumbleUpon branch. Does anyone ...
    Leo AlekseyevLeo Alekseyev
    Oct 20, 2010 at 11:21 pm
    Oct 22, 2010 at 12:46 am
  • Hi, I have a table which is partitioned per hour. I wanted to get a list of partitions which are less than a certain time limit. The issue that I am facing is: the result of the query is ...
    Bakshi, AnkitaBakshi, Ankita
    Oct 20, 2010 at 5:34 pm
    Oct 20, 2010 at 11:53 pm
  • Hi all, I've done a lot of research about this today, but haven't found the solution. I'm importing a bunch of sequencefiles that were created from Map/Reduce jobs into Hive tables, but the keys ...
    Chris BatesChris Bates
    Oct 20, 2010 at 9:39 pm
    Oct 20, 2010 at 10:04 pm
  • What are the "AS" columns used for in TRANSFORM USING? All I can find is http://wiki.apache.org/hadoop/Hive/LanguageManual/Transform#Schema-less_Map-reduce_Scriptsbut that only mentions what happens ...
    Dave BrondsemaDave Brondsema
    Oct 13, 2010 at 10:02 pm
    Oct 13, 2010 at 10:23 pm
  • Hi, I want to use hive for real time query. Please anyone explain me how feasible it is? Also how many simultaneous queries can hive handle? Thanks & Regards Guru Prasad ~guru This message is ...
    Guru PrasadGuru Prasad
    Oct 11, 2010 at 8:03 am
    Oct 11, 2010 at 8:38 am
  • Please can someone help. Tried to set up pseudo-distributed mode for DFS. When I do start-dfs.sh I get the error message below, and am not sure what it means. Any help would be most appreciated. ...
    David LaryDavid Lary
    Oct 8, 2010 at 4:51 pm
    Oct 8, 2010 at 5:10 pm
  • We're trying to insert into a table, using a dynamic partition, but the query runs for a while and then dies with a LeaseExpiredException. The hadoop details & some discussion is at ...
    Dave BrondsemaDave Brondsema
    Oct 1, 2010 at 3:35 pm
    Oct 1, 2010 at 7:24 pm
  • http://wiki.apache.org/hadoop/Hive/Development/ContributorsMeetings/HiveContributorsMinutes101025 JVS
    John SichiJohn Sichi
    Oct 29, 2010 at 7:42 pm
    Oct 29, 2010 at 7:58 pm
  • It appears that if you have an array with the length of 1 and a null in it, it will just assume the column is null. I realize the specification for this is ambiguous because it would be stored the ...
    Mike LewisMike Lewis
    Oct 20, 2010 at 10:37 pm
    Oct 20, 2010 at 10:44 pm
  • Hi, When running any query except "show tables" I am getting following error: ----- FAILED: Unknown exception: Error while making MR scratch directory - check filesystem config (null) ----- I have ...
    Guru PrasadGuru Prasad
    Oct 19, 2010 at 8:27 am
    Oct 20, 2010 at 5:37 am
  • I'm trying to pass a FALSE value thru a custom transform script to another table, like so: FROM ( FROM downloads SELECT project, file, os, FALSE as folder, country, dt WHERE dt='2010-05-14' ...
    Luke CrouchLuke Crouch
    Oct 12, 2010 at 4:17 pm
    Oct 13, 2010 at 5:59 pm
  • Hi, I am using hive trunk with default setting along with cdh3b2. I encounter the following exception: Caused by: java.lang.IllegalArgumentException: Compression codec ...
    Ted YuTed Yu
    Oct 8, 2010 at 10:34 pm
    Oct 10, 2010 at 2:24 am
  • In oracle, select a.str1, b.str2 from ( select str1 from table1) a, ( select str2 from table2) b where instr(a.str1,a.str2) 0 I know that 'from a, b' is not supported in hive, but table1 and table2 ...
    Neil XuNeil Xu
    Oct 9, 2010 at 3:38 am
    Oct 9, 2010 at 10:31 am
  • Hi, I am running Select * from table fails . But reduce task fails giving error :- Ended Job = job_201010011018_0001 with errors FAILED: Execution Error, return code 2 from ...
    Vaibhav negiVaibhav negi
    Oct 1, 2010 at 10:38 am
    Oct 1, 2010 at 6:27 pm
  • I'm about to investigate the following situation, but I'd appreciate any insight that can be given. We have an external table which is comprised of 3 HDFS files. We then run an INSERT OVERWRITE which ...
    Phil youngPhil young
    Oct 29, 2010 at 11:20 pm
    Oct 29, 2010 at 11:20 pm
  • The Apache Hive team is proud to announce the release of Hive 0.6.0! Hive is a data warehouse system for Hadoop that facilitates easy summarization, ad-hoc querying, and analysis of large datasets ...
    Carl SteinbachCarl Steinbach
    Oct 29, 2010 at 2:44 pm
    Oct 29, 2010 at 2:44 pm
  • Hi, Using the latest hive 0.7 version to test parallel executions and dynamic partitions using the multiple insert. Below is the same pseudo code with actual error message. Is it possible to do in ...
    Ray DuongRay Duong
    Oct 25, 2010 at 12:10 am
    Oct 25, 2010 at 12:10 am
  • Up through release 0.5, Hive has been producing tarballs hive-x.y.z-bin.tar.gz (binaries only) hive-x.y.z-dev.tar.gz (binaries, source, and doc) The top-level tar directory structures match the ...
    John SichiJohn Sichi
    Oct 20, 2010 at 1:01 am
    Oct 20, 2010 at 1:01 am
  • Hi, I'm writing a UDAF and I'm a little unclear about the PARTIAL1, PARTIAL2, FINAL and COMPLETE modes. I've read the extent of the Javadoc ;) and looked at some of the built-in UDAFs in the Hive ...
    Alex BoisvertAlex Boisvert
    Oct 15, 2010 at 6:15 pm
    Oct 15, 2010 at 6:15 pm
  • Hello I have a small query and need little help on the same. I have a hive table which loads its data from files partitioned by timestamp (every 15 minutes) and placed there in gzipped format. There ...
    Parag AroraParag Arora
    Oct 15, 2010 at 11:16 am
    Oct 15, 2010 at 11:16 am
  • Hello Fellow Hadoopists, We are meeting at 7:15 pm on October 21st at the University Heights Community Center 5031 University Way NE Seattle WA 98105 Room #110 The meetings are informal and highly ...
    Sean jensen-greySean jensen-grey
    Oct 15, 2010 at 3:10 am
    Oct 15, 2010 at 3:10 am
  • I use JDBC to connection hive server, I find when I close connection, hive don't clean hive.exec.scratchdir directory, so after hive run long time, the hive.exec.scratchdir directory include a lot of ...
    Lei liuLei liu
    Oct 15, 2010 at 2:26 am
    Oct 15, 2010 at 2:26 am
Group Navigation
period‹ prev | Oct 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions56
posts231
users70
websitehive.apache.org

70 users for October 2010

Edward Capriolo: 17 posts Carl Steinbach: 14 posts Ning Zhang: 12 posts John Sichi: 11 posts Lei liu: 11 posts Steven Wong: 8 posts Alex Boisvert: 7 posts Gaurav jain: 7 posts Guru Prasad: 6 posts Narendra: 6 posts Ray Duong: 6 posts Vijay: 6 posts Ashish Thusoo: 5 posts Marc Limotte: 5 posts Otis Gospodnetic: 5 posts Shrijeet Paliwal: 5 posts S. Venkatesh: 5 posts Dave Brondsema: 4 posts David Lary: 4 posts Hdev ml: 4 posts
show more
Archives