Hive
  1. Hive
  2. HIVE-3998

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

    Details

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

      Description

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

      alter table  SDS add IS_STOREDASSUBDIRECTORIES NUMBER(1) NOT NULL;
      

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

      1. oracle_update_issue.patch
        0.7 kB
        Jarek Jarcec Cecho

        Issue Links

          Activity

          Jarek Jarcec Cecho created issue -
          Jarek Jarcec Cecho made changes -
          Field Original Value New Value
          Attachment oracle_update_issue.patch [ 12568464 ]
          Jarek Jarcec Cecho made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Jarek Jarcec Cecho made changes -
          Description The problem is in following file {{011-HIVE-3649.oracle.sql}} that contains following line:

          {code}
          alter table SDS add IS_STOREDASSUBDIRECTORIES NUMBER(1) NOT NULL;
          {code}

          This query will however fail if the table SDS have at least one column.
          The problem is in following file {{011-HIVE-3649.oracle.sql}} that contains following line:

          {code}
          alter table SDS add IS_STOREDASSUBDIRECTORIES NUMBER(1) NOT NULL;
          {code}

          This query will however fail if the table SDS have at least one row.
          Mark Grover made changes -
          Link This issue is related to HIVE-3995 [ HIVE-3995 ]
          Hide
          Mark Grover added a comment -

          +1 (non-committer)

          Show
          Mark Grover added a comment - +1 (non-committer)
          Mark Grover made changes -
          Link This issue is related to HIVE-3999 [ HIVE-3999 ]
          Hide
          Namit Jain added a comment -

          Committed. Thanks Jarek and Mark

          Show
          Namit Jain added a comment - Committed. Thanks Jarek and Mark
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags Reviewed [ 10343 ]
          Fix Version/s 0.11.0 [ 12323587 ]
          Resolution Fixed [ 1 ]
          Hide
          Hudson added a comment -

          Integrated in hive-trunk-hadoop1 #73 (See https://builds.apache.org/job/hive-trunk-hadoop1/73/)
          HIVE-3998 Oracle metastore update script will fail when upgrading from 0.9.0 to
          0.10.0 (Jarek and Mark via namit) (Revision 1443955)

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

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

          Thanks Namit! Could you look at HIVE-3995 as well when you get a chance? It does the same change to PostgreSQL scripts.

          Show
          Mark Grover added a comment - Thanks Namit! Could you look at HIVE-3995 as well when you get a chance? It does the same change to PostgreSQL scripts.
          Hide
          Hudson added a comment -

          Integrated in Hive-trunk-hadoop2 #112 (See https://builds.apache.org/job/Hive-trunk-hadoop2/112/)
          HIVE-3998 Oracle metastore update script will fail when upgrading from 0.9.0 to
          0.10.0 (Jarek and Mark via namit) (Revision 1443955)

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

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

          Integrated in Hive-trunk-h0.21 #1961 (See https://builds.apache.org/job/Hive-trunk-h0.21/1961/)
          HIVE-3998 Oracle metastore update script will fail when upgrading from 0.9.0 to
          0.10.0 (Jarek and Mark via namit) (Revision 1443955)

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

          • /hive/trunk/metastore/scripts/upgrade/oracle/011-HIVE-3649.oracle.sql
          Show
          Hudson added a comment - Integrated in Hive-trunk-h0.21 #1961 (See https://builds.apache.org/job/Hive-trunk-h0.21/1961/ ) HIVE-3998 Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0 (Jarek and Mark via namit) (Revision 1443955) Result = SUCCESS namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1443955 Files : /hive/trunk/metastore/scripts/upgrade/oracle/011- HIVE-3649 .oracle.sql
          Jarek Jarcec Cecho made changes -
          Link This issue is related too HIVE-4024 [ HIVE-4024 ]
          Jarek Jarcec Cecho made changes -
          Assignee Jarek Jarcec Cecho [ jarcec ]
          Gavin made changes -
          Link This issue is related to HIVE-4024 [ HIVE-4024 ]
          Gavin made changes -
          Link This issue is related to HIVE-4024 [ HIVE-4024 ]
          Owen O'Malley made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development