to hiveuserlocalhost identified by hivepassword. ![]() Connect to the default MySQL database as the root user: Create a MySQL database named mysqltestdb and. Get into conf directory under apache-hive-2.1.1-bin folder and edit the derby configurations in below files rootEdgeNode:/usr/local/hive/hivework mysql -u root -p mysql> CREATE DATABASE metastore mysql> CREATE USER hivelocalhost IDENTIFIED BY. mysql> CREATE USER hiveuser IDENTIFIED BY hivepassword mysql> GRANT all on. Identify the host name and port of your MySQL server. Mysql> GRANT all on *.* to identified by 'tcstcs123' ġ0. Create Hive user and Hivepassword: mysql> CREATE USER IDENTIFIED BY 'tcstcs123' Now your root password should be working with the one you just set, check it with: mysql -u root -pĩ. To get hive username and password, go to hive-site.xml and search for and .The values of these properties are your hive username and password respectively. Now all you have to do is reset your root password of the MySQL user and restart the MySQL service: update user set password=PASSWORD("YOURPASSWORDHERE") where User='root' Creation of External table : External tables in hive are kind of permanent tables and stays there even if hive is stopped or server goes down. Assign the DB that needs to be used: use mysql The SQL standards based authorization option (introduced in Hive 0.13) provides a third option for authorization in Hive. ![]() Mysql database installation and configurationġ.Download and install and its dependencies.Ģ.Initialize db with command $ mysql_install_dbĬonnect to mysql with command $ mysql -u root -pģ.It will prompt for a password as we have not given any password.Enter MySQL with the same mode and update the password sudo /etc/init.d/mysql stopĤ.Now start up MySQL in safe mode, so you’ll skip the privileges table: sudo mysqld_safe -skip-grant-tables &ĥ. In a same project multiple hive users need to worked on it, and they can use hive concurrently on different machine but the metadata should be stored on centralized by using MySql or Oracle, ect.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |