How to create initial database without using Hive schema tool

Question

Can anyone explain how to create initial database without using Hive schema tool?

Answer 1

Hey,

If for some reason you decide not to use the schema tool, you can use the file below instead, 

 hive-schema-n.n.n.mysql.sql

That file is located in the /usr/lib/hive/scripts/metastore/upgrade/mysql/ directory.

Proceed as follows if you decide to use

 hive-schema-n.n.n.mysql.sql.

 If you are not using the Hive schema tool, you can use this:-

$ mysql -u root -p
Enter password:
mysql> CREATE DATABASE metastore;
mysql> USE metastore;
mysql> SOURCE /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-n.n.n.mysql.sql;

You also need a MySQL user account for Hive to use to access the metastore. It is very important to prevent this user account from creating or altering tables in the metastore database schema.