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:56:12 UTC
[hive] branch branch-3 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 branch-3
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/branch-3 by this push:
new 52aeb29 HIVE-21336: Creation of PCS_STATS_IDX fails Oracle when NLS_LENGTH_SEMANTICS=char (Naveen Gangam, reviewed by Yongzhi Chen)
52aeb29 is described below
commit 52aeb292568a0ab4a4e2b471e97d1b0be3377c90
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)
Conflicts:
standalone-metastore/metastore-server/src/main/sql/oracle/hive-schema-4.0.0.oracle.sql
standalone-metastore/metastore-server/src/main/sql/oracle/upgrade-3.2.0-to-4.0.0.oracle.sql
---
standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql | 4 ++++
standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql | 4 ++++
standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql | 4 ++++
.../src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql | 3 +++
4 files changed, 15 insertions(+)
diff --git a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
index 3e2e282..93e032f 100644
--- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
+++ b/standalone-metastore/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/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
index b738ebe..895ee48 100644
--- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
+++ b/standalone-metastore/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/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
index f1d9699..36a4696 100644
--- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.2.0.oracle.sql
+++ b/standalone-metastore/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/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql b/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
index 71f5034..91626dd 100644
--- a/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
+++ b/standalone-metastore/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
(