Hive
  1. Hive
  2. HIVE-2442

Metastore upgrade script and schema DDL for Hive 0.8.0

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: Metastore
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    1. HIVE-2442-branch-08.1.patch.txt
      45 kB
      Carl Steinbach
    2. HIVE-2442-trunk.1.patch.txt
      89 kB
      Carl Steinbach

      Issue Links

        Activity

        Hide
        John Sichi added a comment -

        (Also committed to 0.8 branch.)

        Show
        John Sichi added a comment - (Also committed to 0.8 branch.)
        Hide
        Hudson added a comment -

        Integrated in Hive-0.8.0-SNAPSHOT-h0.21 #31 (See https://builds.apache.org/job/Hive-0.8.0-SNAPSHOT-h0.21/31/)
        HIVE-2442. Metastore upgrade script and schema DDL for Hive 0.8.0
        (Carl Steinbach via jvs)

        jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1175029
        Files :

        • /hive/branches/branch-0.8/metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql
        • /hive/branches/branch-0.8/metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql
        • /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
        • /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql
        • /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql
        Show
        Hudson added a comment - Integrated in Hive-0.8.0-SNAPSHOT-h0.21 #31 (See https://builds.apache.org/job/Hive-0.8.0-SNAPSHOT-h0.21/31/ ) HIVE-2442 . Metastore upgrade script and schema DDL for Hive 0.8.0 (Carl Steinbach via jvs) jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1175029 Files : /hive/branches/branch-0.8/metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql /hive/branches/branch-0.8/metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/008- HIVE-2246 .mysql.sql /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql /hive/branches/branch-0.8/metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-h0.21 #974 (See https://builds.apache.org/job/Hive-trunk-h0.21/974/)
        HIVE-2442. Metastore upgrade script and schema DDL for Hive 0.8.0
        (Carl Steinbach via jvs)

        jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1175028
        Files :

        • /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql
        • /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.9.0.derby.sql
        • /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql
        • /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql
        • /hive/trunk/metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql
        • /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql
        • /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.9.0.mysql.sql
        • /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql
        • /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql
        Show
        Hudson added a comment - Integrated in Hive-trunk-h0.21 #974 (See https://builds.apache.org/job/Hive-trunk-h0.21/974/ ) HIVE-2442 . Metastore upgrade script and schema DDL for Hive 0.8.0 (Carl Steinbach via jvs) jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1175028 Files : /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql /hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.9.0.derby.sql /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql /hive/trunk/metastore/scripts/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql /hive/trunk/metastore/scripts/upgrade/mysql/008- HIVE-2246 .mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.9.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql /hive/trunk/metastore/scripts/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql
        Hide
        John Sichi added a comment -

        +1, committed to trunk, thanks Carl!

        I did not do testing; we can do that with the release candidate, and then if there are problems, submit a corrective patch.

        I noticed that you omitted PostgreSQL?

        Show
        John Sichi added a comment - +1, committed to trunk, thanks Carl! I did not do testing; we can do that with the release candidate, and then if there are problems, submit a corrective patch. I noticed that you omitted PostgreSQL?
        Hide
        jiraposter@reviews.apache.org added a comment -

        -----------------------------------------------------------
        This is an automatically generated e-mail. To reply, visit:
        https://reviews.apache.org/r/2026/
        -----------------------------------------------------------

        Review request for hive.

        Summary
        -------

        Metastore upgrade scripts and schema DDL for Hive 0.8.0 and 0.9.0-dev.
        The 0.8.0 version of this patch does not include the 0.9.0 schema DDL
        and 0.8.0-to-0.9.0 upgrade script.

        This addresses bug HIVE-2442.
        https://issues.apache.org/jira/browse/HIVE-2442

        Diffs


        metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql PRE-CREATION
        metastore/scripts/upgrade/derby/hive-schema-0.9.0.derby.sql PRE-CREATION
        metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql PRE-CREATION
        metastore/scripts/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql PRE-CREATION
        metastore/scripts/upgrade/mysql/008-HIVE-2246.mysql.sql 2e3821d
        metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql PRE-CREATION
        metastore/scripts/upgrade/mysql/hive-schema-0.9.0.mysql.sql PRE-CREATION
        metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql PRE-CREATION
        metastore/scripts/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql PRE-CREATION

        Diff: https://reviews.apache.org/r/2026/diff

        Testing
        -------

        Thanks,

        Carl

        Show
        jiraposter@reviews.apache.org added a comment - ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/2026/ ----------------------------------------------------------- Review request for hive. Summary ------- Metastore upgrade scripts and schema DDL for Hive 0.8.0 and 0.9.0-dev. The 0.8.0 version of this patch does not include the 0.9.0 schema DDL and 0.8.0-to-0.9.0 upgrade script. This addresses bug HIVE-2442 . https://issues.apache.org/jira/browse/HIVE-2442 Diffs metastore/scripts/upgrade/derby/hive-schema-0.8.0.derby.sql PRE-CREATION metastore/scripts/upgrade/derby/hive-schema-0.9.0.derby.sql PRE-CREATION metastore/scripts/upgrade/derby/upgrade-0.7.0-to-0.8.0.derby.sql PRE-CREATION metastore/scripts/upgrade/derby/upgrade-0.8.0-to-0.9.0.derby.sql PRE-CREATION metastore/scripts/upgrade/mysql/008- HIVE-2246 .mysql.sql 2e3821d metastore/scripts/upgrade/mysql/hive-schema-0.8.0.mysql.sql PRE-CREATION metastore/scripts/upgrade/mysql/hive-schema-0.9.0.mysql.sql PRE-CREATION metastore/scripts/upgrade/mysql/upgrade-0.7.0-to-0.8.0.mysql.sql PRE-CREATION metastore/scripts/upgrade/mysql/upgrade-0.8.0-to-0.9.0.mysql.sql PRE-CREATION Diff: https://reviews.apache.org/r/2026/diff Testing ------- Thanks, Carl

          People

          • Assignee:
            Roshan Naik
            Reporter:
            Carl Steinbach
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development