You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2011/07/28 20:09:56 UTC
svn commit: r1151949 - /hive/trunk/metastore/scripts/upgrade/postgres/
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,