The whole process of configuring hive metadata to MySQL

• In the hive installation directory, enter the conf directory and create a hive-site.xml file
• Configure parameters according to the official documentation and copy the data to the hive-site.xml file
  https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin

Note: Create a metastore database first, and use latin1 as the character set

Copy the mysql driver to the hive lib directory. (This is related to the previous article on installing MySQL)

Unzip the driver package

Copy the mysql driver to the hive lib directory

Start hive (don’t forget to start hdfs and yarn first~~)

start-dfs.sh
start-yarn.sh
hive

Create a table and see if the metadata can be saved in MySQL

Check out the metastore library

TBLS Table

COLUMNS_V2 table

DBS Table

From the above figure, we can see

The structure of metadata

1. The table information is stored in the tbls table, and foreign key constraints are performed through db_id and the database in the dbs table!
2. The library information is stored in the dbs table!
3. The field information exists in the column_v2 table, and the foreign key constraint is performed through CD_ID and the primary key of the table!

Summarize

This is the end of this article about the whole process of configuring hive metadata to Mysql. For more relevant content about configuring hive metadata to Mysql, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!