Local job hashtable FileNotFoundException in YARN

2013-12-04 Thread Juan Martin Pampliega
another filename which is not present and throws a FileNotFoundException and the query fails. I retrieved from the log file in /tmp/ec2-user/.log the following entries: ... 2013-12-04 01:26:50 Starting to launch local task to process map join; maximum memory = 1065484288 2013-12-04 01:26:52 Dump the

FileNotFoundException

2013-08-21 Thread 闫昆
hi all i exec hive (zh_site)> select id, >longitude, >latitude, >month, >round(avg(sd), 2) as avgsd > from data_zh > where id between '5' and '6' >and mon

Re: FileNotFoundException when using hive local mode execution style

2013-06-18 Thread Guillaume Allain
> On 18 June 2013 12:25, Nitin Pawar wrote: > look at the discussion on this thread >https://groups.google.com/a/cloudera.org/forum/?fromgroups=#!topic/cdh-user/gHVq9C5H6RE Thanks for that pointer, although not related to hive 'local-mode', I have set-up the following variables in order to "keep

Re: FileNotFoundException when using hive local mode execution style

2013-06-18 Thread Nitin Pawar
NER and OUTER JOIN queries work just fine (with up to 3 > jobs) with nice performance improvements. > > Unfortunately I ran into a FileNotFoundException > :/tmp/vagrant/hive_2013-06-17_16-10-05_614_7672774118904458113/-mr-1/1/emptyFile)on > some more complex query (4 jobs, di

FileNotFoundException when using hive local mode execution style

2013-06-18 Thread Guillaume Allain
needed directories and permissions) Simple GROUP BY, INNER and OUTER JOIN queries work just fine (with up to 3 jobs) with nice performance improvements. Unfortunately I ran into a FileNotFoundException :/tmp/vagrant/hive_2013-06-17_16-10-05_614_7672774118904458113/-mr-1/1/emptyFile)on some more

Fwd: FileNotFoundException when using hive local mode execution style

2013-06-18 Thread Guillaume Allain
needed directories and permissions) Simple GROUP BY, INNER and OUTER JOIN queries work just fine (with up to 3 jobs) with nice performance improvements. Unfortunately I ran into a FileNotFoundException :/tmp/vagrant/hive_2013-06-17_16-10-05_614_7672774118904458113/-mr-1/1/emptyFile)on some more

Re: Able to ADD JAR but FileNotFoundException while querying

2013-06-02 Thread Lenin Raj
a/cdh-twitter-example >> >> After populating data into HDFS directory, When I tried to query the >> table, I am getting FileNotFoundException for the Hive serdes file. >> ADD JAR command successfully works. But still throws that exception while >> querying the table. >

Re: Able to ADD JAR but FileNotFoundException while querying

2013-06-02 Thread Lenin Raj
o query the > table, I am getting FileNotFoundException for the Hive serdes file. > ADD JAR command successfully works. But still throws that exception while > querying the table. > > > *hive> add jar > /usr/local/hive/hive/hive-serdes/hive-serdes-1.0-SNAPSHOT.jar;* > Added /

Able to ADD JAR but FileNotFoundException while querying

2013-06-01 Thread Lenin Raj
Hello, I created a 'tweets' table as mentioned here: https://github.com/cloudera/cdh-twitter-example After populating data into HDFS directory, When I tried to query the table, I am getting FileNotFoundException for the Hive serdes file. ADD JAR command successfully works. But still t

Query Needing 2 MR Jobs Throws FileNotFoundException

2013-02-13 Thread Chad Bourque
Hi all, I'm running hive-0.9.0-cdh4.1.3. I've created an external table partitioned across year, month, and day. It works fine until I write a query that causes multiple MR jobs to be run. Then I get a FileNotFoundException when it tries to run the second job. Job Submission f

Re: FileNotFoundException

2012-06-04 Thread Bejoy Ks
le:///' Regards Bejoy KS From: "kulkarni.swar...@gmail.com" To: "user@hive.apache.org" Cc: "user@hive.apache.org" Sent: Sunday, June 3, 2012 8:20 PM Subject: Re: FileNotFoundException Did you setup the /usr/hive/warehouse directory in hdfs and do a chmod g+w on

Re: FileNotFoundException

2012-06-03 Thread kulkarni . swarnim
Did you setup the /usr/hive/warehouse directory in hdfs and do a chmod g+w on it? That would be required before you run any queries. On Jun 3, 2012, at 1:53 AM, Павел Мезенцев wrote: > Hello all! > > I tried to create simple table in hive > > create table test (a string); > > But its failed:

Re: FileNotFoundException

2012-06-03 Thread Nitin Pawar
try setting up location in create table statement and provide valid hdfs path On Sun, Jun 3, 2012 at 12:23 PM, Павел Мезенцев wrote: > Hello all! > > I tried to create simple table in hive > > create table test (a string); > > But its failed: > FAILED: Error in metadata: MetaException(message:Go

FileNotFoundException

2012-06-02 Thread Павел Мезенцев
Hello all! I tried to create simple table in hive > create table test (a string); But its failed: FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/test does not exist.) FAILED: Execution Error, return code 1 from org.apac

Re: FileNotFoundException when creating table, following GettingStarted guide

2011-04-20 Thread Karl Ostmo
Turns out this was a simple issue of permissions. To fix it, I first created a group called "hive" on my system. Then I added myself to that group: kostmo@leetbook:~$ sudo usermod -aG hive kostmo Then I changed the group ownership of the warehouse directory: kostmo@leetbook:~$ sudo /home/kostmo/

FileNotFoundException when creating table, following GettingStarted guide

2011-04-20 Thread Karl Ostmo
Hello, I am encountering the exact issue that a user posted about last month (with no response): http://mail-archives.apache.org/mod_mbox/hive-dev/201103.mbox/%3caanlktimf6cr4v3-x+memr9po7dkmlwv23jf38x2+k...@mail.gmail.com%3E#archives I have been working my way through the Hive GettingStarted guid