Hive
  1. Hive
  2. HIVE-4024

Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      The problem is in following file 011-HIVE-3649.derby.sql that contains following line:

      ALTER TABLE "SDS" ADD  "IS_STOREDASSUBDIRECTORIES" CHAR(1) NOT NULL;
      

      This query will however fail if the table SDS have at least one row.

      1. bugHIVE-4024.patch
        0.8 kB
        Jarek Jarcec Cecho

        Issue Links

          Activity

          Hide
          Namit Jain added a comment -

          +1

          Show
          Namit Jain added a comment - +1
          Hide
          Namit Jain added a comment -

          Committed. Thanks Jarek

          Show
          Namit Jain added a comment - Committed. Thanks Jarek
          Hide
          Hudson added a comment -

          Integrated in hive-trunk-hadoop1 #91 (See https://builds.apache.org/job/hive-trunk-hadoop1/91/)
          HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0
          to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584)

          Result = ABORTED
          namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584
          Files :

          • /hive/trunk/metastore/scripts/upgrade/derby/011-HIVE-3649.derby.sql
          Show
          Hudson added a comment - Integrated in hive-trunk-hadoop1 #91 (See https://builds.apache.org/job/hive-trunk-hadoop1/91/ ) HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584) Result = ABORTED namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584 Files : /hive/trunk/metastore/scripts/upgrade/derby/011- HIVE-3649 .derby.sql
          Hide
          Hudson added a comment -

          Integrated in Hive-trunk-hadoop2 #128 (See https://builds.apache.org/job/Hive-trunk-hadoop2/128/)
          HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0
          to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584)

          Result = FAILURE
          namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584
          Files :

          • /hive/trunk/metastore/scripts/upgrade/derby/011-HIVE-3649.derby.sql
          Show
          Hudson added a comment - Integrated in Hive-trunk-hadoop2 #128 (See https://builds.apache.org/job/Hive-trunk-hadoop2/128/ ) HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584) Result = FAILURE namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584 Files : /hive/trunk/metastore/scripts/upgrade/derby/011- HIVE-3649 .derby.sql
          Hide
          Hudson added a comment -

          Integrated in Hive-trunk-h0.21 #1976 (See https://builds.apache.org/job/Hive-trunk-h0.21/1976/)
          HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0
          to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584)

          Result = FAILURE
          namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584
          Files :

          • /hive/trunk/metastore/scripts/upgrade/derby/011-HIVE-3649.derby.sql
          Show
          Hudson added a comment - Integrated in Hive-trunk-h0.21 #1976 (See https://builds.apache.org/job/Hive-trunk-h0.21/1976/ ) HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0 (Jarek Jarcec Cecho via namit) (Revision 1447584) Result = FAILURE namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1447584 Files : /hive/trunk/metastore/scripts/upgrade/derby/011- HIVE-3649 .derby.sql

            People

            • Assignee:
              Jarek Jarcec Cecho
              Reporter:
              Jarek Jarcec Cecho
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development