FAQ

Search Discussions

80 discussions - 265 posts

  • I am running a basic join of 2 tables and it will only run with 1 reducer. why is that? i tried to set the number of reducers and it didn't work. hive just ignored it. create table z as select x.* ...
    Koert KuipersKoert Kuipers
    Jan 12, 2012 at 10:53 pm
    Jan 13, 2012 at 2:29 am
  • Hi guys, We are using hive for a while now, and recently we have encountered an issue we just can't understand, We are selecting(the select includes count(*)) over a join of two big tables. We ran ...
    Guy DoulbergGuy Doulberg
    Jan 9, 2012 at 5:03 pm
    Jan 10, 2012 at 3:45 pm
  • Hello, Using version .8 of Hive with version 0.20.203.0 of Hadoop. Defining and loading tables worked fine, and I can query them with select *. However, a summary query against any table results in ...
    Ian MeyersIan Meyers
    Jan 6, 2012 at 3:55 pm
    Jan 10, 2012 at 10:37 am
  • Hello, everyone, I'm new to hive, and I got some questions. I have a table like this: create table t(id int, time string, ip string, u bigint, ret int, plat int, type int, u2 bigint, ver int) ...
    Xiaobin SheXiaobin She
    Jan 12, 2012 at 1:16 pm
    Jan 15, 2012 at 7:38 am
  • Hi folks, i have few question like 1:- How to format output from reduce( like default is tab separator can we make it "," separator) 2:- and how to make output in different directories according to ...
    vikas Srivastavavikas Srivastava
    Jan 9, 2012 at 12:02 pm
    Jan 10, 2012 at 7:29 am
  • Dear all, I am developing an API for medical use i.e Hospital admissions and all about patients, thus transactions and queries and realtime data is important here... Therefore both real-time and ...
    Dalia SobhyDalia Sobhy
    Jan 25, 2012 at 3:01 pm
    Feb 2, 2012 at 1:42 pm
  • Hey folks, Is this possible to moves table into different hive database?? regards Vikas Srivastava
    Hadoop hiveHadoop hive
    Jan 30, 2012 at 2:35 pm
    Jan 31, 2012 at 7:01 am
  • Hi, I am trying to run a query like "select mean(count(a)) from table1 group by b;" I am getting the following error <snip FAILED: Hive Internal Error: java.lang.NullPointerException(null) ...
    Rohan mongaRohan monga
    Jan 20, 2012 at 8:28 pm
    Feb 1, 2012 at 8:29 pm
  • 1. I create two Hive table: Hive CREATE EXTERNAL TABLE student_details (studentid INT,studentname STRING,age INT,gpa FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION ...
    Bing LiBing Li
    Jan 16, 2012 at 10:06 am
    Jan 16, 2012 at 4:40 pm
  • Hi, I have two tables with 8 buckets each on the same key and want to join them. I ran "explain extended" and get the plan produced by HIVE which shows that a map-side join is a possible plan. I then ...
    Avrilia FloratouAvrilia Floratou
    Jan 19, 2012 at 3:54 pm
    Mar 27, 2012 at 12:54 am
  • I have a similar UDF to this one which create's just fine. I cam seem to resolve what 'return code -101' means however with this one. Can anyone tell me what 'return code -101' means? My ...
    Tim HavensTim Havens
    Jan 22, 2012 at 5:26 pm
    Jan 23, 2012 at 1:37 am
  • Hello, I am using Hive-0.7.1. I want to append the data in table. Is hive-0.7.1 support appending feature or just support OVERWRITE feature? When I tried for the appending, the query is not working. ...
    Bhavesh ShahBhavesh Shah
    Jan 18, 2012 at 5:01 am
    Jan 18, 2012 at 9:25 am
  • Hi, We are running Hive server and connecting to it through Toad. Everything works fine. Now we want to enable authentication on the hive server. The hive server indicates that we can specify user id ...
    Shantian PurkadShantian Purkad
    Jan 31, 2012 at 6:20 pm
    Feb 1, 2012 at 5:09 pm
  • Hey guys, we found an issue that looks like a bug (hive 0.8 , caldera's distribution). SELECT count(1) FROM table1 a LEFT OUTER JOIN table2 b ON ( a.key1 = b.key1 AND a.key2 = b.KEY2) fails with ...
    Roberto CongiuRoberto Congiu
    Jan 20, 2012 at 1:01 am
    Jan 20, 2012 at 6:29 pm
  • Dear all,I want to ask a couple of questions:Which is better use Hive or Hive/Hbase or Hbase?What about the RCFILe?Is there any tutorials for HiveThrift API using Java or even any examples bec I am ...
    Dalia SobhyDalia Sobhy
    Jan 18, 2012 at 11:51 pm
    Jan 19, 2012 at 9:58 am
  • Hey guys, I ran into a quite annoying issue. I have some jars in HIVE_AUX_JARS_PATH that include some serdes and UDF. They work fine from CLI, but when I run the same queries through hiveserver ...
    Roberto CongiuRoberto Congiu
    Jan 13, 2012 at 1:27 am
    Jan 13, 2012 at 1:37 am
  • Hello, I want to calculate count of quarter wise record in Hive. (e.g.: In 1st Quarter - 72 (counts) likewise for other quarter) How can we calculate it through query or UDF in Hive? -- Thanks and ...
    Bhavesh ShahBhavesh Shah
    Jan 10, 2012 at 6:07 am
    Jan 10, 2012 at 6:35 pm
  • Hi, I have following hive query (pseudo hive query code) select name, address, phone from t1 join t2 Executing above query will end up file stored in the format of name, address, phone format on the ...
    jingjung Ngjingjung Ng
    Jan 25, 2012 at 7:41 am
    Feb 1, 2012 at 3:54 pm
  • Dear all, I am struggling with a Hive query where I am trying to get the last value for a column. Let say I have a table T with three columns: user_id, time, colour and I want to know for each ...
    Mdefoinplatel ExtMdefoinplatel Ext
    Jan 26, 2012 at 11:24 am
    Jan 28, 2012 at 4:29 am
  • Do anyone have any idea about rainstor ??? Opensource? How to download ? How to use? PErformance ??
    Dalia SobhyDalia Sobhy
    Jan 26, 2012 at 12:35 am
    Jan 27, 2012 at 9:42 am
  • Hi I have a problem in create a Hive table using existing HBase table (using External Table concept) with multiple columns from column family (not using as Map) Case-1 : I have created a table in ...
    Madhusudhana Rao PodilaMadhusudhana Rao Podila
    Jan 27, 2012 at 5:38 am
    Jan 27, 2012 at 8:46 am
  • Hi, I would like to get write access to the Hive wiki, so that I can add documentation on existing UDFs. Thanks Matt Tucker Associate eBusiness Analyst Walt Disney Parks and Resorts Online Ph: ...
    Tucker, MattTucker, Matt
    Jan 24, 2012 at 3:11 pm
    Jan 26, 2012 at 2:12 am
  • It seems to be there: https://cwiki.apache.org/confluence/display/Hive/User+FAQ But.... humm......how should I phrase it..... shouldn't questions be followed by answers ? :D Nicolas
    Nicolas LalevéeNicolas Lalevée
    Jan 24, 2012 at 4:50 pm
    Jan 26, 2012 at 2:10 am
  • HI Folks, i got a problem in my job tracker Url, its not Showing the actual no of DN present in Cluster. any suggestion wats wrong with this, regards Vikas Srivastava
    Hadoop hiveHadoop hive
    Jan 24, 2012 at 6:56 am
    Jan 24, 2012 at 10:08 am
  • I am attempting to Use LazyBinarySerDe to read Sequence files output by a mapreduce job. Is there an example of how the data needs to be packed by the final reduce, and how the tables are set up so ...
    Hans UhligHans Uhlig
    Jan 22, 2012 at 6:23 pm
    Jan 23, 2012 at 5:28 am
  • hey all, I have a cluster of 13 nodes, in which i configured map =16 and reduce=10 , and mapred.reduce.tasks=120 , replication factor=2 but still i wont be able to utilize map and reduce as shown in ...
    Hadoop hiveHadoop hive
    Jan 12, 2012 at 6:48 am
    Jan 12, 2012 at 4:06 pm
  • Hi All, How can i get a version of Hive that runs on Hadoop 1.0.0 ? Tried looking around for a nightly build release but doesnt seem to be one. Running 0.8 on top of 1.0 complains about null classes ...
    Graeme WallaceGraeme Wallace
    Jan 10, 2012 at 8:34 pm
    Jan 12, 2012 at 1:42 am
  • Hi folks, I am using elastic-mapreduce in the Amazon EC2 eco-system and would like to upgrade from Hive 0.5 on Hadoop 0.20 to Hive 0.7.1 on Hadoop 0.20.205. I created a new metastore (on S3) to ...
    Matt VonkipMatt Vonkip
    Jan 4, 2012 at 11:07 pm
    Jan 5, 2012 at 7:31 pm
  • Hi there, i have a string that has '239, 236, 232, 934' (not always in that order) and want to insert into another table if 239 is in the string. INSERT OVERWRITE TABLE video_plays_for_sept SELECT ...
    Dave HoustonDave Houston
    Jan 4, 2012 at 1:12 pm
    Jan 4, 2012 at 2:06 pm
  • I'm attempting to change the default location where hive stores its history files. I modified the hive.log.dir property in the hive-exec-log4j.properties and hive-log4j.properties files. However, ...
    Black, BrentBlack, Brent
    Jan 26, 2012 at 11:41 pm
    Jan 27, 2012 at 5:43 pm
  • I keep making the same mistake of creating an external table without saying "EXTERNAL". As a result, as you can imagine, I am stuck with a table that I cannot drop or I'll lose the external (S3) ...
    Igor TatarinovIgor Tatarinov
    Jan 24, 2012 at 11:55 pm
    Jan 25, 2012 at 12:57 am
  • I have configured hive to use MySQL. This all seems to work fine, but occasionally derby.log files and TempStatsStore directories get created as if I was using the default derby database. Is this an ...
    Mark Schramm \(tetrascend\)Mark Schramm \(tetrascend\)
    Jan 24, 2012 at 6:59 pm
    Jan 24, 2012 at 10:44 pm
  • I wrote, separately, a Hadoop job to calculate running averages of about 2000 stock tickers over a 180 day period as well as a Hive script which performs equivalent functionality. I have been using ...
    Benjamin PoserowBenjamin Poserow
    Jan 24, 2012 at 2:49 am
    Jan 24, 2012 at 5:49 pm
  • Hi - I'm from relational background where there is capability of, 1. Creating various schema - to logically group related entities 2. Creating various users with privileges - to have better control ...
    Ronak BhattRonak Bhatt
    Jan 20, 2012 at 9:00 pm
    Jan 20, 2012 at 11:02 pm
  • My Steps: I define a class "public class myInputFormat extends TextInputFormat implements JobConfigurable" to specify input format. hive add jar /home/biadmin/hiveudf/myFileFormat.jar; Added ...
    Bing LiBing Li
    Jan 17, 2012 at 11:40 am
    Jan 17, 2012 at 4:50 pm
  • Hello, I am using hive LOAD DATA command. I am writing some content in one text file and loading that content into table every time when I write that file. But when I use LOAD DATA command: "load ...
    Bhavesh ShahBhavesh Shah
    Jan 17, 2012 at 5:25 am
    Jan 17, 2012 at 5:43 am
  • Hi guys, trying to calculate the dwell time of pages in a weblog. In oracle we would used the lead analytic function to find the next row for a particular cookie. What is the best approach for Hive? ...
    Dave HoustonDave Houston
    Jan 11, 2012 at 2:54 pm
    Jan 11, 2012 at 7:50 pm
  • Hello, I want to run hive queries through a .hql file in command prompt where i need to pass start_date,end_date & table_name as command line parameter How can I achieve this? Please help -- Regards, ...
    Praveen KumarPraveen Kumar
    Jan 11, 2012 at 9:46 am
    Jan 11, 2012 at 3:17 pm
  • Is there an easy/elegant way to query hive for a table's (and a partition's) location in HDFS? I'm aware that you can get the location using "describe extended table_name" but it like to be able to ...
    Chris KudelkaChris Kudelka
    Jan 10, 2012 at 5:25 am
    Jan 10, 2012 at 7:22 am
  • Looks like asf jira is down. Is this a scheduled downtime? Where should I subscribe to get updates about it? https://issues.apache.org/jira Thanks, Aniket
    Aniket MokashiAniket Mokashi
    Jan 3, 2012 at 12:04 am
    Jan 3, 2012 at 6:20 am
  • Hi all, I am trying to generate report using Jasper (Hive as datasource) but got the below error. Error filling print... Unable to get next record. Hive history ...
    Ankit JainAnkit Jain
    Jan 31, 2012 at 10:42 am
    Feb 7, 2012 at 5:46 am
  • I have a new Hive installation . Im able to create tables and do select * queries from them. But as soon as I try to execute a query that would involve a Hadoop M/R job, I get this exception . ...
    Sam WilliamSam William
    Jan 31, 2012 at 7:50 pm
    Feb 1, 2012 at 10:53 pm
  • hey folks, Any1 have idea about joining two tables of different databases in hive(0.7.0). regards Vikas Srivastava
    Hadoop hiveHadoop hive
    Jan 31, 2012 at 7:34 am
    Jan 31, 2012 at 4:28 pm
  • Does Hive support automated sequence Id generation, or does a "udf" have to be created per each object that is created?
    Anson AbrahamAnson Abraham
    Jan 27, 2012 at 4:38 pm
    Jan 28, 2012 at 3:36 am
  • I have some data generated from a Pig script which is LZO compressed. There is no indexer run on this data . I created an external table on hive on top of this data . Here is the create table script ...
    Sam WilliamSam William
    Jan 25, 2012 at 11:19 pm
    Jan 27, 2012 at 9:48 am
  • Hello All, I have a mapred job that does transfermation and outputs to a compresses SequenceFile (by using org.apache.hadoop.mapred.SequenceFileOutputFormat) I am able to attach the output to a ...
    Rk vishuRk vishu
    Jan 26, 2012 at 10:00 pm
    Jan 27, 2012 at 9:31 am
  • We've started noticing that some of the hive job logs (hive_job_log_mtucker_201201251355_374625982.txt) can become very big, some upwards of 800MB. I've tried modifying the Log4J settings to write to ...
    Tucker, MattTucker, Matt
    Jan 26, 2012 at 11:41 pm
    Jan 27, 2012 at 7:02 am
  • We are running this query: select name, sum_id from ( select name, players, array(player1, player2, player3, player4, player5, player6, player7, player8) arr from ( select name, ...
    Time LessTime Less
    Jan 19, 2012 at 9:27 pm
    Jan 26, 2012 at 9:23 pm
  • I'm running a bunch of hive queries (20+ and adding more) through Oozie and they are all in one file :-( Is there a way I can tell oozie to run them all simultaneously without writing a separate ...
    Appan ThirumaligaiAppan Thirumaligai
    Jan 23, 2012 at 12:23 am
    Jan 23, 2012 at 5:57 pm
  • Hiiii all,I know I have asked this question before.. But I want to state more specific...Whats the difference in performance between Hive, Hbase, Hive/Hbase Integration, Pig in case of transaction ...
    Dalia SobhyDalia Sobhy
    Jan 21, 2012 at 7:03 pm
    Jan 22, 2012 at 8:40 pm
Group Navigation
period‹ prev | Jan 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions80
posts265
users83
websitehive.apache.org

83 users for January 2012

Aniket Mokashi: 26 posts vikas Srivastava: 21 posts Bejoy Ks: 13 posts Edward Capriolo: 13 posts Bhavesh Shah: 12 posts Dalia Sobhy: 9 posts Alo.alt: 7 posts Ian Meyers: 6 posts Koert Kuipers: 6 posts Ankit Jain: 5 posts Carl Steinbach: 5 posts Guy Doulberg: 5 posts Mark Grover: 5 posts Sriram Krishnan: 5 posts Ameet chaubal: 4 posts Martin Kuhn: 4 posts Roberto Congiu: 4 posts Steven Wong: 4 posts Tucker, Matt: 4 posts Xiaobin She: 4 posts
show more
Archives