Hive - Configure Metastore

https://hive.apache.org/docs/latest/admin/adminmanual-metastore-3-0-administration/

 

You can find an E/R diagram for the metastore here.

 

Download Standalone Metastore:

https://dlcdn.apache.org/hive/hive-standalone-metastore-4.2.0/hive-standalone-metastore-4.2.0-bin.tar.gz

 

frank@ZZHPC:~/download$ tar -xzf hive-standalone-metastore-4.2.0-bin.tar.gz

frank@ZZHPC:~/download$ mv apache-hive-metastore-4.2.0-bin apache-hive-metastore-4.2.0

 

.bashrc:

export METASTORE_HOME=~/download/apache-hive-metastore-4.2.0

 

Download JDBC driver for PostgreSQL:

frank@ZZHPC:~/download$ wget https://jdbc.postgresql.org/download/postgresql-42.7.8.jar