Check for errors in hive logs too if any and let us know
*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 1:09 PM, shashwat shriparv < dwivedishash...@gmail.com> wrote: > 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 ? >> >> >> >