FAQ
Author: hashutosh
Date: Tue Dec 18 15:53:28 2012
New Revision: 1423488

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

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

Modified: hive/trunk/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql?rev=1423488&r1=1423487&r2=1423488&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/oracle/012-HIVE-1362.oracle.sql Tue Dec 18 15:53:28 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/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql?rev=1423488&r1=1423487&r2=1423488&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.10.0.oracle.sql Tue Dec 18 15:53:28 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/trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql?rev=1423488&r1=1423487&r2=1423488&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql Tue Dec 18 15:53:28 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/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql?rev=1423488&r1=1423487&r2=1423488&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.10.0.postgres.sql Tue Dec 18 15:53:28 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,

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedDec 18, '12 at 3:53p
activeDec 18, '12 at 3:53p
posts1
users1
websitehive.apache.org

1 user in discussion

Hashutosh: 1 post

People

Translate

site design / logo © 2021 Grokbase