hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Biswajit Nayak <biswajit.na...@inmobi.com>
Subject Re: DROP command fails with error message
Date Wed, 04 Dec 2013 14:38:48 GMT
thanks a lot again for the quick response..


On Wed, Dec 4, 2013 at 8:02 PM, Nitin Pawar <nitinpawar432@gmail.com> wrote:

> From hive-0.11, hcatalog is part of hive ( before following steps below
> wait for others to reply as well if I made any mistake)
>
> So you need not do anything specific to setup hcatalog.
>
> If you downloaded previous hcatalog code and building it, then you need to
> follow that document.
>
> if you have latest hive binaries then, in hive-site.xml edit following
> 1) set javax.jdo.option.ConnectionURL -> point it to your DB
> 2) set javax.jdo.option.ConnectionDriverName to the driver needed to
> connect to your db
> 3) javax.jdo.option.ConnectionUserName -> username to connect to db
> 4) javax.jdo.option.ConnectionPassword -> password for the username
> 5) hive.metastore.uris -> metastore uri on which it will be reached
>
> assuming that you have all directory permissions in place you can start
> hive metastore service by running
>
> nohup hive --service metastore > somefile &
>
> that should do it.
>
> *Note* this is hive metastore service and not WebHcatalog Service.
>
>
>
>
> On Wed, Dec 4, 2013 at 7:53 PM, Biswajit Nayak <biswajit.nayak@inmobi.com>wrote:
>
>> Thanks a lot Nitin. I was able to drop the database.
>>
>> One question i have, is there any documentation how to configure hcatalog
>> with hive.
>>
>> Thanks
>> Biswa
>>
>>
>> On Wed, Dec 4, 2013 at 6:26 PM, Nitin Pawar <nitinpawar432@gmail.com>wrote:
>>
>>> Welcome to Hive :)
>>>
>>> Let us know if you faced any issues setting up hive (using pure apache
>>> distribution)  (just in case something missed in documentation)
>>> and keep raising your doubts :)
>>>
>>>
>>>
>>>
>>> On Wed, Dec 4, 2013 at 6:23 PM, Biswajit Nayak <
>>> biswajit.nayak@inmobi.com> wrote:
>>>
>>>> Thanks a lot.. I am a naive to hive..
>>>> On 4 Dec 2013 18:13, "Nitin Pawar" <nitinpawar432@gmail.com> wrote:
>>>>
>>>>> Exception clearly says "You are not allowed to drop the default
>>>>> database"
>>>>>
>>>>>
>>>>> On Wed, Dec 4, 2013 at 6:09 PM, Biswajit Nayak <
>>>>> biswajit.nayak@inmobi.com> wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> I was trying to drop a database name "default" but every time it
>>>>>> fails with the below error message. While other commands works fine
like "
>>>>>> show database"
>>>>>>
>>>>>>
>>>>>> hive> DROP DATABASE IF EXISTS default;
>>>>>> FAILED: Execution Error, return code 1 from
>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Can
not drop
>>>>>> default database)
>>>>>> hive>
>>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> Biswajit
>>>>>>
>>>>>> _____________________________________________________________
>>>>>> The information contained in this communication is intended solely
>>>>>> for the use of the individual or entity to whom it is addressed and
others
>>>>>> authorized to receive it. It may contain confidential or legally
privileged
>>>>>> information. If you are not the intended recipient you are hereby
notified
>>>>>> that any disclosure, copying, distribution or taking any action in
reliance
>>>>>> on the contents of this information is strictly prohibited and may
be
>>>>>> unlawful. If you have received this communication in error, please
notify
>>>>>> us immediately by responding to this email and then delete it from
your
>>>>>> system. The firm is neither liable for the proper and complete transmission
>>>>>> of the information contained in this communication nor for any delay
in its
>>>>>> receipt.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Nitin Pawar
>>>>>
>>>>
>>>> _____________________________________________________________
>>>> The information contained in this communication is intended solely for
>>>> the use of the individual or entity to whom it is addressed and others
>>>> authorized to receive it. It may contain confidential or legally privileged
>>>> information. If you are not the intended recipient you are hereby notified
>>>> that any disclosure, copying, distribution or taking any action in reliance
>>>> on the contents of this information is strictly prohibited and may be
>>>> unlawful. If you have received this communication in error, please notify
>>>> us immediately by responding to this email and then delete it from your
>>>> system. The firm is neither liable for the proper and complete transmission
>>>> of the information contained in this communication nor for any delay in its
>>>> receipt.
>>>>
>>>
>>>
>>>
>>> --
>>> Nitin Pawar
>>>
>>
>>
>> _____________________________________________________________
>> The information contained in this communication is intended solely for
>> the use of the individual or entity to whom it is addressed and others
>> authorized to receive it. It may contain confidential or legally privileged
>> information. If you are not the intended recipient you are hereby notified
>> that any disclosure, copying, distribution or taking any action in reliance
>> on the contents of this information is strictly prohibited and may be
>> unlawful. If you have received this communication in error, please notify
>> us immediately by responding to this email and then delete it from your
>> system. The firm is neither liable for the proper and complete transmission
>> of the information contained in this communication nor for any delay in its
>> receipt.
>>
>
>
>
> --
> Nitin Pawar
>

-- 
_____________________________________________________________
The information contained in this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally privileged 
information. If you are not the intended recipient you are hereby notified 
that any disclosure, copying, distribution or taking any action in reliance 
on the contents of this information is strictly prohibited and may be 
unlawful. If you have received this communication in error, please notify 
us immediately by responding to this email and then delete it from your 
system. The firm is neither liable for the proper and complete transmission 
of the information contained in this communication nor for any delay in its 
receipt.

Mime
View raw message