You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ng...@apache.org on 2019/03/13 18:20:38 UTC
[hive] branch master updated: HIVE-21336: Creation of PCS_STATS_IDX
fails Oracle when NLS_LENGTH_SEMANTICS=char (Naveen Gangam,
reviewed by Yongzhi Chen)
This is an automated email from the ASF dual-hosted git repository.
ngangam pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push:
new 05ca910 HIVE-21336: Creation of PCS_STATS_IDX fails Oracle when NLS_LENGTH_SEMANTICS=char (Naveen Gangam, reviewed by Yongzhi Chen)
05ca910 is described below
commit 05ca910b48083ce2d26725723b5840e3b7ae812e
Author: Naveen Gangam <ng...@apache.org>
AuthorDate: Wed Mar 13 14:20:14 2019 -0400
HIVE-21336: Creation of PCS_STATS_IDX fails Oracle when NLS_LENGTH_SEMANTICS=char (Naveen Gangam, reviewed by Yongzhi Chen)
---
.../metastore-server/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql | 4 ++++
.../metastore-server/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql | 4 ++++
.../metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql | 4 ++++
.../metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql | 4 ++++
.../src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql | 3 +++
.../src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql | 3 +++
6 files changed, 22 insertions(+)
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
index 3e2e282..93e032f 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
@@ -1,6 +1,10 @@
-- Table SEQUENCE_TABLE is an internal table required by DataNucleus.
-- NOTE: Some versions of SchemaTool do not automatically generate this table.
-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+
+-- HIVE-21336 safeguards from failures from indices being too long
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
CREATE TABLE SEQUENCE_TABLE
(
SEQUENCE_NAME VARCHAR2(255) NOT NULL,
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
index b738ebe..895ee48 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
@@ -1,6 +1,10 @@
-- Table SEQUENCE_TABLE is an internal table required by DataNucleus.
-- NOTE: Some versions of SchemaTool do not automatically generate this table.
-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+
+-- HIVE-21336 safeguards from failures from indices being too long
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
CREATE TABLE SEQUENCE_TABLE
(
SEQUENCE_NAME VARCHAR2(255) NOT NULL,
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
index 6b95fba..8b91146 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
@@ -1,6 +1,10 @@
-- Table SEQUENCE_TABLE is an internal table required by DataNucleus.
-- NOTE: Some versions of SchemaTool do not automatically generate this table.
-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+
+-- HIVE-21336 safeguards from failures from indices being too long
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
CREATE TABLE SEQUENCE_TABLE
(
SEQUENCE_NAME VARCHAR2(255) NOT NULL,
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
index a861d3d..16140d1 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
@@ -1,6 +1,10 @@
-- Table SEQUENCE_TABLE is an internal table required by DataNucleus.
-- NOTE: Some versions of SchemaTool do not automatically generate this table.
-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+
+-- HIVE-21336 safeguards from failures from indices being too long
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
CREATE TABLE SEQUENCE_TABLE
(
SEQUENCE_NAME VARCHAR2(255) NOT NULL,
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
index c9c6b30..b548665 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
@@ -1,5 +1,8 @@
SELECT 'Upgrading MetaStore schema from 2.3.0 to 3.0.0' AS Status from dual;
+-- HIVE-21336 safeguards from failures from indices being too long
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
--@041-HIVE-16556.oracle.sql;
CREATE TABLE METASTORE_DB_PROPERTIES
(
diff --git a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql
index 3dd266e..27b2bd9 100644
--- a/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql
@@ -1,5 +1,8 @@
SELECT 'Upgrading MetaStore schema from 3.2.0 to 4.0.0' AS Status from dual;
+-- HIVE-21336 safeguards from changes user may have made after 3.x schema was installed.
+ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
+
ALTER TABLE TBLS ADD WRITE_ID number DEFAULT 0 NOT NULL;
ALTER TABLE PARTITIONS ADD WRITE_ID number DEFAULT 0 NOT NULL;