Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Need help with Installation hive 0.11

Copy link to this message
Re: Need help with Installation hive 0.11
from hive-0.11 , hcat is part of hive.

So you basically do not need to configure your ports etc in hcat_server.sh

what you need to set is hive.metastore.uris in hive-site.xml. Default port
is 9083 I suppose

On Thu, Oct 10, 2013 at 12:36 PM, Baahu <[EMAIL PROTECTED]> wrote:

> Thanks Nitin for your help.I was able to run hive and also start meta
> store finally !!
> The tar should contain required config files(instead of having templates),
> otherwise it turns out to be a difficult for newbies like me to go ahead
> and learn/use hive.
> Also I could not find the port number for metastore and had to hardcode it
> in hcat_server.sh.
> On Mon, Oct 7, 2013 at 3:29 PM, Nitin Pawar <[EMAIL PROTECTED]>wrote:
>> So here is what I did quickly. (I did not follow the step by step guide
>> from hive wiki)
>> 1) I already have a running hadoop cluster
>> 2) Downloaded the bin-tar.gz from hive.apache.org links
>> 3) Uncompressed the binaries
>> 4) Inside the conf folder there are few .template files (I don't know
>> there is no hive-site.xml there. In core hadoop projects the core-site.xml
>> is empty but its present)
>> 5) I just copied all the template files non template files (eg.
>> hive-defaults.xml.template to hive-defaults.xml and so on)
>> 6) I created a a new hive-site.xml file
>> 7) added following properties to it (which are kind of missing from
>> hive-defaults but we will talk on dev forums for that)
>>    - javax.jdo.option.ConnectionURL - I use mysql as my meta store so i
>>    have pointed this to
>>    jdbc:mysql://<myhost>:<myport>/<mydbname>?createDatabaseIfNotExist=true
>>    - javax.jdo.option.ConnectionDriverName - this is set to
>>    com.mysql.jdbc.driver  I have downloaded mysql driver from oracle and
>>    stored in hive lib folder.
>>    - javax.jdo.option.ConnectionUserName - this is my db username
>>    - javax.jdo.option.ConnectionPassword - this is password for the
>>    username i used above
>> 8) export HADOOP_HOME variable to where my hadoop installation is present
>> 9) export HIVE_HOME to the directory where I have extracted the tar ball
>> 10) Granted access to new machine on mysql db
>> 11) started hive metastore and verified show tables.
>> This worked. Of course this does not take care of security on hive yet.
>> if run into any issues after this do let me know.
>>  On Sat, Oct 5, 2013 at 7:50 PM, Nitin Pawar <[EMAIL PROTECTED]>wrote:
>>> Baahu,
>>> hive has two conf files. One is hive-site.xml and other is hive-env.sh
>>> From hive-0.11 hcat is bundled with hive so you specially need not do
>>> anything special to setup hcat.
>>> you just need to setup few environment variables like HIVE_HOME,
>>> and then if you have setup the hive-site.xml correctly then it should
>>> work out of the box.
>>> If you have downloaded the already built tarball. you need not compile
>>> it. Plus its really a long build if you run it with unit test cases etc.
>>> If possible tonight I will  setup a vm and test out the steps mentioned
>>> on hive wiki.
>>> On Sat, Oct 5, 2013 at 7:21 PM, Baahu <[EMAIL PROTECTED]> wrote:
>>>> Mikhail,
>>>> The hive-site.xml was missing and while googling I found some
>>>> suggestion of copying
>>>> hive-0.11.0-bin/hcatalog/etc/hcatalog/proto-hive-site.xml as hive-site.xml
>>>> to the directory hive-0.11.0-bin/conf .
>>>> Was this a right instruction, if not can you please let me know where I
>>>> can find hive-conf.xml file.
>>>> Should we really have to build hive as mentioned in the below link
>>>> during installation? Just untarring the hive tar ball doesn't lead to its
>>>> installation?
>>>> https://cwiki.apache.org/confluence/display/Hive/GettingStarted
>>>> Thanks,
>>>> Baahu
>>>>  On Sat, Oct 5, 2013 at 3:26 PM, Mikhail Antonov <[EMAIL PROTECTED]>wrote:
>>>>> Bases on original question I decided the author does not need hcatalog
>>>>> specifically, but got sample hive-site.xml suggesting storage authenticator
Nitin Pawar