Check if hive server is running and not stopped.
*Warm Regards_**∞_* * Shashwat Shriparv* [image: http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image: https://twitter.com/shriparv] <https://twitter.com/shriparv>[image: https://www.facebook.com/shriparv] <https://www.facebook.com/shriparv>[image: http://google.com/+ShashwatShriparv] <http://google.com/+ShashwatShriparv>[image: http://www.youtube.com/user/sShriparv/videos]<http://www.youtube.com/user/sShriparv/videos>[image: http://profile.yahoo.com/SWXSTW3DVSDTF2HHSRM47AV6DI/] <shrip...@yahoo.com> 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 ? > > >