HIVE-3814 : Cannot drop partitions on table when using Oracle metastore (Deepesh Khandelwal via Ashutosh Chauhan)
git-svn-id: https://svn.apache.org/repos/asf/hive/branches/branch-0.10@1423492 13f79535-47bb-0310-9956-ffa450edef68
diff --git a/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql b/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
index 9624035..b4ce99e 100644
--- a/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
+++ b/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
@@ -28,7 +28,7 @@
CS_ID NUMBER NOT NULL,
DB_NAME VARCHAR2(128) NOT NULL,
TABLE_NAME VARCHAR2(128) NOT NULL,
- PART_NAME VARCHAR2(767) NOT NULL,
+ PARTITION_NAME VARCHAR2(767) NOT NULL,
COLUMN_NAME VARCHAR2(128) NOT NULL,
COLUMN_TYPE VARCHAR2(128) NOT NULL,
PART_ID NUMBER NOT NULL,
diff --git a/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql b/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
index 2cec9d2..4d084ad 100644
--- a/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
+++ b/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
@@ -481,7 +481,7 @@
CS_ID NUMBER NOT NULL,
DB_NAME VARCHAR2(128) NOT NULL,
TABLE_NAME VARCHAR2(128) NOT NULL,
- PART_NAME VARCHAR2(767) NOT NULL,
+ PARTITION_NAME VARCHAR2(767) NOT NULL,
COLUMN_NAME VARCHAR2(128) NOT NULL,
COLUMN_TYPE VARCHAR2(128) NOT NULL,
PART_ID NUMBER NOT NULL,
diff --git a/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql b/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
index fc263f5..0256158 100644
--- a/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
+++ b/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
@@ -31,7 +31,7 @@
"CS_ID" bigint NOT NULL,
"DB_NAME" character varying(128) DEFAULT NULL::character varying,
"TABLE_NAME" character varying(128) DEFAULT NULL::character varying,
- "PART_NAME" character varying(767) DEFAULT NULL::character varying,
+ "PARTITION_NAME" character varying(767) DEFAULT NULL::character varying,
"COLUMN_NAME" character varying(128) DEFAULT NULL::character varying,
"COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
"PART_ID" bigint NOT NULL,
@@ -52,4 +52,4 @@
ALTER TABLE ONLY "PART_COL_STATS" ADD CONSTRAINT "PART_COL_STATS_pkey" PRIMARY KEY("CS_ID");
ALTER TABLE ONLY "PART_COL_STATS" ADD CONSTRAINT "PART_COL_STATS_fkey" FOREIGN KEY("PART_ID") REFERENCES "PARTITIONS"("PART_ID") DEFERRABLE;
-CREATE INDEX "PART_COL_STATS_N49" ON "PART_COL_STATS" USING btree ("PART_ID");
\ No newline at end of file
+CREATE INDEX "PART_COL_STATS_N49" ON "PART_COL_STATS" USING btree ("PART_ID");
diff --git a/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql b/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
index ab3d43a..78212da 100644
--- a/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
+++ b/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
@@ -509,7 +509,7 @@
"CS_ID" bigint NOT NULL,
"DB_NAME" character varying(128) DEFAULT NULL::character varying,
"TABLE_NAME" character varying(128) DEFAULT NULL::character varying,
- "PART_NAME" character varying(767) DEFAULT NULL::character varying,
+ "PARTITION_NAME" character varying(767) DEFAULT NULL::character varying,
"COLUMN_NAME" character varying(128) DEFAULT NULL::character varying,
"COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
"PART_ID" bigint NOT NULL,
