Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: CDH3b4
    • Fix Version/s: CDH3u0
    • Component/s: Hive, Packaging
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              jolly Jolly Chen
              Reporter:
              larsgeorge Lars George
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: