Shulou(Shulou.com)06/03 Report--

It took 1 day to complete the installation and configuration of hive

One: install mysql first

Download mysql for ubuntu version, which is deb version

Sudo apt-get libaio

Sudo apt-get libmecab2

Then use dpkg-I mysql a series of deb files

Libmysql*

Mysql-community*

Mysql-client*

Mysql-server*

Look at whereis mysql and see that it is installed in a different path

Executable file / etc/bin, configuration file / etc/mysql/conf, wait until

2. Start mysql

Sudo service mysql status

Sudo service mysql start

Mysql-uroot-proot; login by connection

Modify the password

Sudo mysqld-safe-- skip-grant-tables &

Use mysql

Update user set authentication_string=password ('password') where user='root'; this is a big change, because version 5.7 does not have password × ×.

Flush privileges

Grant all privileges on mysql.* to hive@localhost

Grant all on hive.* to hive@'%' identified by 'hive'

Download hive2.1

Tar-xvf apache-hive*.tar.gz

Mv changes the path

Chown modify owner

Chmod 755

Modify / conf/hive-env.sh

/ conf/hive_site.xml

Hive.metastore.uris

Thrift://xxxxxxxx

Thrift uri for the remote metastore. Used by metastore client to connect to remote metastore.

I don't know what this configuration is for. Decisively clear the value of value. Run the show databases command again. Success!

5) remind readers again: when your error message is similar to the above error, please carefully check whether the value configuration of hive.metastore.uris is correct. Jianyi novice do not configure.

Javax.jdo.option.ConnectionURL

Jdbc:mysql://10.1.195.50:3306/hivedb?createDatabaseIfNotExist=true&useUnicode=true&ssl=false

JDBC connect string for a JDBC metastore

Javax.jdo.option.ConnectionDriverName

Com.mysql.jdbc.Driver

Driver class name for a JDBC metastore

Javax.jdo.option.ConnectionUserName

Umobile

Username to use against metastore database

Javax.jdo.option.ConnectionPassword

Umobile

Password to use against metastore database

Note that the online string above & is used to resolve ssl warning errors

Encounter Hive metastore database is not initialized. Please use schematool error

First use the command schematool-dbType mysql-initSchema

Then start hive.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.