hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c..@apache.org
Subject svn commit: r1151949 - /hive/trunk/metastore/scripts/upgrade/postgres/
Date Thu, 28 Jul 2011 18:09:56 GMT
Author: cws
Date: Thu Jul 28 18:09:55 2011
New Revision: 1151949

URL: http://svn.apache.org/viewvc?rev=1151949&view=rev
Log:
HIVE-2307. Schema creation scripts for PostgreSQL use bit(1) instead of boolean (Esteban Gutierrez
via cws)

Modified:
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.3.0.postgres.sql
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.0.postgres.sql
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.1.postgres.sql
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql
    hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.3.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.3.0.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.3.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.3.0.postgres.sql Thu Jul 28
18:09:55 2011
@@ -79,7 +79,7 @@ CREATE INDEX "PARTITION_PARAMS_N49" on "
 CREATE TABLE "SDS" (
   "SD_ID" bigint NOT NULL,
   "INPUT_FORMAT" character varying(256) DEFAULT NULL,
-  "IS_COMPRESSED" bit(1) NOT NULL,
+  "IS_COMPRESSED" boolean NOT NULL,
   "LOCATION" character varying(767) DEFAULT NULL,
   "NUM_BUCKETS" bigint NOT NULL,
   "OUTPUT_FORMAT" character varying(256) DEFAULT NULL,

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.0.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.0.postgres.sql Thu Jul 28
18:09:55 2011
@@ -79,7 +79,7 @@ CREATE INDEX "PARTITION_PARAMS_N49" on "
 CREATE TABLE "SDS" (
   "SD_ID" bigint NOT NULL,
   "INPUT_FORMAT" character varying(256) DEFAULT NULL,
-  "IS_COMPRESSED" bit(1) NOT NULL,
+  "IS_COMPRESSED" boolean NOT NULL,
   "LOCATION" character varying(767) DEFAULT NULL,
   "NUM_BUCKETS" bigint NOT NULL,
   "OUTPUT_FORMAT" character varying(256) DEFAULT NULL,

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.1.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.1.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.1.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.4.1.postgres.sql Thu Jul 28
18:09:55 2011
@@ -79,7 +79,7 @@ CREATE INDEX "PARTITION_PARAMS_N49" on "
 CREATE TABLE "SDS" (
   "SD_ID" bigint NOT NULL,
   "INPUT_FORMAT" character varying(256) DEFAULT NULL,
-  "IS_COMPRESSED" bit(1) NOT NULL,
+  "IS_COMPRESSED" boolean NOT NULL,
   "LOCATION" character varying(767) DEFAULT NULL,
   "NUM_BUCKETS" bigint NOT NULL,
   "OUTPUT_FORMAT" character varying(256) DEFAULT NULL,

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.5.0.postgres.sql Thu Jul 28
18:09:55 2011
@@ -79,7 +79,7 @@ CREATE INDEX "PARTITION_PARAMS_N49" on "
 CREATE TABLE "SDS" (
   "SD_ID" bigint NOT NULL,
   "INPUT_FORMAT" character varying(256) DEFAULT NULL,
-  "IS_COMPRESSED" bit(1) NOT NULL,
+  "IS_COMPRESSED" boolean NOT NULL,
   "LOCATION" character varying(767) DEFAULT NULL,
   "NUM_BUCKETS" bigint NOT NULL,
   "OUTPUT_FORMAT" character varying(256) DEFAULT NULL,

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.7.0.postgres.sql Thu Jul 28
18:09:55 2011
@@ -57,7 +57,7 @@ CREATE INDEX "DB_PRIVS_N49" on "DB_PRIVS
 CREATE TABLE "IDXS" (
   "INDEX_ID" bigint NOT NULL,
   "CREATE_TIME" bigint NOT NULL,
-  "DEFERRED_REBUILD" bit(1) NOT NULL,
+  "DEFERRED_REBUILD" boolean NOT NULL,
   "INDEX_HANDLER_CLASS" character varying(4000) DEFAULT NULL,
   "INDEX_NAME" character varying(128) DEFAULT NULL,
   "INDEX_TBL_ID" bigint DEFAULT NULL,
@@ -193,7 +193,7 @@ CREATE INDEX "ROLE_MAP_N49" on "ROLE_MAP
 CREATE TABLE "SDS" (
   "SD_ID" bigint NOT NULL,
   "INPUT_FORMAT" character varying(4000) DEFAULT NULL,
-  "IS_COMPRESSED" bit(1) NOT NULL,
+  "IS_COMPRESSED" boolean NOT NULL,
   "LOCATION" character varying(4000) DEFAULT NULL,
   "NUM_BUCKETS" bigint NOT NULL,
   "OUTPUT_FORMAT" character varying(4000) DEFAULT NULL,

Modified: hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql?rev=1151949&r1=1151948&r2=1151949&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/upgrade-0.6.0-to-0.7.0.postgres.sql Thu
Jul 28 18:09:55 2011
@@ -5,7 +5,7 @@ SELECT '< HIVE-417 Implement Indexing in
 CREATE TABLE "IDXS" (
   "INDEX_ID" bigint NOT NULL,
   "CREATE_TIME" bigint NOT NULL,
-  "DEFERRED_REBUILD" bit(1) NOT NULL,
+  "DEFERRED_REBUILD" boolean NOT NULL,
   "INDEX_HANDLER_CLASS" character varying(256) DEFAULT NULL,
   "INDEX_NAME" character varying(128) DEFAULT NULL,
   "INDEX_TBL_ID" bigint DEFAULT NULL,



Mime
View raw message