GitHub user rmartin-rp opened a pull request:
https://github.com/apache/hive/pull/232
Update 039-HIVE-12274.oracle.sql
You cannot modify a column from VARCHAR2(4000) to CLOB directly. You need
to add a new column and drop the old one or recreate the table. I chose to
recreate the table because it's more clean.
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1770086700346491686
Also, if you do something like:
ALTER TABLE COLUMNS_V2 MODIFY (COLUMN_NAME VARCHAR(767) NOT NULL);
And the column is already NOT NULL, the ALTER TABLE fails. I removed 2
like this.
I hope it helps.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/rmartin-rp/hive patch-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/hive/pull/232.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #232
----
commit 4ff45b78f16171a808a2635705d22536db34dfb4
Author: rmartin-rp <rmar...@ravenpack.com>
Date: 2017-08-15T15:39:24Z
Update 039-HIVE-12274.oracle.sql
You cannot modify a column from VARCHAR2(4000) to CLOB directly. You need
to add a new column and drop the old one or recreate the table. I chose to
recreate the table because it's more clean.
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1770086700346491686
Also, if you do something like:
ALTER TABLE COLUMNS_V2 MODIFY (COLUMN_NAME VARCHAR(767) NOT NULL);
And the column is already NOT NULL, the ALTER TABLE fails. I removed 2
like this.
I hope it helps.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
