Hive schematool to create metastore

Hive 0.12 has a new tool called schematool
This tool is used for two purpose
1) Create new metastore database when you install new Hive

2) Upgrade the existing Hive metastore to new version


To create new metastore when you install new hive

Create hive-site.xml

Inside that specify the details for your mysql ( or other ) database

Use the following command to populate that database

$bin/schematool -dbType mysql –initSchema


schematool -dbType mysql –info

You can also see the details 



No comments:

Post a Comment

Please share your views and comments below.

Thank You.