You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2012/12/18 16:55:24 UTC
svn commit: r1423492 - in /hive/branches/branch-0.10/metastore/scripts/upgrade: oracle/012-HIVE-1362.oracle.sql oracle/hive-schema-0.10.0.oracle.sql postgres/012-HIVE-1362.postgres.sql postgres/hive-schema-0.10.0.postgres.sql

Author: hashutosh
Date: Tue Dec 18 15:55:24 2012
New Revision: 1423492

URL: http://svn.apache.org/viewvc?rev=1423492&view=rev
Log:
HIVE-3814 : Cannot drop partitions on table when using Oracle metastore (Deepesh Khandelwal via Ashutosh Chauhan)

Modified:
    hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
    hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
    hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
    hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql

Modified: hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql?rev=1423492&r1=1423491&r2=1423492&view=diff
==============================================================================
--- hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql (original)
+++ hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql Tue Dec 18 15:55:24 2012
@@ -28,7 +28,7 @@ CREATE TABLE PART_COL_STATS (
  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,

Modified: hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql?rev=1423492&r1=1423491&r2=1423492&view=diff
==============================================================================
--- hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql (original)
+++ hive/branches/branch-0.10/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql Tue Dec 18 15:55:24 2012
@@ -481,7 +481,7 @@ CREATE TABLE PART_COL_STATS (
  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,

Modified: hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql?rev=1423492&r1=1423491&r2=1423492&view=diff
==============================================================================
--- hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql (original)
+++ hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql Tue Dec 18 15:55:24 2012
@@ -31,7 +31,7 @@ CREATE TABLE "PART_COL_STATS" (
  "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 @@ CREATE TABLE "PART_COL_STATS" (
 
 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");

Modified: hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql?rev=1423492&r1=1423491&r2=1423492&view=diff
==============================================================================
--- hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql (original)
+++ hive/branches/branch-0.10/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql Tue Dec 18 15:55:24 2012
@@ -509,7 +509,7 @@ CREATE TABLE "PART_COL_STATS" (
  "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,