FAQ

Search Discussions

25 discussions - 152 posts

  • hi list, Let's assume that we have a SequenceFile with a format like this, <LongWritable key, Text value . All of the keys will discard when loading into a hive table. Each value, which is delimited ...
    Jeremy ChowJeremy Chow
    Jan 12, 2009 at 9:20 am
    Jan 14, 2009 at 6:16 pm
  • Hi all, I have a perplexing problem with joins in Hive. I have two tables "A" and "B". A contains two columns x and y. B also contains x and y, and also z. I want to select the values of z from B, ...
    Aaron KimballAaron Kimball
    Jan 23, 2009 at 5:37 am
    Jan 27, 2009 at 3:00 am
  • Ok I still can't manage to get the metastore working with mysql after all this time trying. The error is: FAILED: Error in metadata: MetaException(message:Got exception: ...
    Josh FergusonJosh Ferguson
    Jan 24, 2009 at 8:48 pm
    Jan 24, 2009 at 11:16 pm
  • I have a query that returns the proper results: SELECT TRANSFORM(actor_id) USING '/my/script.rb' AS (actor_id, percentile, count) FROM (SELECT actor_id FROM activities CLUSTER BY actor_id) actors; ...
    Josh FergusonJosh Ferguson
    Jan 12, 2009 at 5:49 am
    Jan 13, 2009 at 7:33 pm
  • Hi, I'm finally getting around to installing hive. I was able to build the latest version from the repository without any problems. However, when I try to run cli from from build/dist/bin, I get the ...
    Shirley CohenShirley Cohen
    Jan 29, 2009 at 7:04 pm
    Jan 31, 2009 at 6:22 pm
  • Is it possible to do a query like the following: INSERT OVERWRITE TABLE table1 PARTITION(...) FROM table2 SELECT TRANSFORM(table2.col1, table2.col2, ...) USING '/my/script' AS (col1, col2, ...) WHERE ...
    Josh FergusonJosh Ferguson
    Jan 9, 2009 at 7:53 pm
    Jan 12, 2009 at 1:57 am
  • Ok so I'm experimenting with the slow running hive query I was having earlier. It was indeed only processing one map task at a time even though I *think* I told it to do more. Anyone who is good with ...
    Josh FergusonJosh Ferguson
    Jan 28, 2009 at 5:20 am
    Jan 29, 2009 at 2:01 am
  • Is it possible to run hive without a hadoop installation on the same machine? Is hive using hadoop for more than just its config files? Josh F.
    Josh FergusonJosh Ferguson
    Jan 25, 2009 at 3:24 am
    Jan 26, 2009 at 7:32 pm
  • I am trying to load a text file that uses ascii(254) as a delimiter Column #1 is time Column #2 is ID Contents of this file (test_data.txt): 11-25-2008-14:37:44þ546460819054541434 ...
    Eric GottschalkEric Gottschalk
    Jan 14, 2009 at 9:39 pm
    Jan 14, 2009 at 10:44 pm
  • So I have a table with roughly 145,000 records spread across 300 files. The total size is about 7MB. Right now I'm running one job tracker and one task tracker which is a high cpu amazon box (1.7 ...
    Josh FergusonJosh Ferguson
    Jan 27, 2009 at 7:28 am
    Jan 27, 2009 at 5:31 pm
  • Hey, I've executed this "LOAD DATA" statement a number of times before and never had this issue. When I drop into the shell, I can see the file I'm trying to load. Hive can't, however; any ideas on ...
    Jeff HammerbacherJeff Hammerbacher
    Jan 23, 2009 at 8:50 am
    Jan 24, 2009 at 11:26 pm
  • Hi list, Is there any interface in hive to let us load a table from a flat text file? and Is it a parallel process? Can anyone give me some explanation about above? Thanks, Jeremy -- My research ...
    Jeremy ChowJeremy Chow
    Jan 12, 2009 at 3:44 am
    Jan 12, 2009 at 10:20 am
  • Hello, I'm rather new to Hive and have been playing with it the last couple weeks to see if it is appropriate to use for a particular project inside where I work. My essential question is, how to ...
    Shane BradyShane Brady
    Jan 29, 2009 at 5:35 pm
    Jan 29, 2009 at 8:04 pm
  • I'm using hive trunk and the following breaks: hive -e "LOAD DATA LOCAL INPATH '/Users/Josh/temporary/77013aaa- fa64-441e-a839-3eded367adb7.tab.bz2' INTO TABLE activities PARTITION ( account='test', ...
    Josh FergusonJosh Ferguson
    Jan 26, 2009 at 5:12 am
    Jan 26, 2009 at 5:45 am
  • Hi all, I generated some data using a MapReduce process (output in HDFS) and want to play with it in Hive. The output is a set of part-nnnn files in a directory. I created the table and tried to run ...
    Aaron KimballAaron Kimball
    Jan 21, 2009 at 3:56 am
    Jan 21, 2009 at 4:59 am
  • If I'm running a query like this: hive SELECT TRANSFORM(actor_id) USING '/my/script' AS (actor_id, percentile, count) FROM activities; It creates a map job for each file. I need every row that is in ...
    Josh FergusonJosh Ferguson
    Jan 12, 2009 at 4:45 am
    Jan 12, 2009 at 7:07 am
  • Can we get some ruby loving in the default service/src dir? Josh
    Josh FergusonJosh Ferguson
    Jan 7, 2009 at 5:04 am
    Jan 10, 2009 at 8:02 pm
  • Hi list, I get a term named bucket when reading hive source code. what is it means? Thanks, Jeremy -- My research interests are distributed systems, parallel computing and bytecode based virtual ...
    Jeremy ChowJeremy Chow
    Jan 8, 2009 at 8:22 am
    Jan 9, 2009 at 6:57 am
  • What's the current strategy for when you have a production system and you realize you need to add another column to the table or do some other thing? Seems like you'd have to make a new table, run a ...
    Josh FergusonJosh Ferguson
    Jan 26, 2009 at 11:06 pm
    Jan 26, 2009 at 11:46 pm
  • I'm sure that isn't surprising, can someone explain this error to me? org.apache.hadoop.hive.serde2.SerDeException: Trying to serialize 0 fields into a struct with 2 The query that caused this is the ...
    Josh FergusonJosh Ferguson
    Jan 16, 2009 at 4:45 am
    Jan 17, 2009 at 4:48 am
  • Is there any discussion about this? is it up to the application right now to specify nil values? If you have them right now entire jobs die because the SerDe throws index out of bounds exceptions. ...
    Josh FergusonJosh Ferguson
    Jan 12, 2009 at 4:25 am
    Jan 12, 2009 at 5:37 am
  • The system I am running this from has an older version of Hive so excuse me if this is already addressed. I am attempting to run this query. CREATE external TABLE webservers_2009_01_25_web1_log_a ...
    Edward CaprioloEdward Capriolo
    Jan 26, 2009 at 11:11 pm
    Jan 26, 2009 at 11:34 pm
  • hey guys, I've seen many .q files in the hive source tree, how can i use them? Thanks, Jeremy -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. ...
    Jeremy ChowJeremy Chow
    Jan 7, 2009 at 6:53 am
    Jan 7, 2009 at 7:11 am
  • I wanted to provide two additional notes about my talk on this list. First, you're really coming to see Aaron Kimball and Tom White - I'm working on getting that fixed on the conference pages. ...
    Christophe BiscigliaChristophe Bisciglia
    Jan 29, 2009 at 2:25 am
    Jan 29, 2009 at 2:25 am
  • I noticed that for some properties like the jpox ones that if I leave a blank value that you don't override the default value in jpox.properties. There are cases however where you want to make the ...
    Josh FergusonJosh Ferguson
    Jan 25, 2009 at 12:58 am
    Jan 25, 2009 at 12:58 am
Group Navigation
period‹ prev | Jan 2009 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions25
posts152
users17
websitehive.apache.org
Archives