You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Rishabh Bhardwaj <rb...@yahoo.com> on 2014/02/27 08:22:33 UTC
Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)
On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <rb...@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 ?
Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)
Posted by Rishabh Bhardwaj <rb...@yahoo.com>.
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 <rb...@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 <dw...@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 <dw...@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 <rb...@yahoo.com> wrote:
>
>
>>
>>
>>On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <rb...@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 ?
>>
>>
>
Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)
Posted by Rishabh Bhardwaj <rb...@yahoo.com>.
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 <dw...@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 <dw...@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 <rb...@yahoo.com> wrote:
>
>
>>
>>
>>On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <rb...@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 ?
>>
>>
>
Re: Error in metadata: MetaException(message:java.lang.IllegalStateException:
Can't overwrite cause)
Posted by shashwat shriparv <dw...@gmail.com>.
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/] <sh...@yahoo.com>
On Thu, Feb 27, 2014 at 1:09 PM, shashwat shriparv <
dwivedishashwat@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/] <sh...@yahoo.com>
>
>
>
> On Thu, Feb 27, 2014 at 12:52 PM, Rishabh Bhardwaj <rb...@yahoo.com>wrote:
>
>>
>>
>> On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <
>> rbnext29@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 ?
>>
>>
>>
>
Re: Error in metadata: MetaException(message:java.lang.IllegalStateException:
Can't overwrite cause)
Posted by shashwat shriparv <dw...@gmail.com>.
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/] <sh...@yahoo.com>
On Thu, Feb 27, 2014 at 12:52 PM, Rishabh Bhardwaj <rb...@yahoo.com>wrote:
>
>
> On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <
> rbnext29@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 ?
>
>
>