You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2012/06/04 09:18:22 UTC
[jira] [Created] (HIVE-3082) Oracle Metastore schema script doesn't
include DDL for DN internal tables
Carl Steinbach created HIVE-3082:
------------------------------------
Summary: Oracle Metastore schema script doesn't include DDL for DN internal tables
Key: HIVE-3082
URL: https://issues.apache.org/jira/browse/HIVE-3082
Project: Hive
Issue Type: Bug
Components: Metastore
Affects Versions: 0.9.0
Reporter: Carl Steinbach
Assignee: Carl Steinbach
Fix For: 0.10.0
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Mithun Radhakrishnan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13291228#comment-13291228 ]
Mithun Radhakrishnan commented on HIVE-3082:
--------------------------------------------
Thanks for the fix, Carl. We just ran into this ourselves, during the migration.
Much appreciated.
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0, 0.9.1
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288382#comment-13288382 ]
Carl Steinbach commented on HIVE-3082:
--------------------------------------
Missing tables: NUCLEUS_TABLES, SEQUENCE_TABLE.
Probable cause: http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290802#comment-13290802 ]
Carl Steinbach commented on HIVE-3082:
--------------------------------------
@Ashutosh: I actually tried 2.1.1 out and wasn't able to get it to work. Either the fixVersion field is incorrect or this is still broken.
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3082) Oracle Metastore schema script doesn't
include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3082:
---------------------------------
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed to trunk.
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290573#comment-13290573 ]
Ashutosh Chauhan commented on HIVE-3082:
----------------------------------------
+1
As an aside, cited DN bug seems to have been fixed in 2.1.1 Hive being stuck on an ancient unsupported version 2.0.3 will keep biting us in one way or another.
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3082) Oracle Metastore schema script doesn't
include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3082:
---------------------------------
Status: Patch Available (was: Open)
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3082) Oracle Metastore schema script doesn't
include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3082:
---------------------------------
Attachment: HIVE-3082.1.patch.txt
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290827#comment-13290827 ]
Hudson commented on HIVE-3082:
------------------------------
Integrated in Hive-0.9.1-SNAPSHOT-h0.21 #40 (See [https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/40/])
HIVE-3082. Oracle Metastore schema script doesn't include DDL for DN internal tables (Revision 1347399)
Result = FAILURE
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1347399
Files :
* /hive/branches/branch-0.9/metastore/scripts/upgrade/oracle/hive-schema-0.9.0.oracle.sql
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0, 0.9.1
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-3082) Oracle Metastore schema script doesn't
include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3082:
---------------------------------
Fix Version/s: 0.9.1
Backported to 0.9.1
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0, 0.9.1
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290840#comment-13290840 ]
Hudson commented on HIVE-3082:
------------------------------
Integrated in Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #40 (See [https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/40/])
HIVE-3082. Oracle Metastore schema script doesn't include DDL for DN internal tables (Revision 1347399)
Result = FAILURE
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1347399
Files :
* /hive/branches/branch-0.9/metastore/scripts/upgrade/oracle/hive-schema-0.9.0.oracle.sql
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0, 0.9.1
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3082) Oracle Metastore schema script
doesn't include DDL for DN internal tables
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13288956#comment-13288956 ]
Carl Steinbach commented on HIVE-3082:
--------------------------------------
Will post a review request on reviewboard once that service is back up.
@Ashutosh: Can you please review this? Thanks.
> Oracle Metastore schema script doesn't include DDL for DN internal tables
> -------------------------------------------------------------------------
>
> Key: HIVE-3082
> URL: https://issues.apache.org/jira/browse/HIVE-3082
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 0.9.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.10.0
>
> Attachments: HIVE-3082.1.patch.txt
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira