You can find documentation for installation and configuration here: - Old versions of HCatalog: http://hive.apache.org/docs/hcat_r0.5.0/install.html - Current HCatalog: https://cwiki.apache.org/confluence/display/Hive/HCatalog+InstallHCat - Hive metastore: https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin
The Hive metastore doc says you need javax.jdo.option.ConnectionUserName & javax.jdo.option.ConnectionPassword (#3 & #4) for local and remote modes, but not for embedded mode. Only remote mode needs hive.metastore.uris (#5). I'm standing by to improve the documentation if you find any errors, omissions, or confusions. -- Lefty On Wed, Dec 4, 2013 at 6:38 AM, Biswajit Nayak <biswajit.na...@inmobi.com>wrote: > thanks a lot again for the quick response.. > > > On Wed, Dec 4, 2013 at 8:02 PM, Nitin Pawar <nitinpawar...@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.na...@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 <nitinpawar...@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.na...@inmobi.com> wrote: >>>> >>>>> Thanks a lot.. I am a naive to hive.. >>>>> On 4 Dec 2013 18:13, "Nitin Pawar" <nitinpawar...@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.na...@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. >