FAQ

Search Discussions

89 discussions - 318 posts

  • Respected Sir/Madam,
    Sagar nikamSagar nikam
    Oct 27, 2012 at 9:44 am
    Oct 29, 2012 at 1:23 pm
  • Hi, When I run the query "select count(1) from pokes;" it fails with the message as below. hive select count(1) from pokes; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks ...
    Ajit Kumar ShreevastavaAjit Kumar Shreevastava
    Oct 8, 2012 at 10:44 am
    Oct 10, 2012 at 8:44 am
  • I've tried different attempts to get Hive running (Riptano GitHub and the SVN trunk) but nothing seems to work. The ql module seems to be the issue. I've noticed many posts about replacing the antlr ...
    Anthony IkedaAnthony Ikeda
    Oct 2, 2012 at 5:23 pm
    Oct 2, 2012 at 8:35 pm
  • All, Am trying to setup Hive over Hadoop. Things I have done are a.) Install CYGWIN b.) Install Hadoop. c.) Configure Hive over Hadoop. After that, when I run CYGWIN, and type in hive, I get the CLI ...
    BALAKRISHNAN VISWANATHANBALAKRISHNAN VISWANATHAN
    Oct 29, 2012 at 12:53 pm
    Oct 29, 2012 at 5:56 pm
  • Hello all, I'm trying to install Hive on a four-node Hadoop cluster and am a bit confused by the instructions in the wiki. Am I to install Hive on one node or client and have it point to the ...
    Artem ErvitsArtem Ervits
    Oct 19, 2012 at 9:23 pm
    Oct 24, 2012 at 9:42 pm
  • Hi, I am firing some hive queries joining tables containing upto 30millions records each. Since the load on the reducers is very significant in these cases, i specifically set the following ...
    Saurabh MishraSaurabh Mishra
    Oct 15, 2012 at 12:10 pm
    Oct 18, 2012 at 9:04 am
  • I'm trying to compute the number of active users in the previous 30 days for each day over a date range. I can't think of any way to do it directly within Hive so I'm wondering if you guys have any ...
    Tom HubinaTom Hubina
    Oct 10, 2012 at 10:05 pm
    Oct 12, 2012 at 8:43 pm
  • I am running a Hive query and I am getting this exception below- *Job Submission failed with exception 'org.apache.hadoop.ipc.RemoteException(java.io.IOException: java.io.IOException: The number of ...
    Raihan JamalRaihan Jamal
    Oct 3, 2012 at 6:05 pm
    Oct 4, 2012 at 3:24 am
  • Hi there, Since today our Hive jobs suddenly fail (nothing changed actually). The end looks like this: *MapReduce Total cumulative CPU time: 38 minutes 31 seconds 260 msec* *Ended Job = ...
    Robin VerlangenRobin Verlangen
    Oct 29, 2012 at 12:38 pm
    Oct 30, 2012 at 9:49 am
  • (Follow up to the thread below...) I have a complex Hive table -- many fields, many nested structs. Hive fails to create the table at all. I can't even start to load data or query the data. Anyone ...
    Connell, ChuckConnell, Chuck
    Oct 8, 2012 at 8:37 pm
    Oct 15, 2012 at 4:47 pm
  • Hello, I use hive-0.9.0 with hadoop-0.20.2 and hbase -0.92.1. I have created external table, mapping it to an existing table in hbase. When I do "select * from myextrenaltable" it returns no results, ...
    AlxsssAlxsss
    Oct 4, 2012 at 6:30 pm
    Oct 5, 2012 at 11:09 pm
  • Hi, We have a requirement where we need to print the column headers in the generated file on executing a query. We are using Jdbc hive client to execute the query. Regards, Venugopal ...
    Venugopal KrishnanVenugopal Krishnan
    Oct 23, 2012 at 5:57 am
    Oct 23, 2012 at 6:55 am
  • hi all: some one said hive support sql like select if(1=2,100,200) from dual; however i always get Table not found 'dual' . my hive is 0.9.0 and what is the reason? fellowtree
    FellowtreeFellowtree
    Oct 18, 2012 at 6:24 am
    Oct 18, 2012 at 4:38 pm
  • All, So, I have an external table in hive backed by a huge hbase table. I was wondering what are the best practices to partition my data so that my queries do not have to do a full-table scan always? ...
    Kulkarni SwarnimKulkarni Swarnim
    Oct 15, 2012 at 4:39 pm
    Oct 18, 2012 at 4:56 am
  • We have a maybe obvious question about a serde. When a serde in invoked, does it have access to the original hive query? Ideally the original query could provide the Serde some hints on how to access ...
    John OmernikJohn Omernik
    Oct 16, 2012 at 3:30 pm
    Oct 16, 2012 at 4:30 pm
  • Hi all, If we run this query insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from NYSE_LOCAL; { ( describe NYSE_LOCAL ; exchange string symbol string ddate string open float ...
    Yogesh dhariYogesh dhari
    Oct 11, 2012 at 5:49 pm
    Oct 12, 2012 at 1:03 pm
  • Hi All, The result for the below query is 194965.0 0.0 , but 194965 is the result of inner query from count(q1.response). It looks like the outer query [select avg(q2.auth_count), ...
    Manu AManu A
    Oct 10, 2012 at 6:20 am
    Oct 30, 2012 at 1:58 pm
  • Hi, I'm very much a Hive newbie but I've been looking at HIVE-417 and this page in particular: http://cwiki.apache.org/confluence/display/Hive/IndexDev Using this information I've been able to create ...
    Peter MarronPeter Marron
    Oct 23, 2012 at 12:45 pm
    Oct 24, 2012 at 12:27 pm
  • Hi, I have one name node machine and under which there are 4 slaves machines to run the job. The way users run queries is - They ssh into the name node machine - They initiate hive and submit their ...
    Chunky GuptaChunky Gupta
    Oct 22, 2012 at 11:58 am
    Oct 22, 2012 at 3:11 pm
  • If I run a select command on the command line with -e it works. If I run the same command inside hive (without -e) it still works...but if I exec it with a -e from php (so obviously the apache user), ...
    Keith WileyKeith Wiley
    Oct 18, 2012 at 8:46 pm
    Oct 19, 2012 at 2:17 pm
  • Greetings all, I am trying to incorporate a TRANSFORM into a view (so we can abstract the transform script away from the user) As a Test, I have a table partitioned on day (in YYYY-MM-DD formated) ...
    John OmernikJohn Omernik
    Oct 10, 2012 at 7:05 pm
    Oct 11, 2012 at 7:05 pm
  • Hi, I want to create a table with a custom InputFormat. For example, something like this: CREATE TABLE xxx (blah string) STORED AS INPUTFORMAT 'org.foo.MyInputFormat' OUTPUTFORMAT ...
    Josh SpiegelJosh Spiegel
    Oct 11, 2012 at 2:22 am
    Oct 11, 2012 at 3:43 am
  • Hi All, I am using oracle as a remote metastore for hive. Whenever I fired insert or select command on this its run successfully. But when I want to run select count(1) from pokes; it fails ...
    Ajit Kumar ShreevastavaAjit Kumar Shreevastava
    Oct 3, 2012 at 7:33 am
    Oct 4, 2012 at 6:38 am
  • Quick question about using hive to create new hdfs file paths. Generally speaking, we like to keep our data files with a path similar to Dataset/year/month/day/hour I need to create a new table in ...
    Carla StaebenCarla Staeben
    Oct 2, 2012 at 10:55 am
    Oct 2, 2012 at 1:18 pm
  • I have a Hadoop cluster running CDH4 version. I am having issues giving privileges to users on hive. My requirement is for each linux user I need to create a database on hive and give access to only ...
    Rahul SarmaRahul Sarma
    Oct 1, 2012 at 6:51 pm
    Oct 2, 2012 at 4:29 am
  • Hi, I am new to data warehousing in hadoop. This might be a trivial question but I was unable to find any answers in the mailing list. My questions are: A person has an existing data warehouse that ...
    Austin ChungathAustin Chungath
    Oct 22, 2012 at 11:17 am
    Oct 22, 2012 at 6:02 pm
  • We are using Hive 8 as part of CDH4.0.1. We noticed a bug in Partition. Say if my hive table is partitioned by mydate and to drop a partition I mistype the name of the partition, like, Alter table ...
    Chalcy RajaChalcy Raja
    Oct 12, 2012 at 8:34 pm
    Oct 20, 2012 at 2:42 pm
  • i find that UDF can only process one argument like public long evaluate(String ip) { } can i define a udf like COALESCE(T v1, T v2, …) or if(boolean testCondition, T valueTrue, T valueFalseOrNull)? ...
    Chris GongChris Gong
    Oct 19, 2012 at 3:36 am
    Oct 19, 2012 at 2:01 pm
  • Hi, I was trying to do "arc diff --update ..." under Ubuntu and got this error: PHP Fatal error: Class 'ArcanistDifferentialRevisionRef' not found in ...
    Feng LuFeng Lu
    Oct 4, 2012 at 3:05 am
    Oct 4, 2012 at 8:51 pm
  • I am trying to create a large Hive table, with many columns and deeply nested structs. It is failing with java.lang.ArrayIndexOutOfBoundsException: 10. Before I spend a lot of time debugging my table ...
    Connell, ChuckConnell, Chuck
    Oct 4, 2012 at 3:48 pm
    Oct 4, 2012 at 8:31 pm
  • Hi, I am trying to run the hive udf percentile, I am trying to run it on a column with something around 116 million unique values. The maximum space that I can give to the reducer is 12 GB, the job ...
    Mayank BansalMayank Bansal
    Oct 1, 2012 at 8:51 am
    Oct 3, 2012 at 9:04 am
  • I have millions of gzip files in hdfs (with the same fields), would like to load them into one table in hive with a specified schema. What is the most efficient ways to do that? Given that my data is ...
    Zuohua zhangZuohua zhang
    Oct 2, 2012 at 7:53 pm
    Oct 2, 2012 at 11:31 pm
  • Dear all, I am running following query and I m not getting any output. But select * from pokes is working fine. [hadoop@NHCLT-PC44-2 bin]$ hive Logging initialized using configuration in ...
    Ajit Kumar ShreevastavaAjit Kumar Shreevastava
    Oct 1, 2012 at 11:00 am
    Oct 1, 2012 at 11:08 am
  • Hi, I am trying to enable fair scheduler on my emr cluster at bootstrap. The steps I am doing are : 1. Creating Job instance from AWS console as "Create New Job Flow" with Job Type as Hive program ...
    Chunky GuptaChunky Gupta
    Oct 29, 2012 at 1:07 pm
    Oct 30, 2012 at 6:41 am
  • hive show databases; OK default mm mm2 xyz Time taken: 6.058 seconds hive use mm2; OK Time taken: 0.039 seconds hive show tables; OK cidade concessionaria familia modelo venda Time taken: 0.354 ...
    Sagar nikamSagar nikam
    Oct 29, 2012 at 5:32 am
    Oct 29, 2012 at 6:21 am
  • Folks, I have been using Hive with no issues until now with lzo and gz files backing Hive tables. Compressed files are stored in Amazon S3 and I am using EMR to process my data. However I am having ...
    Binesh GummadiBinesh Gummadi
    Oct 24, 2012 at 10:20 pm
    Oct 25, 2012 at 6:05 pm
  • I have searched online but could not find a comprehensive introduction on how Hive organize logs and naming convention. By that, I mean hive client specifically, not hadoop logs. I have seen various ...
    Chen SongChen Song
    Oct 24, 2012 at 7:45 pm
    Oct 25, 2012 at 2:27 pm
  • Hi , I have 2 questions regarding the parameter 'hive.exec.parallel' in hive-site.xml in ~/.versions/hive-0.8.1/conf/ 1. how do I verify from query log files or from any other way, that a particular ...
    Chunky GuptaChunky Gupta
    Oct 25, 2012 at 11:15 am
    Oct 25, 2012 at 12:43 pm
  • Hello everyone, Is there a way to set a table property to read only? I am using hive 0.8.1 Thanks,G
    Babe RuthBabe Ruth
    Oct 25, 2012 at 2:50 am
    Oct 25, 2012 at 6:31 am
  • Hi all, I have a hive table with 235 million records. SAMPLE INPUT: receive_year receive_day receive_hour client 2012 7 17 xyz 2012 7 02 xyz 2012 7 17 btn 2012 7 04 snm 2012 7 05 btn 2012 7 02 snm ...
    Dyuti aDyuti a
    Oct 22, 2012 at 8:41 am
    Oct 22, 2012 at 12:20 pm
  • Hi there, We're suffering consistent problems with creating extract out of Tableau from Hive. We keep getting errors that state "Index column out of bounds". I'm pretty sure it has nothing to do with ...
    Robin VerlangenRobin Verlangen
    Oct 12, 2012 at 11:39 am
    Oct 19, 2012 at 6:01 am
  • Hi all, I have this file. I want this operation to perform in HIVE & PIG NAME DATE URL HITCOUNT timesascent.in 2008-08-27 http://timesascent.in/index.aspx?page=tparchives 15 timesascent.in 2008-08-27 ...
    Yogesh dhariYogesh dhari
    Oct 14, 2012 at 2:54 pm
    Oct 14, 2012 at 5:52 pm
  • Hi everybody, I am using Hive-0.9.0 and Hadoop-0.20.2. I have two customizes SerDe : custoSerde1.jar and custoSerde2.jar adding with ~/.hiverc . In HDFS I have : /input/data_for_custoSerde1/ ...
    Germain TanguyGermain Tanguy
    Oct 12, 2012 at 11:26 pm
    Oct 13, 2012 at 12:56 am
  • Great works! Ant I've heard our team will translate your book into Korean. Let's sell it a lot. ^^ Regards, Navis 2012/10/1 Aniket Mokashi <<span class="m_body_email_addr" ...
    Navis류승우Navis류승우
    Oct 10, 2012 at 9:07 am
    Oct 11, 2012 at 11:53 am
  • I wanted to look into improving performance of my Hive cluster, and from what I read turning on compression of intermediate data could help. As I understand, this would help because it would reduce ...
    Hadi MoshayediHadi Moshayedi
    Oct 6, 2012 at 1:56 pm
    Oct 8, 2012 at 3:18 pm
  • Hi While using Map reduce programs, the output folder where reducer writes out the result contains 2 auto-generated folders: _SUCCESS and _logs. To avoid generation of _log folder, I can set the ...
    Balaraman, AnandBalaraman, Anand
    Oct 5, 2012 at 6:07 am
    Oct 5, 2012 at 10:04 am
  • Hi, Could anybody explain me what ROW__OFFSET__INSIDE__BLOCK means? For example, I make the following query, and return two rows. But why does the column of ROW__OFFSET__INSIDE__BLOCK show 0? For my ...
    AfancyAfancy
    Oct 3, 2012 at 8:21 am
    Oct 4, 2012 at 12:36 am
  • Hi, I'm very new to Hive and I need to approach how to fire Hive sql queries via the RESTEasy framework and to stream back the query result as a JSON string to the client. I wonder, if there is any ...
    Zebeljan, NebojsaZebeljan, Nebojsa
    Oct 2, 2012 at 3:25 pm
    Oct 3, 2012 at 4:28 am
  • Could someone help me understand what alternative do I have for this query? I am trying to check if a given row exists in the table. select ...
    Mohit AnchliaMohit Anchlia
    Oct 1, 2012 at 8:43 pm
    Oct 1, 2012 at 10:59 pm
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions89
posts318
users101
websitehive.apache.org

101 users for October 2012

Bejoy KS: 14 posts Ajit Kumar Shreevastava: 13 posts Connell, Chuck: 13 posts Edward Capriolo: 11 posts John Omernik: 11 posts MiaoMiao: 11 posts Nitin Pawar: 11 posts Sagar nikam: 11 posts Yogesh dhari: 10 posts Robin Verlangen: 8 posts Yogesh Kumar13: 7 posts Raihan Jamal: 7 posts Anthony Ikeda: 6 posts Artem Ervits: 6 posts Chen Song: 6 posts Chunky Gupta: 6 posts Kulkarni Swarnim: 6 posts Saurabh Mishra: 6 posts Shreepadma Venugopalan: 6 posts Sadananda Hegde: 5 posts
show more
Archives