in hive when you create table and use the location to refer hdfs path, thatpath is supposed to be a directory.If the directory is not existing it will try to create it and if its a fileit will throw an error as its not a directorythats the error you are getting that location you referred is a file.Change it to the directory and see if that works for youOn Thu, Jun 20, 2013 at 10:57 PM, sanjeev sag