You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2017/12/04 16:28:00 UTC
[jira] [Updated] (HIVE-17333) Schema changes in HIVE-12274 for
Oracle may not work for upgrade
[ https://issues.apache.org/jira/browse/HIVE-17333?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naveen Gangam updated HIVE-17333:
---------------------------------
Attachment: HIVE-17333.patch
Attaching a patch that uses a temp column for Oracle upgrade script to convert from Varchar2 to CLOBs for the columns fixed in HIVE-12274.
> Schema changes in HIVE-12274 for Oracle may not work for upgrade
> ----------------------------------------------------------------
>
> Key: HIVE-17333
> URL: https://issues.apache.org/jira/browse/HIVE-17333
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 3.0.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Attachments: HIVE-17333.patch
>
>
> According to https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1770086700346491686 (reported in HIVE-12274)
> The alter table command to change the column datatype from {{VARCHAR}} to {{CLOB}} may not work. So the correct way to accomplish this is to add a new temp column, copy the value from the current column, drop the current column and rename the new column to old column.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)