Installation and configuration of hadoop components hive issues Collection
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.
