FAQ

Search Discussions

41 discussions - 137 posts

  • Hello, Just wanted to let people know I tracked this one down: It looks like it was not picking up the *hadoop* core-site.xml configuration file. - So the variable fs.default.name was never set - So ...
    Stuart SmithStuart Smith
    Nov 20, 2010 at 12:57 am
    Nov 23, 2010 at 7:24 pm
  • Hi, I'm taking another pass over the Hypertable Hive storage handler and adding a bit more functionality to it (including regexp filtering). I was also planning to upgrade the Hive version it uses ...
    Sanjit JhalaSanjit Jhala
    Nov 4, 2010 at 5:30 pm
    Nov 8, 2010 at 9:51 pm
  • Hi, Currently I am facing an issue with Hive/HBase integration. Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.util.Shell.getGROUPS_COMMAND()[Ljava/lang/String; StackTrace: ...
    Vivek MishraVivek Mishra
    Nov 18, 2010 at 5:56 am
    Nov 24, 2010 at 8:02 am
  • Hi, Does anybody know how to generate a unique ID in Hive? I have a table: hive describe results; OK id int test string Time taken: 0.091 seconds When I insert data into the table results, i want to ...
    AfancyAfancy
    Nov 15, 2010 at 9:09 am
    Nov 17, 2010 at 3:35 pm
  • Dear all, I would like to add jar to Hive in one session, and make this jar "global" available to other New sessions. It seems "add jar filename.jar" only preHook on current thread. Any help or ...
    Bryan xuBryan xu
    Nov 12, 2010 at 3:57 am
    Nov 12, 2010 at 6:12 am
  • Hello, I'm just starting with hive, and I ran into a newbie problem that didn't have a solution via google. So I thought I'd record the solution for posterity (and other hapless newbies) :) I've been ...
    Stuart SmithStuart Smith
    Nov 9, 2010 at 3:02 am
    Nov 9, 2010 at 7:00 pm
  • Hi all, I am porting custom MR code to Hive and have written working UDFs where I need them. Is there a work around to having to do this in Hive: select * from ( select name_id, toTileX(longitude,0) ...
    Tim RobertsonTim Robertson
    Nov 7, 2010 at 9:01 pm
    Nov 8, 2010 at 4:22 pm
  • Hi all, I am trying my first UDTF, but can't seem to get it to run. Can anyone spot anything wrong with this please: hive select taxonDensityUDTF(kingdom_concept_id, phylum_concept_id) as p,k from ...
    Tim RobertsonTim Robertson
    Nov 8, 2010 at 8:41 am
    Nov 9, 2010 at 12:25 pm
  • According to the Hive wiki, ngrams() and context_ngrams() are available in Hive. This is awesome. However, when I quickly logged into my Hive 0.5 instance to check it out, it dissapointed me with ...
    Gokul PillaiGokul Pillai
    Nov 6, 2010 at 12:20 am
    Nov 8, 2010 at 11:11 pm
  • Hi, While doing an insert into partitions if there is a failure in the map/reduce task (maybe due to a UDF bug), does hive cleanup the output directory corresponding to the partition? The behavior in ...
    Pradeep KamathPradeep Kamath
    Nov 2, 2010 at 10:27 pm
    Nov 3, 2010 at 12:18 am
  • I'm trying to create an external table to a pre-existing HBase table using Hive trunk, like so: CREATE EXTERNAL TABLE hbase_metrics (key string, value map<string,int ) STORED BY ...
    Xavier StevensXavier Stevens
    Nov 24, 2010 at 12:16 am
    Nov 24, 2010 at 7:09 pm
  • I suffer from "sql-itis", especially the SQL:2003 variant. I can barely get a data-related programming line out of my fingers that doesn't include a "partition by" or an "over order by". Many of the ...
    Michael RoesslerMichael Roessler
    Nov 16, 2010 at 8:49 pm
    Nov 18, 2010 at 8:15 pm
  • Hello, I am completely new to hive and I need some help. Hive starts fine, but when I try to create a table, I get an error. See below. hive CREATE TABLE pokes (foo INT, bar STRING); Exception in ...
    Gerlach, Hannah L (IS)Gerlach, Hannah L (IS)
    Nov 16, 2010 at 5:40 pm
    Nov 16, 2010 at 7:57 pm
  • Hi, I have a table A with some values and another table B with some other values How do I get all the distinct values from A that are NOT in B e.g if table A has values 1,2,3,4,1,2,3,5,6,7 and B has ...
    איל (Eyal)איל (Eyal)
    Nov 3, 2010 at 12:14 pm
    Nov 4, 2010 at 8:16 am
  • I use hive client through php, it always works quite well, but recently it sometimes throw a weird exception : [28-Nov-2010 05:01:04] PHP Fatal error: Uncaught exception 'HiveServerException' with ...
    ShanganShangan
    Nov 29, 2010 at 4:11 am
    Dec 1, 2010 at 1:55 am
  • Hello, Does anyone have some example code of using building this? My steps, I'm trying to build a shared library using the thrift api 1. Checked out from SVN (trunk) 2. Made a directory called ...
    Saptarshi GuhaSaptarshi Guha
    Nov 30, 2010 at 1:43 am
    Nov 30, 2010 at 3:05 am
  • Hi all, I have a bunch of files, and want to import them into one table each partition per file. Currently, I have to enter each add partition statement in cli. So I wonder whether hive have a batch ...
    Jeff ZhangJeff Zhang
    Nov 25, 2010 at 9:24 am
    Nov 25, 2010 at 9:24 am
  • Environment Info : SLES10SP1, Hadoop 0.20.2, Hive 0.6.0 This is the scenario : 1. start hive shell from /root/tmp directory and create a table and quit out of hive. 2. start hive shell from /root ...
    M.R. MuthukumarM.R. Muthukumar
    Nov 12, 2010 at 11:23 pm
    Nov 14, 2010 at 3:16 am
  • http://www.slideshare.net/jsichi/hive-evolution-apachecon-2010 JVS
    John SichiJohn Sichi
    Nov 8, 2010 at 11:09 pm
    Nov 9, 2010 at 5:51 pm
  • Hi all, Is the following a valid UDF please? When I run it I get the following so I presume not: hive select toGoogleCoords(latitude,longitude,1) from raw_occurrence_record limit 100; FAILED: Error ...
    Tim RobertsonTim Robertson
    Nov 2, 2010 at 4:46 pm
    Nov 2, 2010 at 7:12 pm
  • Hi , We are using Postgres as Hive Meta Store. When we try to drop a table , It hangs. Below is the small dump Can any one help me in this regard 10/11/29 06:02:07 DEBUG metastore.ObjectStore: ...
    Rahul SinghRahul Singh
    Nov 29, 2010 at 6:07 am
    Nov 29, 2010 at 7:02 am
  • Hi, I want to convert data stored in a hadoop sequence file to BytesRefArrayWritable so that I can use RCFileOutputFormat and create an RCFile. My data contains integers,strings and hashmaps. I guess ...
    Avrilia FloratouAvrilia Floratou
    Nov 13, 2010 at 10:30 pm
    Nov 14, 2010 at 5:40 am
  • It looks like only one user can access the Apache Derby DB. When I try to have multiple jobs running on hive, the other jobs complain something like this: FAILED: Error in metadata: ...
    Bichonfrise74Bichonfrise74
    Nov 4, 2010 at 9:32 pm
    Nov 4, 2010 at 10:02 pm
  • When I create one table, hive throw below Exception: 2010-11-03 09:42:02,939 ERROR exec.DDLTask (SessionState.java:printError(277)) - FAILED: Error in metadata: java.lang.RuntimeExcepti on: ...
    Lei liuLei liu
    Nov 3, 2010 at 9:04 am
    Nov 3, 2010 at 9:56 am
  • I am interested in using the correlation UDAF available in version 0.7 (see https://issues.apache.org/jira/browse/HIVE-1549) but am using AWS Elastic Map-Reduce which is currently running version ...
    Eric HalpernEric Halpern
    Nov 30, 2010 at 3:24 am
    Nov 30, 2010 at 3:24 am
  • The following query doesn't run with the error: FAILED: Parse Error: line 3:0 mismatched input 'tablesample' expecting EOF Am I doing something obviously wrong, or can you just not use tablesample ...
    Leo AlekseyevLeo Alekseyev
    Nov 29, 2010 at 12:09 am
    Nov 29, 2010 at 12:09 am
  • Hi, We just pushed Hive .7 and using Mysql has the HiveMetaStore backend into our ad-hoc cluster. There are large number of queries that are submitted in parallel against the Hive backend . Some of ...
    Ray DuongRay Duong
    Nov 28, 2010 at 5:09 pm
    Nov 28, 2010 at 5:09 pm
  • Hi, I have set up a 3 node hadoop cluster excluding 1 name node . Currently, i have installed hive and hive metastore on name node. But now due to some space issue, i want to move hive out of name ...
    Vaibhav negiVaibhav negi
    Nov 25, 2010 at 10:39 am
    Nov 25, 2010 at 10:39 am
  • Hi, When running a query like: EXPLAIN SELECT * FROM mytable over the JDBC driver, calling ResultSet.next() returns false at the end of the abstract syntax tree, even though there are more rows to ...
    Peter HallPeter Hall
    Nov 24, 2010 at 5:07 am
    Nov 24, 2010 at 5:07 am
  • Hi All Before Hive-1785 committed, the old hook interface will take 4 or 5 parameters to run, which is not scalable for adding more complicated hooks. Hooks may need more information than these 4 or ...
    Liyin TangLiyin Tang
    Nov 24, 2010 at 3:39 am
    Nov 24, 2010 at 3:39 am
  • Hi all, We have a large amount of data in HDFS stored in Avro format. We don't want to convert it to Hive supported format. That is why we have developed a custom InputFormat and Deserializer. Our ...
    Denitsa TsolovaDenitsa Tsolova
    Nov 19, 2010 at 5:16 pm
    Nov 19, 2010 at 5:16 pm
  • Hi, i have a problem selecting tables over a jdbc connection. when i try to select a partitioned Table i get the following error: "Error in semantic analysis: javax.jdo.JDODataStoreException: Error ...
    Peter LimbachPeter Limbach
    Nov 19, 2010 at 4:32 pm
    Nov 19, 2010 at 4:32 pm
  • Hello all, I'm using Hive to do mashups of data that is currently on HDFS and data is that is on a MySQL database... I'm considering this scenario instead of bringing the data from MySQL to HDFS ...
    Marcello de SalesMarcello de Sales
    Nov 16, 2010 at 8:11 pm
    Nov 16, 2010 at 8:11 pm
  • How many simultaneous users of hive can there be? Are different invocations of hive by the same user likely to conflict? I ask as I have millions of files to load into hive and so it makes sense to ...
    David LaryDavid Lary
    Nov 16, 2010 at 2:33 pm
    Nov 16, 2010 at 2:33 pm
  • There is select statement, as below: SELECT itemId FROM (SELECT user_id AS itemId FROM r_dm_pv_vstcat1_dm WHERE cat_id1 IN ('14', '1101', '1201', '50008090', '50012164', '11', '1512') AND (pt <= ...
    Lei liuLei liu
    Nov 16, 2010 at 1:49 am
    Nov 16, 2010 at 1:49 am
  • HI, I am trying to run the odbc test in hive and I get this error *ant test -Dthrift.home=/media/sda1/thrift-0.5.0* Buildfile: build.xml check-word-size: check-thrift-home: test: [exec] ...
    איל (Eyal)איל (Eyal)
    Nov 14, 2010 at 2:27 pm
    Nov 14, 2010 at 2:27 pm
  • Is there a maximum limit of 10 fields in a UDTF? The following is always giving issues: public void process(Object[] args) throws HiveException { ... ((LazyInteger) ...
    Tim RobertsonTim Robertson
    Nov 11, 2010 at 3:39 pm
    Nov 11, 2010 at 3:39 pm
  • Hi, I just recently updated to trunk, was lagging a few months behind. Now I'm getting errors like: "Filtering is supported only on partition keys of type string" It seems some type checking was ...
    Bennie SchutBennie Schut
    Nov 8, 2010 at 10:40 am
    Nov 8, 2010 at 10:40 am
  • Hi, I am trying to test Dynamic-partition Insert. But this is not working as expected. Kindly help how to solve this problem. Created source table ------------------ CREATE EXTERNAL TABLE testmove ( ...
    Saravanan RajendranSaravanan Rajendran
    Nov 8, 2010 at 6:01 am
    Nov 8, 2010 at 6:01 am
  • Hello Hadoop fans, The Bay Area Hadoop User Group meetups are a long hike for those of us who come from San Francisco. I'd like to gauge interest in SF-centric Hadoop gatherings. In contrast to the ...
    Aaron KimballAaron Kimball
    Nov 4, 2010 at 7:39 pm
    Nov 4, 2010 at 7:39 pm
  • Hi, In MySQL to match '12684041234' to the longest prefix I would do SELECT num_prefix FROM nums WHERE '12684041234' LIKE CONCAT(num_prefix, '%') AND LENGTH(num_prefix) = ( SELECT ...
    איל (Eyal)איל (Eyal)
    Nov 4, 2010 at 2:05 pm
    Nov 4, 2010 at 2:05 pm
Group Navigation
period‹ prev | Nov 2010 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions41
posts137
users55
websitehive.apache.org

55 users for November 2010

Tim Robertson: 13 posts John Sichi: 7 posts Leo Alekseyev: 7 posts Stuart Smith: 6 posts Dave Brondsema: 5 posts Yongqiang he: 5 posts איל (Eyal): 5 posts Afancy: 4 posts Carl Steinbach: 4 posts Edward Capriolo: 4 posts Namit Jain: 4 posts Ning Zhang: 4 posts Ted Yu: 4 posts Gokul Pillai: 3 posts Jeff Zhang: 3 posts John Sichi: 3 posts Marcello de Sales: 3 posts Vivek Mishra: 3 posts Xavier Stevens: 3 posts Bennie Schut: 2 posts
show more
Archives