FAQ
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,

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedJul 28, '11 at 6:10p
activeJul 28, '11 at 6:10p
posts1
users1
websitehive.apache.org

1 user in discussion

Cws: 1 post

People

Translate

site design / logo © 2021 Grokbase