Hi Shreehari, I'd recommend using a list since my limited free time does not permit me to make sure to reply to every single email sent to me personally. Using a community mailing list also lets you get thoughts of several experienced folks out there, than just one person :)
I'd recommend sending the question to the Oozie lists, [email protected]. I've added the list to this response. You can subscribe to these lists via instructions at http://oozie.apache.org/mail-lists.html. >From a brief read, however, your problem is that Oozie may not understand relative paths, given the user/location it runs that command as. Try passing an absolute path, such as "/user/shreehari/downloads/test/" for example, and verify? On Wed, Feb 13, 2013 at 10:59 AM, <[email protected]> wrote: > Hi Harsha, > > We are planning to use Oozie as work flow scheduler with Hadoop and Hive. > > But the problem we are facing is we are unable to access files stored in > local file system to upload it in hive through Oozie. > > example: LOAD DATA LOCAL INPATH 'downloads/test/' INTO TABLE TEST; > > if i execute this in hive then it works fine, but same thing if run it > through Oozie it throws error saying the path 'downloads/test/' as invalid > path. > > As i understood Oozie run over hdfs, so it is expecting files in hdfs. > > I am new to hadoop and oozie. Is there anyway we can achieve this through > Oozie? > > is there any better work flow scheduler we can use? > > Thanks > Shreehari -- Harsh J
