Details
Description
https://ccp.cloudera.com/display/CDHDOC/Hive+Installation
"The MySQL administrator should create the initial database schema using the appropriate hive-schema-VERSION.mysql.sql file in the /usr/lib/hive/scripts/metastore/upgrade/mysql directory."
mysql> CREATE DATABASE metastore;
mysql> USE metastore;
mysql> SOURCE /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-VERSION.mysql.sql;
$ ls -lR /usr/lib/hive/scripts/metastore/
/usr/lib/hive/scripts/metastore/:
total 4
drwxr-xr-x 5 root root 4096 Feb 28 17:33 upgrade
/usr/lib/hive/scripts/metastore/upgrade:
total 12
drwxr-xr-x 2 root root 4096 Feb 28 17:33 derby
drwxr-xr-x 2 root root 4096 Feb 28 17:33 mysql
drwxr-xr-x 2 root root 4096 Feb 28 17:33 postgres
/usr/lib/hive/scripts/metastore/upgrade/derby:
total 16
-rwxr-xr-x 1 root root 560 Feb 21 15:12 README
-rwxr-xr-x 1 root root 1525 Feb 21 15:12 upgrade-0.6.0.derby.sql
-rwxr-xr-x 1 root root 7116 Feb 21 15:12 upgrade-0.7.0.derby.sql
/usr/lib/hive/scripts/metastore/upgrade/mysql:
total 20
-rwxr-xr-x 1 root root 293 Feb 21 15:12 README
-rwxr-xr-x 1 root root 1332 Feb 21 15:12 upgrade-0.6.0.mysql.sql
-rwxr-xr-x 1 root root 8499 Feb 21 15:12 upgrade-0.7.0.mysql.sql
/usr/lib/hive/scripts/metastore/upgrade/postgres:
total 4
-rwxr-xr-x 1 root root 1595 Feb 21 15:12 upgrade-0.6.0.postgres.sql
$ rpm -qa | grep hive hadoop-hive-0.7.0+11-2 $ rpm -ql hadoop-hive | grep hive-schema
Tarball has the file, RPM does not.