[jira] [Updated] (HIVE-3998) Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0

2013-02-08 Thread Namit Jain (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Namit Jain updated HIVE-3998:
-

   Resolution: Fixed
Fix Version/s: 0.11.0
 Hadoop Flags: Reviewed
   Status: Resolved  (was: Patch Available)

Committed. Thanks Jarek and Mark

> Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0
> 
>
> Key: HIVE-3998
> URL: https://issues.apache.org/jira/browse/HIVE-3998
> Project: Hive
>  Issue Type: Bug
>  Components: Metastore
>Reporter: Jarek Jarcec Cecho
> Fix For: 0.11.0
>
> Attachments: oracle_update_issue.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3998) Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0

2013-02-07 Thread Jarek Jarcec Cecho (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jarek Jarcec Cecho updated HIVE-3998:
-

Status: Patch Available  (was: Open)

> Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0
> 
>
> Key: HIVE-3998
> URL: https://issues.apache.org/jira/browse/HIVE-3998
> Project: Hive
>  Issue Type: Bug
>  Components: Metastore
>Reporter: Jarek Jarcec Cecho
> Attachments: oracle_update_issue.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3998) Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0

2013-02-07 Thread Jarek Jarcec Cecho (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jarek Jarcec Cecho updated HIVE-3998:
-

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 row.

  was:
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.


> Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0
> 
>
> Key: HIVE-3998
> URL: https://issues.apache.org/jira/browse/HIVE-3998
> Project: Hive
>  Issue Type: Bug
>  Components: Metastore
>Reporter: Jarek Jarcec Cecho
> Attachments: oracle_update_issue.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (HIVE-3998) Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0

2013-02-07 Thread Jarek Jarcec Cecho (JIRA)

 [ 
https://issues.apache.org/jira/browse/HIVE-3998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jarek Jarcec Cecho updated HIVE-3998:
-

Attachment: oracle_update_issue.patch

> Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0
> 
>
> Key: HIVE-3998
> URL: https://issues.apache.org/jira/browse/HIVE-3998
> Project: Hive
>  Issue Type: Bug
>  Components: Metastore
>Reporter: Jarek Jarcec Cecho
> Attachments: oracle_update_issue.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira