Is there a way I can change this permission issue in HIVE because I can only have read access to the file.Please Help !
On Thursday, 27 February 2014 3:25 PM, Rishabh Bhardwaj <rbnex...@yahoo.com> wrote: Thanks for your reply... I dig some more about the same and found that the solution is to have write permission on the file..... On Thursday, 27 February 2014 1:13 PM, shashwat shriparv <dwivedishash...@gmail.com> wrote: Check for errors in hive logs too if any and let us know Warm Regards_∞_ Shashwat Shriparv On Thu, Feb 27, 2014 at 1:09 PM, shashwat shriparv <dwivedishash...@gmail.com> wrote: Check if hive server is running and not stopped. > > > >Warm Regards_∞_ >Shashwat Shriparv > > > > > > >On Thu, Feb 27, 2014 at 12:52 PM, Rishabh Bhardwaj <rbnex...@yahoo.com> wrote: > > >> >> >>On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <rbnex...@yahoo.com> >>wrote: >> >>Hi , >> >> >>I have created a external table and when I provide the location of the data >>for this table I get the following error: >>FAILED: Error in metadata: >>MetaException(message:java.lang.IllegalStateException: Can't overwrite cause) >>FAILED: Execution Error, return code 1 from >>org.apache.hadoop.hive.ql.exec.DDLTask >>Also I am able to load the same file using PIG Script using the PigStorage() >>loader function. >>I have the following permissions on the file: rw-rw-r-- >>and on the folder where this file resides (Giving the path of this folder in >>location in the query ) : drwxrwxr-x >>What can be the cause for this and how to correct this error ? >> >> >
